|
outlook
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ActiveX component can't create objectI 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 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. -- Show quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Mark A. Sam" <MarkA***@EmEssEm.Com> wrote in message news:uAotibeKIHA.1184@TK2MSFTNGP04.phx.gbl... >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 > > > > > 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 Show quote "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:OdfjIqfKIHA.4584@TK2MSFTNGP03.phx.gbl... > 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" <MarkA***@EmEssEm.Com> wrote in message > news:uAotibeKIHA.1184@TK2MSFTNGP04.phx.gbl... >>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 >> >> >> >> >> > > sue mosher suggested Set olookApp =
CreateObject("Outlook.Application","localhost") to me and it worked Show quote "Mark A. Sam" <MarkA***@EmEssEm.Com> wrote in message news:eQpSEVhKIHA.2176@TK2MSFTNGP06.phx.gbl... > 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" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message > news:OdfjIqfKIHA.4584@TK2MSFTNGP03.phx.gbl... >> 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" <MarkA***@EmEssEm.Com> wrote in message >> news:uAotibeKIHA.1184@TK2MSFTNGP04.phx.gbl... >>>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 >>> >>> >>> >>> >>> >> >> > > Thank you John, but I did a repair on Office and that resolved the problem.
Show quote "John" <John@nospam.infovis.co.uk> wrote in message news:e9eFYIJLIHA.3356@TK2MSFTNGP02.phx.gbl... > sue mosher suggested Set olookApp = > CreateObject("Outlook.Application","localhost") to me and it worked > > "Mark A. Sam" <MarkA***@EmEssEm.Com> wrote in message > news:eQpSEVhKIHA.2176@TK2MSFTNGP06.phx.gbl... >> 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" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message >> news:OdfjIqfKIHA.4584@TK2MSFTNGP03.phx.gbl... >>> 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" <MarkA***@EmEssEm.Com> wrote in message >>> news:uAotibeKIHA.1184@TK2MSFTNGP04.phx.gbl... >>>>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 >>>> >>>> >>>> >>>> >>>> >>> >>> >> >> > > try
Set olookApp = CreateObject("Outlook.Application","localhost") Show quote "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:OdfjIqfKIHA.4584@TK2MSFTNGP03.phx.gbl... > 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" <MarkA***@EmEssEm.Com> wrote in message > news:uAotibeKIHA.1184@TK2MSFTNGP04.phx.gbl... >>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 >> >> >> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics