Open Folder on Network via Command Button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert - 18 Feb 2005 16:59 GMT

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!

Reply to this Message

Tim Ferguson - 18 Feb 2005 18:11 GMT

> 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

Reply to this Message

Robert - 18 Feb 2005 19:13 GMT

Thanks, Tim. It worked beautifully!

> > For example, if [SKU] =
> > C100 on the current record, I would like to build some code so that if
[quoted text clipped - 15 lines]
>
> Tim F

Reply to this Message