[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

MS Access - Path Picker

Posted on 2011-04-29
2
Medium Priority
?
296 Views
Last Modified: 2012-05-11
I am familiar withe the use of "File Picker" --- Application.FileDialog(msoFileDialogFilePicker) --- and would like to employ a similar technique to pick a path in  a dialog box similar to explorer

Anybody have a simple solution?
0
Comment
Question by:rogerdjr
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 1000 total points
ID: 35496772
0
 
LVL 46

Assisted Solution

by:aikimark
aikimark earned 1000 total points
ID: 35498935
You can use the same method, but tell it to select a folder.

http://support.microsoft.com/kb/288543

  Dim fd As FileDialog
  Set fd = Application.FileDialog(msoFileDialogFolderPicker)
  fd.Show
  Debug.Print fd.SelectedItems(1)

Open in new window

0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

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

This is an article on how to answer questions, earn points and become an expert.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

612 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