Solved

Find File    Find   Folder    dialogs?

Posted on 2004-10-13
6
209 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
  • 2
  • 2
  • 2
6 Comments
 
LVL 39

Accepted Solution

by:
stevbe earned 250 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 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 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 84
ID: 12301812
Here's the Browse For Folder dialog:

http://www.mvps.org/access/api/api0002.htm
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

761 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