Retrieving filename

[Richard Wright]

Hi Everyone - I need some more help. I'm trying to prompt my user for a
filename that I will store in a field. I'm using the following code:
|
| Dim stDocName, stMessage, stTitle
| stMessage = "Enter filename: "
| stTitle = "Get Photo"
| stDocName = InputBox(stMessage, stTitle, Default)
| Photo = stDocName
|

which works, but has one, if not more, major drawback the user must know the
filename. Is there a way in vba to have the file dialog box open so the
user can browse for the file? Any help is greatly appreciated. - Rick

 

[Arvin Meyer [MVP]]

Have a look at this on the Access Web:

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

 

[Larry Linson]

Is there a way in vba to have the file dialog
box open so the user can browse for the file?

http://www.mvps.org/access/api/api0001.htm has code you can use.

Larry Linson
Microsoft Access MVP

 

[Richard Wright]

Thank you Larry and Arvin - Rick

http://www.mvps.org/access/api/api0001.htm has code you can use.

Larry Linson
Microsoft Access MVP