|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
January 10th 07, 05:25 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Access.Application Type Undefined
I'm trying to access MS Acess from Outlook, both 2003.
When the following bit of code runs: Dim appAccess As Access.Application I get the message Compile error: user-defined type not defined. Anyone know what's going on? Thanks. 
|
| Ads |
|
#2
January 10th 07, 06:04 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Access.Application Type Undefined
Did you add Access to your project refrences?
Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message news  I'm trying to access MS Acess from Outlook, both 2003. When the following bit of code runs: Dim appAccess As Access.Application I get the message Compile error: user-defined type not defined. Anyone know what's going on? Thanks.
|
|
#3
January 10th 07, 06:25 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Access.Application Type Undefined
No. How do you do that? Actually I copied this code from another machine
where it works under the same release of Outlook and Access. "Dmitry Streblechenko" wrote: Did you add Access to your project refrences? Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message news I'm trying to access MS Acess from Outlook, both 2003. When the following bit of code runs: Dim appAccess As Access.Application I get the message Compile error: user-defined type not defined. Anyone know what's going on? Thanks.
|
|
#4
January 10th 07, 07:02 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Access.Application Type Undefined
Tools|References in the VBA editor.
Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message ... No. How do you do that? Actually I copied this code from another machine where it works under the same release of Outlook and Access. "Dmitry Streblechenko" wrote: Did you add Access to your project refrences? Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message news I'm trying to access MS Acess from Outlook, both 2003. When the following bit of code runs: Dim appAccess As Access.Application I get the message Compile error: user-defined type not defined. Anyone know what's going on? Thanks.
|
|
#5
January 10th 07, 07:55 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Access.Application Type Undefined
Thanks, Dimitry. That got me a little further.
The code: Dim appAccess As Access.Application no longer produces a compile error. However, when this code runs: Set appAccess = CreateObject("Access.Application") I get the error message: "-1836580859 (92880005) The program for the attachment may not have been installed properly or may have been moved or deleted. Reinstall the program in which the attachment was created." I'm afraid this message makes no sense to me, particularly in its reference to an "attachment" (an Outlook email attachment?) Does it to you? Do you know where I might be able look it up? Thanks for your help. "Dmitry Streblechenko" wrote: Tools|References in the VBA editor. Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message ... No. How do you do that? Actually I copied this code from another machine where it works under the same release of Outlook and Access. "Dmitry Streblechenko" wrote: Did you add Access to your project refrences? Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message news
I'm trying to access MS Acess from Outlook, both 2003.When the following bit of code runs: Dim appAccess As Access.Application I get the message Compile error: user-defined type not defined. Anyone know what's going on? Thanks.
|
|
#6
January 10th 07, 09:32 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Access.Application Type Undefined
I have never seen that error. Does it matter whether Access is running or
not when that code is executed? Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message ... Thanks, Dimitry. That got me a little further. The code: Dim appAccess As Access.Application no longer produces a compile error. However, when this code runs: Set appAccess = CreateObject("Access.Application") I get the error message: "-1836580859 (92880005) The program for the attachment may not have been installed properly or may have been moved or deleted. Reinstall the program in which the attachment was created." I'm afraid this message makes no sense to me, particularly in its reference to an "attachment" (an Outlook email attachment?) Does it to you? Do you know where I might be able look it up? Thanks for your help. "Dmitry Streblechenko" wrote: Tools|References in the VBA editor. Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message ... No. How do you do that? Actually I copied this code from another machine where it works under the same release of Outlook and Access. "Dmitry Streblechenko" wrote: Did you add Access to your project refrences? Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message news
I'm trying to access MS Acess from Outlook, both 2003.When the following bit of code runs: Dim appAccess As Access.Application I get the message Compile error: user-defined type not defined. Anyone know what's going on? Thanks.
|
|
#7
January 10th 07, 09:41 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Access.Application Type Undefined
Dimitry,
I don't know if the message is spurious or not. As it turned out, I was having a couple of other weird problems with MS Access, so I ran a Detect and Repair on Microsoft Office and now they've all gone away, and I'm in business again. Thanks for your help. "Dmitry Streblechenko" wrote: I have never seen that error. Does it matter whether Access is running or not when that code is executed? Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message ... Thanks, Dimitry. That got me a little further. The code: Dim appAccess As Access.Application no longer produces a compile error. However, when this code runs: Set appAccess = CreateObject("Access.Application") I get the error message: "-1836580859 (92880005) The program for the attachment may not have been installed properly or may have been moved or deleted. Reinstall the program in which the attachment was created." I'm afraid this message makes no sense to me, particularly in its reference to an "attachment" (an Outlook email attachment?) Does it to you? Do you know where I might be able look it up? Thanks for your help. "Dmitry Streblechenko" wrote: Tools|References in the VBA editor. Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message ... No. How do you do that? Actually I copied this code from another machine where it works under the same release of Outlook and Access. "Dmitry Streblechenko" wrote: Did you add Access to your project refrences? Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Michael Ryle" wrote in message news
I'm trying to access MS Acess from Outlook, both 2003.When the following bit of code runs: Dim appAccess As Access.Application I get the message Compile error: user-defined type not defined. Anyone know what's going on? Thanks.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Internet Explorer Script Error 'hoverEdit' is undefined | robin | Outlook Express | 5 | November 7th 06 12:14 AM |
| how do i type infomation on a pdf application | Pete | Outlook - General Queries | 2 | October 18th 06 07:49 PM |
| how to access java application from Outlook? | Old_Mortality | Add-ins for Outlook | 0 | May 24th 06 02:55 PM |
| Why do I get a type mismatch when trying to access mail items? | Pete Dawson (Leeds Uni) | Outlook and VBA | 3 | March 3rd 06 02:16 PM |
| Undefined Object: testing for Nothing (Redemption) | Martin | Outlook and VBA | 3 | January 25th 06 10:21 AM |
Linear Mode
