Open folder on PC from a button on an Access Form

[Henley12]

Is there a way to create a button on an Access form that will open a certain folder on a networked PC drive so the user may then open the contents of that folder? Within this folder are many excel spreadsheets, and more folders that contain additional spreadsheets.

 

[qdogfball]

I think that Call Shell is what you want

Dim stAppName As String

 stAppName = """C:\WINDOWS\explorer.exe"" /e, G:\location on network"

Call Shell(stAppName, 1)

 

[GaryPanic]

check out Ghudsons d/base on this -
its awesome various options on how to do this - but this one looks the business (I cannot wrap my head round it though - but is a project I need to do later on)

regards

 

[Henley12]

The Call shell opens up explorer to that location great. However, I need to be able to open something that will not let them navigate away from that folder. They do not need access to any folder above that one, only the ones inside.

As for the database to check out, can you give me a location?

 

[Henley12]

I am getting a runtime error when I try to open the folder with only the runtime version of access. Does anyone know of such an issue, and perhaps a way around it?