getfile()??

T

tw

I'm used to programming in VFP and I'm looking for a function that prompts
the users to find a file, and returns the path and name of file the user
found. Is there a similar function in access? I've looked for something in
the vb help and haven't found it.
 
D

Dirk Goldgar

tw said:
I'm used to programming in VFP and I'm looking for a function that
prompts the users to find a file, and returns the path and name of
file the user found. Is there a similar function in access? I've
looked for something in the vb help and haven't found it.
Click to expand...

In Access 2002 or later, there's the Application.FileDialog object.
Partly because this isn't available in earlier versions, but also
because it's more flexible, most people prefer to call the Window File
Open/Save API dialog directly, using code such as that posted here:

www.mvps.org/access/api/api0001.htm
 
Top