![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: activex, cant, component, create, object |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I have an MS Access2002 app that I imported into Access 2007. It was
running fine for a couple of weeks, then suddenly I get this error: ActiveX component can't create object when it executes this line of code. Set olookApp = CreateObject("Outlook.Application") I checked my references, and they are ok, and the app compiles ok. Thanks for any help and God Bless, Mark A. Sam |
| Ads |
|
#2
|
|||
|
|||
|
Are you sure Outlook is installed properly on the machine?
FWIW, CreateObject doesn't require references: it's how you'd instantiate the object in Late Binding. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Mark A. Sam" wrote in message ... I have an MS Access2002 app that I imported into Access 2007. It was running fine for a couple of weeks, then suddenly I get this error: ActiveX component can't create object when it executes this line of code. Set olookApp = CreateObject("Outlook.Application") I checked my references, and they are ok, and the app compiles ok. Thanks for any help and God Bless, Mark A. Sam |
|
#3
|
|||
|
|||
|
Doug,
Yes it is installed. In fact I have been running this for years. Recenlty I reinstalled Windows, installed Office2002, then Office2007, then uninstalled Office2002, becuase Access2003 was rendered unusuable. I move this app into an .accdb type database and it was working smoothly until yesterday. This is an error that use to come up occasionally in either database, but clear up when I closed and opened the database. Now I can't run it at all without the error and I need to run the procedure. God Bless, Mark "Douglas J. Steele" wrote in message ... Are you sure Outlook is installed properly on the machine? FWIW, CreateObject doesn't require references: it's how you'd instantiate the object in Late Binding. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Mark A. Sam" wrote in message ... I have an MS Access2002 app that I imported into Access 2007. It was running fine for a couple of weeks, then suddenly I get this error: ActiveX component can't create object when it executes this line of code. Set olookApp = CreateObject("Outlook.Application") I checked my references, and they are ok, and the app compiles ok. Thanks for any help and God Bless, Mark A. Sam |
|
#4
|
|||
|
|||
|
try
Set olookApp = CreateObject("Outlook.Application","localhost") "Douglas J. Steele" wrote in message ... Are you sure Outlook is installed properly on the machine? FWIW, CreateObject doesn't require references: it's how you'd instantiate the object in Late Binding. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Mark A. Sam" wrote in message ... I have an MS Access2002 app that I imported into Access 2007. It was running fine for a couple of weeks, then suddenly I get this error: ActiveX component can't create object when it executes this line of code. Set olookApp = CreateObject("Outlook.Application") I checked my references, and they are ok, and the app compiles ok. Thanks for any help and God Bless, Mark A. Sam |
|
#5
|
|||
|
|||
|
sue mosher suggested Set olookApp =
CreateObject("Outlook.Application","localhost") to me and it worked "Mark A. Sam" wrote in message ... Doug, Yes it is installed. In fact I have been running this for years. Recenlty I reinstalled Windows, installed Office2002, then Office2007, then uninstalled Office2002, becuase Access2003 was rendered unusuable. I move this app into an .accdb type database and it was working smoothly until yesterday. This is an error that use to come up occasionally in either database, but clear up when I closed and opened the database. Now I can't run it at all without the error and I need to run the procedure. God Bless, Mark "Douglas J. Steele" wrote in message ... Are you sure Outlook is installed properly on the machine? FWIW, CreateObject doesn't require references: it's how you'd instantiate the object in Late Binding. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Mark A. Sam" wrote in message ... I have an MS Access2002 app that I imported into Access 2007. It was running fine for a couple of weeks, then suddenly I get this error: ActiveX component can't create object when it executes this line of code. Set olookApp = CreateObject("Outlook.Application") I checked my references, and they are ok, and the app compiles ok. Thanks for any help and God Bless, Mark A. Sam |
|
#6
|
|||
|
|||
|
Thank you John, but I did a repair on Office and that resolved the problem.
"John" wrote in message ... sue mosher suggested Set olookApp = CreateObject("Outlook.Application","localhost") to me and it worked "Mark A. Sam" wrote in message ... Doug, Yes it is installed. In fact I have been running this for years. Recenlty I reinstalled Windows, installed Office2002, then Office2007, then uninstalled Office2002, becuase Access2003 was rendered unusuable. I move this app into an .accdb type database and it was working smoothly until yesterday. This is an error that use to come up occasionally in either database, but clear up when I closed and opened the database. Now I can't run it at all without the error and I need to run the procedure. God Bless, Mark "Douglas J. Steele" wrote in message ... Are you sure Outlook is installed properly on the machine? FWIW, CreateObject doesn't require references: it's how you'd instantiate the object in Late Binding. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Mark A. Sam" wrote in message ... I have an MS Access2002 app that I imported into Access 2007. It was running fine for a couple of weeks, then suddenly I get this error: ActiveX component can't create object when it executes this line of code. Set olookApp = CreateObject("Outlook.Application") I checked my references, and they are ok, and the app compiles ok. Thanks for any help and God Bless, Mark A. Sam |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Why does the Address property of the Recipient object in the Outlook object model look funny? | Omatase | Outlook - General Queries | 2 | July 13th 07 10:09 PM |
| Missing component: msvcr80.dll | Cheng Siong | Outlook - Installation | 1 | May 31st 07 10:11 AM |
| ActiveX component can't create object | muyBN | Outlook and VBA | 12 | September 1st 06 01:31 AM |
| Outlook VBA: ActiveX Component can't create object | Vinay Pandey | Outlook and VBA | 3 | August 16th 06 05:27 PM |
| Loading SPA component error | Sinan [XP-Pro] | Outlook Express | 5 | April 6th 06 04:17 PM |