can you tell me where in my DB I need to place that code?







On Tue, 4 May 2010 21:40:48 -0400, "Bob Barrows"
wrote:

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