Open Folder in Access form button with VBA

Posted on 2013-01-16
Last Modified: 2013-01-16
I am trying to open a folder on a drive by assigning vba code to a button on my Access form.

If I hard code this path works fine.  When I try to assign a variable I get and error path doesnot exist.  Any ideas on what I am doing wrong??

Works fine......
Shell "explorer /e, C:\SystemProjectFiles\Ashland", vbNormalFocus

Not working.....
Shell "explorer /e, " & FolderPath & """, vbNormalFocus"

Question by:RobertStamm
  • 4
  • 3
LVL 119

Expert Comment

by:Rey Obrero
ID: 38783924

followhyperlink "C:\SystemProjectFiles\Ashland"

Author Comment

ID: 38783951
That works but I need to turnoff the hyperlink warning message.  Any ideas on how to do that?
LVL 119

Expert Comment

by:Rey Obrero
ID: 38783955
ok try

Shell("explorer.exe C:\SystemProjectFiles\Ashland",4)


Shell("explorer.exe C:\SystemProjectFiles\Ashland",vbnormalfocus)
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.


Author Comment

ID: 38783979
This gets me back to my orginal question....who do I write the statement to replace C:\SystemProjectFiles\Ashland with a variable called FolderPath?
LVL 119

Accepted Solution

Rey Obrero earned 500 total points
ID: 38784032
Dim FolderPath As String
FolderPath = "C:\SystemProjectFiles\Ashland"

Call Shell("explorer.exe " & FolderPath, 4)


Shell "explorer.exe " & FolderPath, 4

Author Comment

ID: 38784442
Perfect....Thanks for your help.

Author Closing Comment

ID: 38784448
Thanks again!

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Access to SQL Conversion - Bit and Yes/No Datatypes 12 46
subtract 1 in Access 2003 query 7 39
ms access 2013, running .mdb 2 31
MS Access Tables Linking 6 42
MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now