Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Setting a default for the FilePicker dialog box

Posted on 2004-12-01
Medium Priority
Last Modified: 2012-05-05
I've been using the newly-available FilePicker Dialog to allow a user to navigate to a file or folder on the file system.  It's a wonderful feature.

Does anyone know how i could use VB code to set a starting point for the dialog box?  The current default is at the lowest level of the user's file system.  I'd like to save them a few mouse clicks by getting them part way up the tree.

thanks in advance,

Question by:med39
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 500 total points
ID: 12720290

    With Application.FileDialog(msoFileDialogFilePicker)
        .InitialFileName = CurrentProject.path             'this will open the Directory where your db is

    End With

Author Comment

ID: 12720957

Thanks for the prompt reply!  I adapted your suggestion, and learned from it.


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

571 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