Browse for file

[Lindsay Gillis]

Hello, I'm designing a form and report that allows the
user to print a photo with a description. I have the user
enter the name of the photo, then in code I tell Access
what folder to look in and add the .jpg extension. I'd
rather let the user have a browse button that would let
the user browse to the folder and file, then click on it
to bring it into the form. I can't find the method to do
this. Can someone help?
thanks
LG

 

[Bruce M. Thompson]

Hello, I'm designing a form and report that allows the

user to print a photo with a description. I have the user
enter the name of the photo, then in code I tell Access
what folder to look in and add the .jpg extension. I'd
rather let the user have a browse button that would let
the user browse to the folder and file, then click on it
to bring it into the form. I can't find the method to do
this. Can someone help?

See the following page at The Access Web for code and an example:

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm