Shortcut Key not working in one database

[JHarvey]

but will work in new databases.

insert date - ctrl-;

When used in one database, the response from access is
"The expression you entered has a function name that Microsoft Access can't
find"

If you start a new database though, the shortcut key works fine.

Is there a way to fix this in the database?

 

[Armen Stein]

but will work in new databases.

insert date - ctrl-;

When used in one database, the response from access is
"The expression you entered has a function name that Microsoft Access can't
find"

If you start a new database though, the shortcut key works fine.

Is there a way to fix this in the database?

Weird. There are a few things you can try.

Check your references (Tools | References from the VBA code window).
Make sure none are marked as missing. This can cause a function call
to fail.

Compact & Repair your database (make a backup first).

Copy all the objects into a new empty database.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[JHarvey]

Weird. There are a few things you can try.

Check your references (Tools | References from the VBA code window).
Make sure none are marked as missing. This can cause a function call
to fail.

Compact & Repair your database (make a backup first).

Copy all the objects into a new empty database.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

That didn't solve the problem, but it did help me find out the issue. I'm
opening an access 2000 database with 2002 that's been converted from an
access 97 database and the new systems with just 2002 (not upgraded from
previous versions) do not have the DAO 2.5/3.5 compatibility libraries. I
installed access 97 and then upgraded that to 2002 and that solved the issue.
Installing 2000 and then upgrading to 2002 would probably work as well since
2000 has the compatibility libraries too.