RE: Add Photos and Documents

Hi Lisa,
Thank you for your post;
Access will happily accept Windows bitmap (.bmp) files as OLE objects and you should not need a separate graphics filter installed to insert Enhanced Metafile (.emf), and (.rle, .dib) files, or Windows Metafile (.wmf), and icon (.ico) graphics. However, you will need a graphics filter installed to insert all other graphics file formats, if you have to use .jpg files you may have to use a filter to accomplish this. You should ensure that your photographs have been correctly identified with unique names/numbers etc. it would also help if they were all (or copies of them) were in the same folder. Then follow these steps: In your table in design view create an OLE object field. Save the table, in Table view select the blank field in the record of your choice and from the Insert menu select Object, from the dialog box that opens, select Create from file and click Link and then Browse, navigate to your folder and select the correct photo for that record. Create a Form based on the table or query which has the OLE field in it and you should then be able to view your photo on the correct record. If you are not using the .bmp file format, it is possible that you may see the text "Package" in the field, if this is the case your picture will not display in the form or report. You may find however that your access database can 'bloat' and become quite large.
To bring all of this back to earth, I find that the best method is to create a hyperlink to a presentation such as PowerPoint and have my photos on different single files in PowerPoint shows, then when I click the hyperlink (or button) I can get the correct PowerPoint presentation (saved as a PowerPoint Show) to open in a popup window, this saves your database from bloating and allows you to change the individual PowerPoint presentation if any photos are updated. I hope that helps, regards Pete