David92595
Registered User.
- Local time
- Yesterday, 22:27
- Joined
- Jun 28, 2011
- Messages
- 44
Basics: I'm running Access 2007 on Windows 7
I need to find a way to place a wild card infront of a string.
ex:
Private Sub Command144_Click()
Dim anPath As String 'folder name
Dim aPath As String 'LN Number
aPath = [LN]
If Client_Name Like "Andrew gordan" Then
anPath = "\\MAXSERVER\Max\Andrew gordan\"
retVal = Shell("explorer.exe " & anPath & aPath, vbNormalFocus)
...end if
The folder that aPath is searching for has a 0 infront of it and I don't know how to get a wildcard to accept the 0. This only happends in some instances, most of our "LN" numbers do not have 0 in front of them.
Just so it's said, I can not go back through the files and delete the zero's from the folder name.
Thank you in advance!
David92595
I need to find a way to place a wild card infront of a string.
ex:
Private Sub Command144_Click()
Dim anPath As String 'folder name
Dim aPath As String 'LN Number
aPath = [LN]
If Client_Name Like "Andrew gordan" Then
anPath = "\\MAXSERVER\Max\Andrew gordan\"
retVal = Shell("explorer.exe " & anPath & aPath, vbNormalFocus)
...end if
The folder that aPath is searching for has a 0 infront of it and I don't know how to get a wildcard to accept the 0. This only happends in some instances, most of our "LN" numbers do not have 0 in front of them.
Just so it's said, I can not go back through the files and delete the zero's from the folder name.
Thank you in advance!
David92595
