My Access 2000 application runs fine on my computer, but
the user gets error messages whenever certain functions
get executed such as 'Left' or 'Mid'...

How can I ensure that code running on my computer will
also run at the user on-site? And how with the specific
example with the 'Left' function?

Thanks

You're experiencing an Office bug, having to do with missing references.
Open any code module (or the debug window); choose Tools:References from
the menu and uncheck any marked as missing. Your code should compile all
right now.

(E-Mail Removed) wrote:

> My Access 2000 application runs fine on my computer, but
> the user gets error messages whenever certain functions
> get executed such as 'Left' or 'Mid'...
>
> How can I ensure that code running on my computer will
> also run at the user on-site? And how with the specific
> example with the 'Left' function?
>
> Thanks

--
Bas Cost Budde

Thanks,

However, what can I do if this happens at the user site
and I do not want to let the user start making changes in
the back?


>-----Original Message-----
>You're experiencing an Office bug, having to do with
missing references.
>Open any code module (or the debug window); choose
Tools:References from
>the menu and uncheck any marked as missing. Your code
should compile all
>right now.
>
>(E-Mail Removed) wrote:
>
>> My Access 2000 application runs fine on my computer,
but
>> the user gets error messages whenever certain functions
>> get executed such as 'Left' or 'Mid'...
>>
>> How can I ensure that code running on my computer will
>> also run at the user on-site? And how with the specific
>> example with the 'Left' function?
>>
>> Thanks
>
>--
>Bas Cost Budde
>
>.
>

Dunno. I saw this happening with one user, but always after an update by
me, never spontaneously. If that is any consolation...

Francois wrote:

> Thanks,
>
> However, what can I do if this happens at the user site
> and I do not want to let the user start making changes in
> the back?

No we don't want that.
--
Bas Cost Budde

With some confusing code, you can check the references
collection of the CurrentDB. Then, check to IsBroken
property. The problem is then what to do...

I've trudged through this problem before and have yet to
get an acceptable answer.


Chris



>-----Original Message-----
>Thanks,
>
>However, what can I do if this happens at the user site
>and I do not want to let the user start making changes in
>the back?
>
>
>>-----Original Message-----
>>You're experiencing an Office bug, having to do with
>missing references.
>>Open any code module (or the debug window); choose
>Tools:References from
>>the menu and uncheck any marked as missing. Your code
>should compile all
>>right now.
>>
>>(E-Mail Removed) wrote:
>>
>>> My Access 2000 application runs fine on my computer,
>but
>>> the user gets error messages whenever certain
functions
>>> get executed such as 'Left' or 'Mid'...
>>>
>>> How can I ensure that code running on my computer will
>>> also run at the user on-site? And how with the
specific
>>> example with the 'Left' function?
>>>
>>> Thanks
>>
>>--
>>Bas Cost Budde
>>
>>.
>>
>.
>

I have this problem also. Can we use any property or method to program
Access to use those missing library to make it consistency before
application run everytime ?

Albert

"Bas Cost Budde" <(E-Mail Removed)> wrote in message
news:bvbl60$kuj$(E-Mail Removed)...
> You're experiencing an Office bug, having to do with missing references.
> Open any code module (or the debug window); choose Tools:References from
> the menu and uncheck any marked as missing. Your code should compile all
> right now.
>
> (E-Mail Removed) wrote:
>
> > My Access 2000 application runs fine on my computer, but
> > the user gets error messages whenever certain functions
> > get executed such as 'Left' or 'Mid'...
> >
> > How can I ensure that code running on my computer will
> > also run at the user on-site? And how with the specific
> > example with the 'Left' function?
> >
> > Thanks
>
> --
> Bas Cost Budde
>

The only way to guarantee that it'll work on every workstation without
problems is to make sure that every workstation has exactly the same version
of each of the referenced files in exactly the same location.

To see what's really going on, read what Michka has at
http://www.trigeminal.com/usenet/usenet026.asp

Terry Kreft and Dev Ashish wrote a References Wizard that may help you.
Check http://www.mvps.org/access/modules/mdl0022.htm at "The Access Web".
This can be installed as an Access add-in, which you can then invoke through
the Tools | Add-Ins menu option, or you can call it from your program
(instructions are included in the download). While it doesn't store details
of what referenced files should be present, it attempts to correct broken
references by trying to reregister them using their GUIDs

Peter Walker has an interesting approach that you can download (for free)
from http://www.papwalker.com/dllhell/index.html. Peter not only stores the
details about each reference, he stores a binary copy of the file as well!
In this way, if a broken reference is found, the file is written to the same
folder as the application, and a reference set to it. Note that this does
have the potential of impacting other applications, since it can change what
version of the file is registered in the registry.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Albert" <(E-Mail Removed)> wrote in message
news:%23$(E-Mail Removed)...
> I have this problem also. Can we use any property or method to program
> Access to use those missing library to make it consistency before
> application run everytime ?
>
> Albert
>
> "Bas Cost Budde" <(E-Mail Removed)> wrote in message
> news:bvbl60$kuj$(E-Mail Removed)...
> > You're experiencing an Office bug, having to do with missing references.
> > Open any code module (or the debug window); choose Tools:References from
> > the menu and uncheck any marked as missing. Your code should compile all
> > right now.
> >
> > (E-Mail Removed) wrote:
> >
> > > My Access 2000 application runs fine on my computer, but
> > > the user gets error messages whenever certain functions
> > > get executed such as 'Left' or 'Mid'...
> > >
> > > How can I ensure that code running on my computer will
> > > also run at the user on-site? And how with the specific
> > > example with the 'Left' function?
> > >
> > > Thanks
> >
> > --
> > Bas Cost Budde
> >
>
>