Kath Pelletti
KP at sdsonline.net
Mon Mar 14 21:26:16 CST 2005
Charlotte- I've re-installed the CDO under Outlook install options and restarted the system. After trying a few other things as well - removing references and adding them again for Outlook I am still crashing with 'Automation error - the specified module cannot be found' on this line - Set nms = appOutlook.getnamespace ("MAPI") I have a little more background on this new PC: - PC was bought from Dell with Word and Powerpoint 2003 installed. - Office 2000 was then installed by another person. - Only now has the user tested our Access app with Outlook. Any tips? ----- Original Message ----- From: Charlotte Foust To: Access Developers discussion and problem solving Sent: Tuesday, March 15, 2005 12:20 PM Subject: RE: [AccessD] Urgent - missing Outllok in Refs Yup, that's the missing CDO, Collaborative Data Objects. When you install Office, you have to drill down in the Outlook part and check the CDO item to include it in the install. Otherwise, no MAPI calls. You can ONLY install CDO using a custom installation, not the default. Charlotte Foust -----Original Message----- From: Kath Pelletti [mailto:KP at sdsonline.net] Sent: Monday, March 14, 2005 5:11 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Urgent - missing Outllok in Refs Hi Charlotte - yes Outlook is installed. I have removed the old ref to Outlook 9 and then gone back thru' the ref list and found Outlook 11 and ticked that. But now when I use the function which looks for Outlook the code falls over with 'Automation error - the specified module cannot be found' Line where crash happens: Set nms = appOutlook.getnamespace ("MAPI") NB: This code has always worked until she has had Office re-installed (same version - 2000). I have had a look at the install and it seems fine - what else can I check? What is the CDO? THanks - Kath ----- Original Message ----- From: Charlotte Foust To: Access Developers discussion and problem solving Sent: Tuesday, March 15, 2005 11:55 AM Subject: RE: [AccessD] Urgent - missing Outllok in Refs Is Outlook installed on the machine? Even if it is, you can't use it from Access unless the CDO was installed as well. It isn't by default, but you can do a custom reinstall and add it. Charlotte Foust -----Original Message----- From: Kath Pelletti [mailto:KP at sdsonline.net] Sent: Monday, March 14, 2005 4:49 PM To: AccessD at databaseadvisors.com Subject: [AccessD] Urgent - missing Outllok in Refs Hi all - quick question as I am out with a client - She has a new laptop so an existing app has been re-installed - Outllok functions in Access mdb no longr working - I went into vba and expected to find a missing reference in the References window - but Outlook isnt there at all - what isn;t installed? THanks ______________________________________________ Kath Pelletti Software Design & Solutions Pty Ltd. Ph: 9505-6714 Fax: 9505-6430 KP at SDSOnline.net -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com