reference library missing Microsoft Outlook 10.0 Object Library

[rockio]

I have two computers with MS Access 2000 installed. However one
computer has Microsoft Outlook 2002 installed while the other does not.
The computer without Microsoft Outlook 2002 does not seem to recognize
the Date() Function and Left Function and possibly other functions that
I haven't used. The only difference between the reference Libraries is
that the computer that cannot read these functions has Microsoft
Outlook 10.0 Object Library (Missing). Could these be the problem. If
so how do I go about it without having to install Microsoft Outlook
2002 on the computer that is reading the errors. Thanks in advance to
anyone that might have insight on this subject.

[Rick Brandt]

rockio wrote:

I have two computers with MS Access 2000 installed. However one
computer has Microsoft Outlook 2002 installed while the other does
not. The computer without Microsoft Outlook 2002 does not seem to
recognize the Date() Function and Left Function and possibly other
functions that I haven't used. The only difference between the
reference Libraries is that the computer that cannot read these
functions has Microsoft Outlook 10.0 Object Library (Missing). Could
these be the problem. If so how do I go about it without having to
install Microsoft Outlook 2002 on the computer that is reading the
errors. Thanks in advance to anyone that might have insight on this
subject.

Eliminate the reference. If you are *using* the reference eliminate it and
switch to late binding which allows you to call stuff from outside libraries
without having a reference. Additional references should only be added to
your Access app when you are positive that every PC that will be using the
app is configured identically.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[rockio]

Thanks Rick for your prompt response. In regards to your comment about
eliminating the reference I hope I understood you correctly. I removed
wherever I used the date() function and the left function which took
care of the problem. Now I must read up some more on late binding
since I hear allows you to write code that works in all MS Access
Platforms. Let me know if this is what you meant by eliminating the
reference.

[Rick Brandt]

rockio wrote:

Thanks Rick for your prompt response. In regards to your comment about
eliminating the reference I hope I understood you correctly. I
removed wherever I used the date() function and the left function
which took care of the problem. Now I must read up some more on late
binding since I hear allows you to write code that works in all MS
Access Platforms. Let me know if this is what you meant by
eliminating the reference.

No. I meant you go to Tools - References and where you see the Checked
reference to the Outlook library you uncheck it.

Many built in functions break when you have a bad reference. It doesn't
matter what the reference is. It will still mess with Date(), Format(),
Left(), and several others. The "fix" is to remove the reference or install
the appropriate software on every PC so that the reference is no longer
broken.

My previous post was saying that there is no real need to have any
references in your app besides the 3 or 4 default ones because you can use
late binding if you want to autmoate Outlook (for example).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[rockio]

I went to the computer that had Microsoft Outlook Object Librabry 10.0
(Missing) and unchecked the box and what do you know it worked! Thanks
Rick for all your help.