Something wrong with my build of Access 2007

[sportsguy]

When i move my databases from my work laptop to my home tower, some weird things happen.

This expression in a query does not work on the home tower:

Left([Labor category],3)

Error message is function is not available

anyone know where to activate built in formulas?

sportsguy

 

[pbaldy]

The usual culprit would be a reference problem:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[sportsguy]

OK, interesting, there are completely new references for X64 that are not available for x86. and when i went back to open the database on XP, there were missing references. . . .

Vista x64 did not have missing references, just unchecked references. . .

situations which make you go hmmmm!

sportsguy