Q: how to capture user chosen file and path

[meckstro]

Hoping someone can tell me how to call open the dialogbox and allow the
user to choose any document on the hard drive and return that path and
file name in a variable to be stored and used later. Any help is greatly
appreciated. Thanks in advance...

 

[Dirk Goldgar]

Hoping someone can tell me how to call open the dialogbox and allow the
user to choose any document on the hard drive and return that path and
file name in a variable to be stored and used later. Any help is greatly
appreciated. Thanks in advance...

There's code to do this at:

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