Syntax Error (Missing Operator) ...Aaaargh!!!!

[DeutchBose]

I'm using a DLookup Function as follows:

Dim ATime As String
Dim APath As String

ATime = Me.lbl1Recent.Caption

APath = DLookup("Path", "QryDateOrder1", "[TimeStamp] = " & ATime)

I get the following error:

Run-time error '3075'

Syntax error (missing operator) in query expression '[TimeStamp] = 1/28/2005 10:08:00 AM'


----
I've tried definining ATime as a Date instead of a String, but that doesn't seem to make a difference...what am I doing wrong?

 

[tails]

I had this problem while i was in school, but that was to do with access error and it couldn't access the database to grab the files and put them into a program.
Have you checked all the access codes eg write modift and create... etc. to make sure you have complete access to it.
another thing it could be to do with the SQL that its using,
just a thought, might not be right but its worth a try...