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
|
|||
|
|||
INSERTING IMAGE LINKS
I've searched and searched but cannot find an answer for this question:
I want to associate an image file for each records in my db. On the form displaying the records, I want to add a button that when clicked, will open up the image using the program associated with it. Currently the images are stored as jpegs and Microsoft Office Picture Manager is the program associated with these files. Please note, that I do NOT want to store the images within the database as it is my understanding that this will cause the db to bloat, nor do I want to display the image on the form. I tried inserting a hyperlink field into the table the form is based on, but when I click on the hyperlink in the form, access tells me it cannot open the file (fyi, Firefox is my default browser, but I tried opening the image using Firefox directly and it works!?!). I've also tried inserting a OLE object field in the table, but this didn't work. I could insert an object(image) into the first record, but when I attempted to insert the next object(image) into the next record, the db cannot find any images/files in the folder I have them stored. Method: Click Insert Object | Create from File | Browse ---- The popup window does not display my files?? Is this because they are jpegs and not bmps? Can someone please provide me with a step-by-step solution? Thanks in advance. |
#2
|
|||
|
|||
INSERTING IMAGE LINKS
FYI - I am using Access 2000 (and if it is relevant I also have Office
2003 [student/teacher ed.] installed. |
#3
|
|||
|
|||
INSERTING IMAGE LINKS
"sljack63" wrote
FYI - I am using Access 2000 (and if it is relevant I also have Office 2003 [student/teacher ed.] installed. 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
|
|||
|
|||
INSERTING IMAGE LINKS
Thank you so much. I did find a knowledgebase article that helped me as
well: http://support.microsoft.com/kb/285820/en-us "Larry Linson" wrote in message ... "sljack63" wrote FYI - I am using Access 2000 (and if it is relevant I also have Office 2003 [student/teacher ed.] installed. 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting hyper links | henryj | General Discussion | 2 | December 6th, 2005 03:07 PM |
Isn't a thumbnail view of image files available when inserting | E T | General Discussion | 2 | November 30th, 2005 05:49 PM |
problems inserting picture links in ole field msaccess | Graham (The Jock) Thomson. | General Discussion | 0 | April 12th, 2005 12:01 AM |
problems inserting picture links in ole field msaccess | Graham (The Jock) Thomson. | General Discussion | 0 | April 12th, 2005 12:00 AM |
Image Control Access 2002 | Tom | General Discussion | 8 | December 8th, 2004 08:11 AM |