HelsByTheDock
Programmer
Hi all,
This is my first visit, and I have to say I'm impressed by the content here - nice to find a forum that gets to the point, and so shall I...
I have an MS Access db (2000 format, but built in v2003). After making a number of unrelated form changes 1 of my queries now fails with the following error:
"Compile error. in query expression '(((Date()) BETWEEN [Valid_From] AND [Valid_To]))'"
The query is actually correct, but Access no longer recognizes the Date() function.
I've tested this by creating a new query in the database, here's the SQL:
This query comes up with a similar error:
"Compile error. in query expression 'Date()"
If I create a new database and import the table, the query will run perfectly as expected, however the same problem soon reappears.
I have also repaired and compacted successfully - but no difference. Also tried on a different PC - same errors.
I've trawled the internet for weeks with no luck, any ideas will be greatly appreciated.
Thanks,
Hels
This is my first visit, and I have to say I'm impressed by the content here - nice to find a forum that gets to the point, and so shall I...
I have an MS Access db (2000 format, but built in v2003). After making a number of unrelated form changes 1 of my queries now fails with the following error:
"Compile error. in query expression '(((Date()) BETWEEN [Valid_From] AND [Valid_To]))'"
The query is actually correct, but Access no longer recognizes the Date() function.
I've tested this by creating a new query in the database, here's the SQL:
Code:
SELECT tblLookupParent.Parent_Code, Date() AS Expr1
FROM tblLookupParent;
This query comes up with a similar error:
"Compile error. in query expression 'Date()"
If I create a new database and import the table, the query will run perfectly as expected, however the same problem soon reappears.
I have also repaired and compacted successfully - but no difference. Also tried on a different PC - same errors.
I've trawled the internet for weeks with no luck, any ideas will be greatly appreciated.
Thanks,
Hels