Date data entry

[Guest]

Migrating from Access 2000 to 2003. When opening the 2000 files in 2003
version I get the following error when trying to enter data information using
the keyboard short cut CTRL+Semicolon: The expression you entered has a
function name that Microsoft Office Access can't find.

I have tried to convert the 2000 files to 2003 and still get same errors.

 

[John Vinson]

Migrating from Access 2000 to 2003. When opening the 2000 files in 2003
version I get the following error when trying to enter data information using
the keyboard short cut CTRL+Semicolon: The expression you entered has a
function name that Microsoft Office Access can't find.

I have tried to convert the 2000 files to 2003 and still get same errors.

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

Thanks John -
I seem to remember doing something like this when we migrated from Access 97
to 2000 but just could not remember the specifics....