View Single Post
  #2  
Old May 4th, 2010, 12:36 AM posted to microsoft.public.access.queries
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Function is not availalbe in expressions in query expression error message (0/1)

Check the References on your Client's machine. Sounds like ther might be
one missing.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

wrote in message
...
I recently received this error message when opening the source DB in
Access 2007.

I have attached two jpg pics.

Does this error message give enough details for someone to point me in
the right direction for a fix?

The last time I developed and worked in this DB everything worked
fine.

I get this error when clicking on a control that runs a query macro
against a backend DB consisting of about 15 tables.

I should mention the error comes into play when trying to run the
frontend on a client W/S. I don't see the error while on my W/S which
is my developer W/S and has Access 2007. The clients running the
front end have the MS Access Runtime installed.

thanks for any and all help