function not available

[vivian]

function not available in expressions in query expression
'left([part#],3'

this function has been working fine, and works great on my computer, but all of a sudden this error pops up on our purchaser's computer when he wants to print a report. i checked and it still works great on my computer and the others.

i've reinstalled access but this has not helped.

any ideas as to what can fix this?


thanks for the advice

 

[Mile-O]

First, make sure there's a bracket on the end of that Left() function

Secondly, open up a module, go to Tools -> References and look for the MISSING reference. Select it to reinstall it.

 

[vivian]

thanks

i actually had the bracket there, just a slipped typo


Will try the other thing tho



Thanks

 

[vivian]

just thinking, why would i need to reinstall the reference if it works on all the others?

 

[Pat Hartman]

Access shares libraries with other applications. If the user installed VB, that would have replaced some shared libraries and the references will need to be reset in some of the Access db's. Operating systems also cause reference problems. A db that works fine under Win2K may fail when moved to a WinXP machine for the same reason. This is not critical, just annoying. If you don't see anything marked missing, just check some random library and then uncheck it. This may be enough to get Access to refresh its references collection.

 

[The_Doc_Man]

Pat is right but didn't tell you the one thing you would need to know to fully understand the problem.

All references are stored in the Windows registry for all flavors of Windows since Win95. CERTAINLY for XP.

A registry is unique to each individual machine. Its contents depend on the exact way something was installed. (I.e. which options were selected.)

If the database uses an uncommon registry entry, other machines will need to update their registries to match the uncommon entry on the master machine that built the DB. Which is where the Tools>>References suggestion (from Mile-O-Phile) comes into play.