DLookUp with '

[scottian]

Im using a function to autoatically import a bunch of files from a folder. Im trying to use DLookUp to ascertain whether the file has already been imported, but some of the filenames contain ', for example
ACM008_to_8month's .xls. The simplest solution would be to remove the offending character, however once the database has been completed i will handing it over to a seperate team which is why im trying to automate as much as possible.

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[scottian]

Compile didnt work, compact and repair worked, I then imported all the objects into a blank database, but still get the same error

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[Remou]

I asked 'does replace work in a new database', that is, one without all the objects and code associated with this database, where it does not work.

Where is the compile failing? Can you fix it?