PC Review


Reply
Thread Tools Rate Thread

Automation Error - Access 2000 to Outlook 2000

 
 
Peter Caine
Guest
Posts: n/a
 
      2nd Sep 2003
When executing the following VBA code, the program aborts
on an internal error with an automation error code
-2113732605(82030003).

' Problem line
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)

The program works fine on a workstation running NT
workstation and fails on a workstation running Windows
2000.


 
Reply With Quote
 
 
 
 
Tony Toews
Guest
Posts: n/a
 
      9th Sep 2003
"Peter Caine" <(E-Mail Removed)> wrote:

>When executing the following VBA code, the program aborts
>on an internal error with an automation error code
> -2113732605(82030003).
>
>' Problem line
>Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
>
>The program works fine on a workstation running NT
>workstation and fails on a workstation running Windows
>2000.


Do they have different versions of Outlook installed? And you have a
reference that's missing on the system which fails?

If so once the code is debugged used Late Binding. 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 stuff. Then once
its 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 my Tips page on this topic.

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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2000 view Outlook 2000 Inbox error bobdydd Microsoft Access 3 1st Nov 2005 10:08 AM
Microsoft Access 2000/XP / Outlook Automation Problem Kevin Pitkin Microsoft Access 0 18th Feb 2005 12:50 PM
Re: Automation from Access 2000 to 2002 Douglas J. Steele Microsoft Access VBA Modules 0 23rd Jun 2004 10:57 PM
microsoft access automation to outlook version 2003 compared with 2000 Philip Leduc Microsoft Outlook 1 16th Feb 2004 01:41 PM
Access 2000 - Automation example please Matt. Microsoft Excel Programming 1 9th Oct 2003 09:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 PM.