Displaying Images in a Databse Form

[alexander]

How to Display Images in a Form or in a Report Without Storing the Images in a Table

http://support.microsoft.com/kb/148463

Auto generate lists of file paths with this spreadsheet tool:

» download directory lister

Save this spreadsheet, then open it in excel.  Choose the directory you want to list, then export and save the excel file.

Almost there...

*You'll need to merge the file path and file name fields.  I managed it by doing this:
to combine cells in Excel:

1.  Go to a new, blank sheet
2.  Paste the list of file paths into column A
3.  Paste the list of file names into column B
4.  In a cell where you want your merged list to appear type this formula:

e.g. =(A1&B1)

5. Press enter; the first 2 cells are merged
6. Fill down with the fill handle until all the files appear in the list
7.  Save the spreadsheet, import into access, then whacko! done.
8. copy the table back into excel
9. In MS Access, file > get external data > import the table
10. Follow the steps in the tutorial in the first link, and your form will display your images.

*This is not as complicated as it sounds (well, not quite...)