getfile()??

[Guest]

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.

 

[Dirk Goldgar]

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.

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

 

[Guest]

thanks

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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)