Access error upon using Ctrl+; for current date

R

robertlake

Greetings.

I upgraded one of my users with a new PC (XP/Office 2003) from what I
thought was Win2000/Office2003. The old PC is not available any longer.
Now, in one of her DBs she can no longer use the Ctrl+; hotkey sequence for
inserting the current date. Gets the error: "Expression entered has a
function name that Microsoft Office Access can't find." The hotkey sequence
works in other DBs and in Excel. The hotkeys don't work in the same DB from
either of two other workstations (XP/Office2002; XP/Office2003..nothing older
than Office 2002 available to test around this office). Being that the
problem seemed to be isolated to the DB, tried converting the DB to Access
2002/2003 format...doesn't resolve the issue either.

Any suggestions?
 
B

Beth Melton

It could be that the database has an invalid or missing reference.
Press Ctrl + G to open an Immediate window, then go to
Tools/References, uncheck any that
say, "MISSING", and try refreshing any other bad references.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"[email protected]"
 
R

robertlake

That (unchecking a reference to the Microsoft ActiveX plugin) did it
(hopefully without any unwanted impact). Thanks!
 
Top