If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter Question
I have a combo box with all the employee names. A name is selected
and a filter is applied to the form as follows: DoCmd.ApplyFilter , "[employeename]='" & Me.Employee & "'" The problem I am having are that 2 of the employees have a ' in their name, like O'Conner. This causes an error. Is there any way I can handle this? |
#2
|
|||
|
|||
Filter Question
"hotplate" wrote in message
... I have a combo box with all the employee names. A name is selected and a filter is applied to the form as follows: DoCmd.ApplyFilter , "[employeename]='" & Me.Employee & "'" The problem I am having are that 2 of the employees have a ' in their name, like O'Conner. This causes an error. Is there any way I can handle this? Assuming no employee will have a double-quote (") in his name, you can write it like this: DoCmd.ApplyFilter , "[employeename]=""" & Me.Employee & """" Note: before the ampersand on the left of Me.Employee, you have three " characters in a row, and after the ampersand on the right, you have four " characters in a row. That could also be written, somewhat easier to read, using the Chr() function to get the double-quote character into the string: DoCmd.ApplyFilter , _ "[employeename]=" & Chr(34) & Me.Employee & Chr(34) Take your pick. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#3
|
|||
|
|||
Filter Question
That worked! Thanks
On Apr 20, 11:09*am, "Dirk Goldgar" wrote: "hotplate" wrote in message ... I have a combo box with all the employee names. *A name is selected and a filter is applied to the form as follows: DoCmd.ApplyFilter , "[employeename]='" & Me.Employee & "'" The problem I am having are that 2 of the employees have a ' in their name, like O'Conner. This causes an error. *Is there any way I can handle this? Assuming no employee will have a double-quote (") in his name, you can write it like this: * * DoCmd.ApplyFilter , "[employeename]=""" & Me.Employee & """" Note: *before the ampersand on the left of Me.Employee, you have three " characters in a row, and after the ampersand on the right, you have four " characters in a row. *That could also be written, somewhat easier to read, using the Chr() function to get the double-quote character into the string: * * DoCmd.ApplyFilter , _ * * * * "[employeename]=" & Chr(34) & Me.Employee & Chr(34) Take your pick. -- Dirk Goldgar, MS Access MVP Access tips:www.datagnostics.com/tips.html (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|