Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Find File    Find   Folder    dialogs?

Posted on 2004-10-13
6
Medium Priority
?
225 Views
Last Modified: 2012-06-21
In MS Access 2000........is there an EASY way to invoke a Find File or Find Folder  dialog box..........one that will allow me to pick a file and return a location?
0
Comment
Question by:Tom Knowlton
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 39

Accepted Solution

by:
stevbe earned 1000 total points
ID: 12301790
http://www.mvps.org/access/api/api0001.htm

this code might look long but once you have pasted it into a module the actual call to open the dialog box is simple.

Steve
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 12301800
Here's the MS solution for finding Files ... it's fairly easy:

http://support.microsoft.com/default.aspx?scid=kb;en-us;303066
0
 
LVL 85
ID: 12301812
Here's the Browse For Folder dialog:

http://www.mvps.org/access/api/api0002.htm
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 39

Expert Comment

by:stevbe
ID: 12301898
I bet I know where MS got the base of the code from ... Litwin use to (and I think he still does) work for MS :-)
0
 
LVL 5

Author Comment

by:Tom Knowlton
ID: 12301929
:)   convenient.  
0
 
LVL 5

Author Comment

by:Tom Knowlton
ID: 12302643
These code snippets were just what I needed!

Thank you both!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question