If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link in MS Access to display image specific to a record
Using MS Access 2003. In a Form, I want to have an image (eg, photo) show up
specific to the Form data being entered. Eg a human records Personnel form where I want the persons photo to show up on the Form. How best to do this? |
#2
|
|||
|
|||
Link in MS Access to display image specific to a record
Have a look at:
http://www.datastrat.com/Download/Picture2K.zip It loads pictures stored on the file system into a form or report on the fly. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Scorpisnake" wrote in message ... Using MS Access 2003. In a Form, I want to have an image (eg, photo) show up specific to the Form data being entered. Eg a human records Personnel form where I want the persons photo to show up on the Form. How best to do this? |
#3
|
|||
|
|||
Link in MS Access to display image specific to a record
"Scorpisnake" wrote
Using MS Access 2003. In a Form, I want to have an image (eg, photo) show up specific to the Form data being entered. Eg a human records Personnel form where I want the persons photo to show up on the Form. How best to do this? The sample imaging databases at http://accdevel.tripod.com illustrate three approaches to handling images in Access, and the download includes an article discussing considerations in choosing an approach. Two of the approaches do not use OLE Objects and, thus, avoid the database bloat, and some other problems, associated with images in OLE Objects. If you are printing the images in reports, to avoid memory leakage, you should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm. PrintFailure.zip is an Access97 MDB containing a report that fails during the Access formatting process prior to being spooled to the Printer Driver. This MDB also contains code showing how to convert the contents of the Image control to a Bitmap file prior to printing. This helps alleviate the "Out of Memory" error that can popup when printing image intensive reports. Larry Linson Microsoft Access MVP |
#4
|
|||
|
|||
Link in MS Access to display image specific to a record
Thanks Arvin & Larry (second responder to post).
Perhaps I didn't quite phrase my question accurately. I've created an 'Object' frame in my Form. I managed to get it to show the image I wanted for that form, (which didn't appear for the next data record so I'm assuming I did something right) - but I can't figure out how what I must have changed to make it work. I deleted the test data row in the source Table that had the image appearing in that one test entry correctly to fix another problem and recreated the same test data entry, but now, despite confirming all the options are set to display the CONTENT, the image appears as an icon in the frame. Makes no difference in what format the source image is (I've tried bmp, jpg, wmf), and it makes no difference whether I've selected embedded or linked for the property. The image files are all in multiple folders under each persons' name - not a central image folder where all pictures are kept. If you can see what I'm trying to get at here and have another suggestion, I'd be very grateful to hear from you once again. And ... happy new year, and thanks for your time. "Arvin Meyer [MVP]" wrote: Have a look at: http://www.datastrat.com/Download/Picture2K.zip It loads pictures stored on the file system into a form or report on the fly. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Scorpisnake" wrote in message ... Using MS Access 2003. In a Form, I want to have an image (eg, photo) show up specific to the Form data being entered. Eg a human records Personnel form where I want the persons photo to show up on the Form. How best to do this? |
#5
|
|||
|
|||
Link in MS Access to display image specific to a record
Instead of an Object control, use an Image control. The line of code that
makes it work is: Me.ImageControlName.Picture = "C:\Path To Image.bmp" Again, look at the download: http://www.datastrat.com/Download/Picture2K.zip and use it to gather all your images into a table. The add the ID of the Personnel record to the table. Link them in a query and use data in the table to create the path to the image file. You can do it with an OLE Object as well, but it is much more difficult. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Scorpisnake" wrote in message ... Thanks Arvin & Larry (second responder to post). Perhaps I didn't quite phrase my question accurately. I've created an 'Object' frame in my Form. I managed to get it to show the image I wanted for that form, (which didn't appear for the next data record so I'm assuming I did something right) - but I can't figure out how what I must have changed to make it work. I deleted the test data row in the source Table that had the image appearing in that one test entry correctly to fix another problem and recreated the same test data entry, but now, despite confirming all the options are set to display the CONTENT, the image appears as an icon in the frame. Makes no difference in what format the source image is (I've tried bmp, jpg, wmf), and it makes no difference whether I've selected embedded or linked for the property. The image files are all in multiple folders under each persons' name - not a central image folder where all pictures are kept. If you can see what I'm trying to get at here and have another suggestion, I'd be very grateful to hear from you once again. And ... happy new year, and thanks for your time. "Arvin Meyer [MVP]" wrote: Have a look at: http://www.datastrat.com/Download/Picture2K.zip It loads pictures stored on the file system into a form or report on the fly. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Scorpisnake" wrote in message ... Using MS Access 2003. In a Form, I want to have an image (eg, photo) show up specific to the Form data being entered. Eg a human records Personnel form where I want the persons photo to show up on the Form. How best to do this? |
Thread Tools | |
Display Modes | |
|
|