What to use for GetOpenFilename in Access?

P

plh

Dear Gurus,
The following routine works just fine in Excel (2000 9.0.6926 SP3) to bring up a
dialog window allowing the user to search for a file or folder, and the me to
capture the choice...

strCurrentFile = Application.GetOpenFilename(, , "Please choose the file you
want to process.")

....but it does not seem to be available in Access (also 2000 9.0.6926 SP3).
How do I get this or a similar function in Access?
Thank You,
-plh
 
R

RoyVidar

plh wrote in message said:
Dear Gurus,
The following routine works just fine in Excel (2000 9.0.6926 SP3) to bring
up a dialog window allowing the user to search for a file or folder, and the
me to capture the choice...

strCurrentFile = Application.GetOpenFilename(, , "Please choose the file you
want to process.")

...but it does not seem to be available in Access (also 2000 9.0.6926 SP3).
How do I get this or a similar function in Access?
Thank You,
-plh
Click to expand...

Check out this
http://www.mvps.org/access/api/api0001.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chdir does not seem to change the current directory -- ?? 5
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Count or Detect Graphic Objects in an Excel Spreadsheet Opened in Access? 0
GetOpenFileName 1
utilize getopenfilename dialog 8
GetOpenFilename with default filename? 5
Tablet PC / Access 2003 and Capturing Signatures 1
GetOpenFilename and filter "*." 2

Top