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
|
|||
|
|||
Attaching Images in Bulk to a Form/Table with Access 2007
I want to bulk attach a large numbe rof image files from a folder to a form
using Access 2007 I have a very long list of Images in a single folder that I want to attach to seperate fields in a table/form. I am Using Access 2007 and thought that I would somehow be able to 'automate' the new 'file attachment' feature, but was surprised and dissapointed to discover that I would have to manually attach each single file onto 320 forms (x2 images per form) 640 times!, Is there a way around this problem without resorting to actually pasting/binding the images into a potentially huge mdb file. Each form record contains two images, where I want 2 images per form. The Image pairs correspond to the record number. For example. Record 005: W:\Foldername\Micromap Run 005 A.bmp =(5th record) W:\Foldername\Micromap Run 005 B.bmp =(5th record) The table format is: Run_No ImageRecord_A ImageRecord_B a fuller example of the folder/file naming convention is as follows: W:\Foldername\Micromap Run 001 A.bmp =(1st record) W:\Foldername\Micromap Run 001 B.bmp =(1st record) W:\Foldername\Micromap Run 002 A.bmp =(2nd record) W:\Foldername\Micromap Run 002 B.bmp =(2nd record) W:\Foldername\Micromap Run 003 A.bmp =(3rd record) W:\Foldername\Micromap Run 003 B.bmp =(3rd record) and so on... Is there a way of doing this automatically? The total list of records is 320 (x2 = 640 images) |
Thread Tools | |
Display Modes | |
|
|