473,396 Members | 1,767 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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

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
1 963
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

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

Similar topics

4
by: rdemyan | last post by:
I'm using code from the following web page to open the API Browse Folder dialog http://www.mvps.org/access/api/api0002.htm It all works fine. But if the dialog box is open and the user closes...
1
by: Music Man | last post by:
Greetings All: I built a database in Microsoft SQL Server 2000 and used Microsoft Access 2010 as the front end. The database is used to keep track of "issues" that rise out of my employment. ...
6
by: Clive Oachman | last post by:
Access 2010 - when I move a linked back-end (BE) (and re-link) the FE wont open? (unless the old BE remains in original location).
4
by: jbrumbau | last post by:
Hello, In Access 2010/2007, how do you prevent users from flipping into design view from the ribbon? I do not want to hide the entire ribbon (DoCmd.ShowToolbar "Ribbon", acToolbarNo) or even the...
4
beacon
by: beacon | last post by:
Hi everybody, My title may not exactly describe my issue, so please forgive my lack of creativity today. I've got a database that was created in Access 2003 that I've opened in Access 2010. I...
0
by: ammounn | last post by:
i'm publishing my vb 2008 application using an access database but the problem is after publishing it wont run and it display an error message that the database was not found although i added it in...
5
by: Katie Howard | last post by:
I have an Access 2010 database and am using the feature of collecting data by email. I’m using the InfoPath form as the means of collecting the data. In general, it works well – but I’ve run into 2...
6
by: mlgmlg | last post by:
Hello, I desperately need help to modify a where condition that was created when I added a button to open a form and find specific data by to display. The form currently opens and displays a...
3
by: amwkl4 | last post by:
I am using Microsoft Access 2010 for a database and I have a list of approximately 700 keywords that I want to add into the dropdown list of a combo box. I have copied and pasted all the words into...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.