User-Entered Image Locations

[Joe]

I administer an exam database that stores the paths to image files for
certain questions. The paths are stored in a field called "Location."

I would like to create a user-friendly way to enter these paths. Is there a
way that I can have a user enter a path into the location field using a form?
This would similar to the process of sending an attachment via email, where
the user selects the "browse..." button and then may look through folders to
find the appropriate file location.

Any suggestions are greatly appreciated.

Thanks!

Joe

 

[Brian]

You can create a browse window using the Common Dialogue control or the
Windows API call. This is user-friendly, although you may not find building
the interface very programmer-friendly. Look at

http://www.mvps.org/access/api/api0001.htm

for instructions on using the API call to open the browse window and either
select files or set paths by capturing the browsed-to path and/or filename.

 

[Brian]

Search for comdlg32.dll in the Access Database Programming section of this
discussion group. This has a rather lengthy discussion thread that should
give you some info on using that API call effectively.

 

[Joe]

Thanks Brian! Code worked perfectly and was easy enough to tailor to my needs.

Best,

Joe