References to Outlook 2000 and 2003

G

goshute

We have a database that manages some email messages with VBA and there
are PC's with Office 2000 and 2003 that use this database.

The problem is with the reference to Outlook. When the development is
done it is done with Access 2003 and the references are set to Outlook
2003 (11.0). When the PC's with Access 2000 try to run the procedure
that manages the email messages they receive an error about the Trim
Function not being valid.

To correct this issue, I go to their PC and remove the "Missing"
reference to Outlook 2003 and check the reference to Outlook 2000.

Is their any other way to handle this?
 
T

Tony Toews

goshute said:
The problem is with the reference to Outlook. When the development is
done it is done with Access 2003 and the references are set to Outlook
2003 (11.0). When the PC's with Access 2000 try to run the procedure
that manages the email messages they receive an error about the Trim
Function not being valid.

To correct this issue, I go to their PC and remove the "Missing"
reference to Outlook 2003 and check the reference to Outlook 2000.

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.

You'll want to install the reference if you are programming or
debugging and want to use the object intellisense while in the VBA
editor. Then,. once your app is running smoothly, remove the
reference and setup the late binding statements.

Sample code:
' Declare an object variable to hold the object
' reference. Dim as Object causes late binding.
Dim objWordDoc As Object
Set objWordDoc = CreateObject(" Word.Document")

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top