Date problem with Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I recently went from win98 & Office 97 to Win XP with Office 2003.

All works well apart from Access querries with a date field wont run and give "undefined function "date" in expression".

All worked well before changing computers and software.

I have tryed writing a new query but it wont run either, even copy and pasting the >date()-30 line direct from access help wont run in a query.

Any help appreciated!
 
Sounds like a MISSING reference -- Access can, in moves/conversion, lose
track of where some of it's code libraries live.

Open a code module, click Tools|References and look for any checked
Reference with MISSING in front of it. Note it and uncheck it. Save/close,
then reopen the References and re-check it. Save/close. Recompile your
database (Debug|Compile).
 
References problem.

See:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

rl said:
I recently went from win98 & Office 97 to Win XP with Office 2003.

All works well apart from Access querries with a date field wont run and
Click to expand...
give "undefined function "date" in expression".
All worked well before changing computers and software.

I have tryed writing a new query but it wont run either, even copy and
Click to expand...
pasting the >date()-30 line direct from access help wont run in a query.
 
Not sure if this will help or not, but when we upgraded
here, there were some date issues. It was a matter of
going into control panel, regional and language options,
and changing default date format.
-----Original Message-----
I recently went from win98 & Office 97 to Win XP with Office 2003.

All works well apart from Access querries with a date
Click to expand...
field wont run and give "undefined function "date" in
expression".
All worked well before changing computers and software.

I have tryed writing a new query but it wont run either,
Click to expand...
even copy and pasting the >date()-30 line direct from
access help wont run in a query.
 
Thanks about the regional settings tip, that has solved another problem!

I am still struggling with Access tho.

Dates in queries and reports don’t work at all. E.g. I just tried to run a report with today’s date at the top (letter style) and it asks “formatâ€, but delete any mention of date from the report and it works fine.

How do I open a code module? And is that something a novice like me can/should do?

Would a new table “conversion errors†have anything to do with this?

Appreciate any help.
 
Back
Top