Compile errors on common functions (Month, DLookUp, etc) 1

[BoxHead]

I have a database in which I am trying to run some basic queries including Access built-in functions like Month, DLookUp and Now.

I keep getting an error:

Compile error. in query expression 'Now()'

When I type the expression into the query builder, it is automatically capitalized so it seems that Access is recognizing the function at that point.

I've checked and rechecked my references against other machines running the same db without issues and everything matches.

Any ideas?

Thanks,

John

Use what you have,
Learn what you can,
Create what you need.

 

[PHV]

Does the database compiles properly ?
while in VBE menu Debug -> Compile ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BoxHead]

Doh!

Thanks, PH!



John

Use what you have,
Learn what you can,
Create what you need.

 

[TomPose]

I have the same problem as stated above, however, I don't know what to do with the Debug>Compile solution presented above.

Help please