Open Folder on Network via Command Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
Click to expand...

' 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
 
Thanks, Tim. It worked beautifully!

Tim Ferguson said:
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!
Click to expand...

' 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
Click to expand...
 
Back
Top