Names wich contain apostrophe !

[elkhazak]

Hello everyone !
I'll try to explain my english enough !
So i have this table who contains those fields : Name | Code | Number
i created a button "import" to import Excel files to the table and all is good !
The problem is i have some queries or functions i use in vba to manipulate Names and those names sometimes contain apostrphe ! so in vba it will be a comment ! How to keep the apostrophes !!

 

[Grumm]

strName = "jack O'lanterns"

This code will perfectly work. In most cases that apostrophe will not break vba code.

 

[elkhazak]

strName = "jack O'lanterns"

This code will perfectly work. In most cases that apostrophe will not break vba code.

DoCmd.OpenReport "RapportAenvoyer", acViewReport, , "[Nom du Technicien]='" & TechSélectionné & "'" !! It will work here ?

 

[CJ_London]

you need to replace the singe quote with two single quotes try

strName = replace("jack O'lanterns","'","'')

 

[elkhazak]

you need to replace the singe quote with two single quotes try

strName = replace("jack O'lanterns","'","'')

I didnt understand u ! can u rewrite my code please ?

 

[CJ_London]

DoCmd.OpenReport "RapportAenvoyer", acViewReport, , "[Nom du Technicien]='" & replace(TechSélectionné,"'","'') & "'" !! It will work here ?

 

[Grumm]

I didn't know you would use it in a query