Open a Windows folder from Access 2000 VBA

[BakerUSMC]

Hello to all,

I'd like to thank all of you that help us out when we are in need. We really appreciate it!!

I have a (hopefully) simple question: I want a user to click a button that will open a windows folder to a specific directory...

Example:
1. Click button
2. Window opens to folder "z:\Receipts"

I want to create this so that the user can easily check to see if certain receipts were already saved to the folder or not. If not, then they now know they need to.

Thanks in advance for your help!!

 

[Nassu]

Look

http://www.mvps.org/access/api/api0001.htm

oleg

 

[RickSpr]

It's quite simple to open an Explorer window to a given folder, e.g.
Call Shell("Explorer ""C:\My Documents""", vbNormalFocus)



Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[BakerUSMC]

RickSpr,

Thanks so much for your response. It worked like a charm. Although the link from Nassu was infomative, I just needed something quick and easy like your posting.

THanks again!!!!