Issue with Date Entry using ctrl:

[JimO]

I am unable to enter the current date using "ctrl:".



I get a message 'The expression you entered has a function name that Microsoft Access can't find'.

Also other functions such as formating a date do not work.

A List box just shows blank.

SELECT ItemID, EventDay, Format([EventDay],"h:nn a/p"), Display FROM CalendarQDisplay WHERE EventDay>=Date()+1 AND EventDay<=Date()+2;

This started after I had to reinstall Access following a computer issue, and it only affects 1 database on my computer. Other databases work fine.

Ahy thoughts?

Jim O

[isladogs]

First of all, I didn't know the Ctrl: shortcut for inputting the current date so thank you for that.

As the Date function is part of the default Visual Basic for Applications ref library which can't be deleted, this makes little sense.
Have you tried typing ?Date or ?Date() into the VBE Immediate window to check if that works?

Have you tried compiling your database?

Sounds to me like one of the following are true
a) You have defined Date as a variable somewhere in your database
Search for Dim Date As ... or Public Date As ... Or Global Date As ... and if any of these exist delete them
Then compile your database and check your code again

b) If that doesn't fix it, then you have corruption somewhere.
DECOMPILE your database, then RECOMPILE then COMPACT
For info on decompiling, see http://www.fmsinc.com/microsoftacces.../decompile.asp

Otherwise, I would say, reinstall Access ... but you say its only the one database with an issue

[moke123]

Shouldnt there be an "As" in there? Format([EventDay],"h:nn a\p") As Something

[Micron]

Umm, I think I'd turn on "break on all errors" and figure out which line of code raises the error unless you already know. I don't see how a shortcut for entering a value would raise such an error any more than typing it in or selecting from the built in calendar control. To me, there is not enough info, like whether or not there is any code behind the form control, or exactly when the error is raised (after it loses focus? Immediately upon Ctrl+: keypress?).

IIRC, this error can be raised when a field is mis-named (EvntDay instead of EventDay, for example). Access can/will assume it's a function call; probably because it's not part of a table.field syntax ( tblMyTable.EventDay or even just because there's no brackets to flag it as a field or domain name [EventDay]).

[isladogs]

Oops.
I misread the thread as the problem is with Format(Date...) rather than Date().
Much of my post still applies however.

[JimO]

My skills are lacking to try some of what has been suggested, but I thank everyone for the input.

I have resorted to exporting the offending data to a new database (on the same computer) and the files all seem to function as required. I have no idea what has caused this one database to act up. I even tried to open a new test table, but the date entry still will not work (ctrl. This is a database I use for personal use so time is on my side.

Again thanks to all for the input and if I run into any other issues will keep you posted.
Jim O