Opening windows explorer with a macro

[trackmedic]

Hi,

How can I use a button on a form to open up a directory in Windows? What I want to do is open up this directory c:\inform\msds this will allow me to choose MSDS files that are in this directory. Basically what I would like to do is open a directory with windows explorer through my access database. the msds foles are .pdf files. All i would need to do is look up the file and print it then return to my database.


Any help would be appreciated

Thanks
Trackmedic

 

[trickg]

You are probably going to have to use the windows common dialog control to do this in which case you are going to have to do some VBA coding. I'm currently using it in an application that allows users to find and add image files that are displayed in the application.

Check the MSDN website for how to code the common dialog control. There are enough code examples there that you should be able to copy, paste and then customize the code to suit your needs.