Prev: Anyone who can help my fried mind with this solution?
Next: 2 independent criteria
From: repent34 on 3 May 2010 19:10
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
From: Gina Whipp on 3 May 2010 19:36
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

<repent34(a)hotmail.com> wrote in message
news:a4lut51ev3vhit3kd176i5d6v86i3dojj8(a)4ax.com...
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

From: repent34 on 4 May 2010 10:33
Can I do that if they only have the Access Runtime installed? I didn't
have to check anyrthing when I set them up, I only installed the
Runtime and supplied them with the Access front end on their desktop
and it all ran fine. Not sure where or why it broke. Can you advise
me fiurther please?

chris


On Mon, 3 May 2010 19:36:10 -0400, "Gina Whipp"
<NotInterested(a)InViruses.com> wrote:

>Check the References on your Client's machine. Sounds like ther might be
>one missing.
From: Bob Barrows on 4 May 2010 21:40
repent34(a)hotmail.com 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/forums/showthread.php?t=92526

There are more to be found via this google search:
http://www.google.com/search?rlz=1C1CHMG_en-USUS291US303&aq=2&oq=missing+references&sourceid=chrome&ie=UTF-8&q=access+vba+missing+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"


From: Repent34 on 5 May 2010 14:42
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"
<reb01501(a)NOyahoo.SPAMcom> wrote:

>repent34(a)hotmail.com 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/forums/showthread.php?t=92526
>
>There are more to be found via this google search:
>http://www.google.com/search?rlz=1C1CHMG_en-USUS291US303&aq=2&oq=missing+references&sourceid=chrome&ie=UTF-8&q=access+vba+missing+references
 |  Next  |  Last
Pages: 1 2
Prev: Anyone who can help my fried mind with this solution?
Next: 2 independent criteria