Hi I need help with creating a command to open a folder based on a file path.
I have a table with a calculated field which gives me the file path where I can find an employees training certs.
Example:
"C:\Field service\Training\Certificates\" & [Last Name] & " " & [First Name]
Separate to this I have a form which displays the file path (corresponding to the employee selected) in a text box.
Example:
C:\Field service\Training\Certificates\Smith John
[when John Smith's record is open]
I'm looking for a way to set up a command button which will open the folder (using the text box info) in a separate folder browser window.
If it is also possible to incorporate an error message if no file exists for a pathway that would be very helpful.
I have tried several different methods of getting this to work but with no luck yet. Any help would be greatly appreciated!
Thanks in advance!
cmcd
I have a table with a calculated field which gives me the file path where I can find an employees training certs.
Example:
"C:\Field service\Training\Certificates\" & [Last Name] & " " & [First Name]
Separate to this I have a form which displays the file path (corresponding to the employee selected) in a text box.
Example:
C:\Field service\Training\Certificates\Smith John
[when John Smith's record is open]
I'm looking for a way to set up a command button which will open the folder (using the text box info) in a separate folder browser window.
If it is also possible to incorporate an error message if no file exists for a pathway that would be very helpful.
I have tried several different methods of getting this to work but with no luck yet. Any help would be greatly appreciated!
Thanks in advance!
cmcd