Open a directory in Windows Explorer from MS Access

[OOzy]

Guys/Gals,

I have

A="C:\MyDIR\Shop\Car"

How can I open this directory from with Access Form when a button is pushed.

 

[Blorf]

The very easiest way is with

FollowHyperlink "C:\MyDIR\Shop\Car""

Or FolloywHyperLink A

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[AlanJordan]

Blorf - Very Cool.
I generalized it as follows

Sub OpenADirectory(strFullyQualifiedDirPath As String)
    FollowHyperlink strFullyQualifiedDirPath
End Sub

P.S. I got a good laugh out of your signature.

 

[Blorf]

Glad you liked it. I heard it in an old C class eons ago, then again recently on a TV show of some sort.

Makes me laugh everytime I see it.

You a C guy? If so, then you will also like

Two strings walk into a bar, first one says "Hey, barkeep, get me a beer Q@SDAalacoawe68 66asdlk564225 525"

Second string says, pardon my friend, he isn't null terminated.

Makes me laugh everytime I think about it.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[Blorf]

PS, if the string you pass is the full path of an app or file, the OS will open it with what ever the default app is for the file. Example, followhyperlink "C:\MyMp3.Mp3" will launch the mp3 with Winamp or WMP or what ever the default on the system is.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.