I'm using Access 2002 to try to open Outlook 2002 (late binding) using:
Dim objOutlook As Object
Set objOutlook = CreateObject("Outlook.Application")
I get the above error if Outlook is closed when the routine runs.
If Outlook is open, it runs fine, but doesn't seem to open another copy of
Outlook (strange?)
It has been working OK previously, and the only change to my system (I can
think of) is the installation of Access 2003.
When I copy the program to another machine (with all the same apps
installed - ie A2002 and A2003 and OL2002) it works fine.
I've seen a couple of posts with similar problems, but can find no
solutions.
Any ideas appreciated.
--
Bob Darlington
Brisbane 7 14700
On Fri, 10 Sep 2004 19:46:13 +1000, "Bob Darlington"
<bo*@dpcmanAX.com.au> wrote:
Perhaps better to first call GetObject to see if an instance is
already running. Something like:
on error resume next
set o = GetObject(x)
if err.number<>0 then set o = CreateObject(x)
if err.number<>0 then Msgbox "Alarm - Outlook not installed?"
With late binding you may also be able to use IsObject to test if an
object was created.
-Tom. I'm using Access 2002 to try to open Outlook 2002 (late binding) using: Dim objOutlook As Object Set objOutlook = CreateObject("Outlook.Application")
I get the above error if Outlook is closed when the routine runs. If Outlook is open, it runs fine, but doesn't seem to open another copy of Outlook (strange?) It has been working OK previously, and the only change to my system (I can think of) is the installation of Access 2003. When I copy the program to another machine (with all the same apps installed - ie A2002 and A2003 and OL2002) it works fine.
I've seen a couple of posts with similar problems, but can find no solutions. Any ideas appreciated.
Thanks for the reply Tom.
I tried your suggestion, but get the same result - Err 429 if Outlook is not
open before I start.
If Outlook is open, and I use CreateObject, it works fine.
If Outlook is open and I use GetObject I get err -2147221020 and it fails
IsObject returns true after CreateObject or GetObject.
CreateObject doesn't seem to open additional copies of Outlook as I would
have expected.
And I can't see why GetOject shouldn't work if Outlook is open.
As I said in my initial post, it all works fine on my notebook which is
similarly configured with WinXP, OfficeXP Developer and Access 2003.
Unless anyone has a better suggestion, I'll try uninstalling Access 2003
then, if that doesn't work, reinstalling Office XP.
--
Bob Darlington
Brisbane
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:i8********************************@4ax.com... On Fri, 10 Sep 2004 19:46:13 +1000, "Bob Darlington" <bo*@dpcmanAX.com.au> wrote:
Perhaps better to first call GetObject to see if an instance is already running. Something like: on error resume next set o = GetObject(x) if err.number<>0 then set o = CreateObject(x) if err.number<>0 then Msgbox "Alarm - Outlook not installed?"
With late binding you may also be able to use IsObject to test if an object was created.
-Tom.
I'm using Access 2002 to try to open Outlook 2002 (late binding) using: Dim objOutlook As Object Set objOutlook = CreateObject("Outlook.Application")
I get the above error if Outlook is closed when the routine runs. If Outlook is open, it runs fine, but doesn't seem to open another copy
ofOutlook (strange?) It has been working OK previously, and the only change to my system (I
canthink of) is the installation of Access 2003. When I copy the program to another machine (with all the same apps installed - ie A2002 and A2003 and OL2002) it works fine.
I've seen a couple of posts with similar problems, but can find no solutions. Any ideas appreciated.
On Mon, 13 Sep 2004 09:59:22 +1000, "Bob Darlington"
<bo*@dpcmanAX.com.au> wrote:
I'm really surprised by this error -2147221020 = 800401e4 = Invalid
syntax.
Does this happen on other machines as well? A quick Google search
turned up mostly ADSI related issues - not much on Outlook. I think
your uninstall / reinstall is a good idea.
-Tom. Thanks for the reply Tom. I tried your suggestion, but get the same result - Err 429 if Outlook is not open before I start.
If Outlook is open, and I use CreateObject, it works fine. If Outlook is open and I use GetObject I get err -2147221020 and it fails IsObject returns true after CreateObject or GetObject.
CreateObject doesn't seem to open additional copies of Outlook as I would have expected. And I can't see why GetOject shouldn't work if Outlook is open.
As I said in my initial post, it all works fine on my notebook which is similarly configured with WinXP, OfficeXP Developer and Access 2003.
Unless anyone has a better suggestion, I'll try uninstalling Access 2003 then, if that doesn't work, reinstalling Office XP.
Thanks Tom
I saw a posting describing a similar problem, but no solution appeared in
the thread.
I'll do the reinstall later and post the result.
--
Bob Darlington
Brisbane
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:dn********************************@4ax.com... On Mon, 13 Sep 2004 09:59:22 +1000, "Bob Darlington" <bo*@dpcmanAX.com.au> wrote:
I'm really surprised by this error -2147221020 = 800401e4 = Invalid syntax. Does this happen on other machines as well? A quick Google search turned up mostly ADSI related issues - not much on Outlook. I think your uninstall / reinstall is a good idea.
-Tom.
Thanks for the reply Tom. I tried your suggestion, but get the same result - Err 429 if Outlook is
notopen before I start.
If Outlook is open, and I use CreateObject, it works fine. If Outlook is open and I use GetObject I get err -2147221020 and it fails IsObject returns true after CreateObject or GetObject.
CreateObject doesn't seem to open additional copies of Outlook as I would have expected. And I can't see why GetOject shouldn't work if Outlook is open.
As I said in my initial post, it all works fine on my notebook which is similarly configured with WinXP, OfficeXP Developer and Access 2003.
Unless anyone has a better suggestion, I'll try uninstalling Access 2003 then, if that doesn't work, reinstalling Office XP.
To follow up my earlier posts, I have now uninstalled Access 2003 and Office
XP, then reinstalled Office XP and all SP's (up to SP3).
And it still won't work.
If anyone else has encountered this problem (with or without a solution) I
would like to hear about it.
--
Bob Darlington
Brisbane
"Bob Darlington" <bo*@dpcmanAX.com.au> wrote in message
news:41**********************@news.optusnet.com.au ... I'm using Access 2002 to try to open Outlook 2002 (late binding) using: Dim objOutlook As Object Set objOutlook = CreateObject("Outlook.Application")
I get the above error if Outlook is closed when the routine runs. If Outlook is open, it runs fine, but doesn't seem to open another copy of Outlook (strange?) It has been working OK previously, and the only change to my system (I can think of) is the installation of Access 2003. When I copy the program to another machine (with all the same apps installed - ie A2002 and A2003 and OL2002) it works fine.
I've seen a couple of posts with similar problems, but can find no solutions. Any ideas appreciated.
-- Bob Darlington Brisbane
"Bob Darlington" <bo*@dpcmanAX.com.au> wrote in
news:41**********************@news.optusnet.com.au : To follow up my earlier posts, I have now uninstalled Access 2003 and Office XP, then reinstalled Office XP and all SP's (up to SP3). And it still won't work. If anyone else has encountered this problem (with or without a solution) I would like to hear about it.
I found the following solution on Office Online. The problem is most
likely that for whatever reason, your DAO26.dll registry entries were
altered or removed. To re-register this control, click on Start | Run and
enter the following: regsvr32 "C:\Program Files\Common Files\Microsoft
Shared\DAO\DAO360.DLL". This solved the problem for me. Hope it works for
you.
Thanks Mike.
Tried it but didn't solve it.
--
Bob Darlington
Brisbane
"Mike" <mr*@mrc.mrc> wrote in message
news:Xn***********************@216.221.81.119... "Bob Darlington" <bo*@dpcmanAX.com.au> wrote in news:41**********************@news.optusnet.com.au :
To follow up my earlier posts, I have now uninstalled Access 2003 and Office XP, then reinstalled Office XP and all SP's (up to SP3). And it still won't work. If anyone else has encountered this problem (with or without a solution) I would like to hear about it.
I found the following solution on Office Online. The problem is most likely that for whatever reason, your DAO26.dll registry entries were altered or removed. To re-register this control, click on Start | Run and enter the following: regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL". This solved the problem for me. Hope it works
for you. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: brazilnut |
last post by:
Hi. Let me explain the setup. I am using Visual Studio .NET to develop a sort of add-in (COM class) for Excel called SQLAddin. It basically queries a SQL server and pulls in data. Now within my...
|
by: John Gabriel |
last post by:
I have set up a website and am testing ASPs. I have created
a very simple ActiveX component with two interfaces:
AboutBox() - displays About details
calcpi() - returns 3.14159
Here is my...
|
by: Munsifali Rashid |
last post by:
Hi,
I've built a webservice in C# that can add public folders to Exchange.
There's also a component built in VB6 which references the Outlook 10 (XP)
DLL, so I can change the default form being...
|
by: Jeffery Franzen |
last post by:
Anyone know where the documentation is regarding Activex controls in asp web forms?
I'm using VS.NET 2002 enterprise and am trying to use Activex controls in vb.net web form app.
I do the add...
|
by: John Gabriel |
last post by:
I have set up a website and am testing ASPs. I have created
a very simple ActiveX component with two interfaces:
AboutBox() - displays About details
calcpi() - returns 3.14159
Here is my...
| |
by: HKSHK |
last post by:
This list compares the error codes used in VB.NET 2003 with those used
in VB6.
Error Codes:
============
3: This Error number is obsolete and no longer used. (Formerly:
Return without GoSub)...
|
by: drk.kumar |
last post by:
I have an implementation issue with WMI scripts to check the user
machine processor. The implementation is working fine in the local
machine (Windows XP operating system). It is throwing script...
|
by: Lucy Ludmiller |
last post by:
Sorry about the cross posts, not sure which group is the most relevant,
since I am using C++, MFC/COM and VB6
I have written an MFC ActiveX control in C++. I want to use the control
in VB6. The...
|
by: Steve Kershaw |
last post by:
Hi,
I have a simple web page that starts Excel and fills it with some
dummy data. Using IE I can run this web page from the C: drive (IE: "C:
\startexcel.htm") and it runs fine. However, when I...
|
by: syedsarfaraz |
last post by:
Hi There!
Could anybody please help regarding the below issue.
We had a COM+ component deployed on Windows 2000/NT machine it was working fine, I mean when it was being invoked from other...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |