choosing multiple files at once in a sub-form

[darren_access]

I found an eloquent method of choosing and storing imagepath/name for a record as opposed to storing the image in the db.

I need the ability to choose multiple images in the same dialog and not require the user to choose individual files over and over again.

On most occasions the user needs to choose multiple files from the same folder for attaching to a record, sometimes as many 9-10 pages. The control+select or shift+click simplicity is necessary to keep data entry fast and efficient.

Any suggestions?

Thank you!

 

[Mark_]

Darren,

Try THIS LINK to show you how you can do this in VBA.

Effectively you call the File Dialog to do multi-select. You then loop through the elements in SelectedItems and add each as a record to your attachment file.

Have you already done a search on how to declare your own record set and add records?