GetOpenFilename Equivalent

[John Avitt]

I want to use an Open File dialog via code to enable a user to select a file
to import. Once the file is selected, the code will do the rest. Excel has a
GetOpenFilename function. Is there a similar function in Access?

Thank you.

John

 

[Dirk Goldgar]

I want to use an Open File dialog via code to enable a user to select
a file to import. Once the file is selected, the code will do the
rest. Excel has a GetOpenFilename function. Is there a similar
function in Access?

Access 2002 (I think) and later have an Application.FileDialog method,
but I always just call the Windows API directly:

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

 

[Douglas J. Steele]

I believe there's one in Access 2002 and newer, but using the API calls is
much better. There are limitations surrounding the built-in dialog.