Application.GetOpenFilename

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have been using Application.GetOpenFilename and it has been working fine,
but for some reason it does work anymore.... The error I get is 'method or
data member not found'.

Can anyone help me?

Thanks in advance
K
 
In
KurviousKoala said:
Hello,

I have been using Application.GetOpenFilename and it has been working
fine, but for some reason it does work anymore.... The error I get is
'method or data member not found'.
Click to expand...

There's no GetOpenFilename method in the Access Application object, so
far as I know. In Access 2002 and later, there's a FileDialog method.
Or you can call the Windows API directly, using code such as is posted
here:

http://www.mvps.org/access/api/api0001.htm
 
Can you do this for Folder contents? I just need to see whats in a Folder and
write the folder and file name to a database
 
In
JoeF said:
Can you do this for Folder contents? I just need to see whats in a
Folder and write the folder and file name to a database
Click to expand...

I'm not sure what you mean. The GetOpenFile API method displays the
contents of the folder to let you pick a file. If you just want to pick
a folder, you can call the Windows BrowseFolder API method instead,
using code such as is posted at:

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

If it's something else you have in mind, please explain a bit more.
 
Back
Top