View Single Post
  #5  
Old May 5th, 2010, 02:40 AM posted to microsoft.public.access.queries
Bob Barrows
external usenet poster
 
Posts: 475
Default Function is not availalbe in expressions in query expression error message (0/1)

wrote:
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


You will need to use one of the subroutines available on the web to identify
and perhaps fix the missing References on that machine. I know a couple of
MVPs have versions of that sub on their websites. Here's one:
http://www.access-programmers.co.uk/...ad.php?t=92526

There are more to be found via this google search:
http://www.google.com/search?rlz=1C1...ing+references

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"