By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,460 Members | 2,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,460 IT Pros & Developers. It's quick & easy.

Folder with comma and space won't open using chr(34) Access 2010

P: 2
Private Sub Command41_Click()
On Error GoTo Err_Command41_Click

Dim stAppName As String

stAppName = Chr(34) & "C:\Windows\explorer.exe O:\Clients\" & txtClientsNumber & """ """ & txtClientsName & Chr(34)
Call Shell(stAppName, 1)

Exit_Command41_Click:
Exit Sub

Err_Command41_Click:
MsgBox Err.Description
Resume Exit_Command41_Click
End Sub

I am trying to open a file folder
Example folder name: 000-1 LName, FName
Jul 22 '17 #1
Share this Question
Share on Google+
1 Reply


P: 2
Please can someone help me. I know there is something wrong with my code but I have searched everywhere and can't get it to work. It opens My Documents.
Jul 22 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.