Solved

Find File    Find   Folder    dialogs?

Posted on 2004-10-13
6
204 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: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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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:knowlton
ID: 12301929
:)   convenient.  
0
 
LVL 5

Author Comment

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

Thank you both!
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

777 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