Function Not Available Error

  • Thread starter Thread starter blessing
  • Start date Start date
B

blessing

I have a database where I'm running a calculation on a
date and we have one machine where when we try to run the
query, we get an error message "Function Not Available".
Any ideas?
 
It sounds like the database makes a reference to a VBA library that isn't
installed on the problem machine. It can also happen if the project isn't
compiled and there's a compile bug somewhere in your code. When that
happens, all sorts of weird things occur.

Open any module in the Visual Basic Editor and choose References from the
Tools menu. For most applications, you really need only Access, VBA, and
either DAO or ADO. If you converted the application from a previous
release, you can sometimes end up with a bogus reference to Utility.mda.
Uncheck the references you don't need and compile the project.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Back
Top