64 Bit Access API for Navigating to Windows File

Buck_Beasom
Buck_Beasom used Ask the Experts™
on
What is the "Find File" API for Access 64 Bit? The attached file was provided by an Expert a few years ago and I use it extensively in Access applications. But it does not appear to work in the 64 Bit environment.

Is there a 64 Bit version of this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
I didn't look through these for Find file, but it is a complete list as far as I know:

http://www.microsoft.com/download/en/confirmation.aspx?displaylang=en&id=9970

http://msdn.microsoft.com/en-us/library/aa383663(VS.85).aspx

 But I don't think your talking about a Windows API...did you mean the open file dialog in Office?

Jim.
NorieAnalyst Assistant

Commented:
Are you sure it's an API you are looking for?

PS There's no file attached.
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
Why don't you just use the Application.FileDialog object?
Buck_BeasomDatabase Designer

Author

Commented:
Brilliant! Never used this before. I had to modify the code provided by the Access Help function slightly as when I use this I only want the user to select a single file (as opposed to adding a bunch to the list) but once I got things lined up right it worked perfectly.

Thanks!
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
glad I could help.

I used the API many moons ago, but have used the filedialog box for as long as I can remember.

Dale

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial