Open Folder on Network via Command Button

[Guest]

I have a form which displays a single record with a single field [SKU] at a
time. On this form, I have a command button, which on a click, I would like
for it to open a folder on our company's network. For example, if [SKU] =
C100 on the current record, I would like to build some code so that if a
person pushes the command button, windows will automatically open the folder
Z:\XXXX\XXX\XXX\C100 and display its contents. Please help!

 

[Tim Ferguson]

For example, if [SKU] =
C100 on the current record, I would like to build some code so that if
a person pushes the command button, windows will automatically open
the folder Z:\XXXX\XXX\XXX\C100 and display its contents. Please
help!

' get the full path, remember the \ at the end
' if you need to make this OS independent, use the
' Application.PathSeparator inbuilt
'
strPath = "z:\XXX\XXX\XXX\" & me!SKU & "\"

' now call the Windows Explorer; don't forget the space in the
' middle!
Shell "explorer.exe " & strPath

Hope that helps


Tim F

 

[Guest]

Thanks, Tim. It worked beautifully!

For example, if [SKU] =
C100 on the current record, I would like to build some code so that if
a person pushes the command button, windows will automatically open
the folder Z:\XXXX\XXX\XXX\C100 and display its contents. Please
help!

' get the full path, remember the \ at the end
' if you need to make this OS independent, use the
' Application.PathSeparator inbuilt
'
strPath = "z:\XXX\XXX\XXX\" & me!SKU & "\"

' now call the Windows Explorer; don't forget the space in the
' middle!
Shell "explorer.exe " & strPath

Hope that helps


Tim F