I'm IN Outlook. I've seen tons of examples on how to program Access to
manipulate Outlook but a few archaic examples from Outlook, none of which I
can understand.

I'd like to use ado because I know it.

I'll try anything right now. The DAO.Recordset object won't work with

Dim rs as DAO.Recordset
or
Dim rs
Set rs = CreateObject("DAO.RecordSet")

Something with this CreateObject method that's needed in Outlook

Any suggestions would be greatly welcomed.

When you say "The DAO.Recordset object won't work", do you mean that you're
getting a "user-type not defined" error?

If so, the problem is likely that you haven't set a reference to DAO. While
in the VB Editor with no code running, select Tools | References from the
menu bar, scroll through the list of available references until you find the
entry for Microsoft DAO 3.6 Object Library, select it, then exit the dialog.

Also, the DAO model is different than the ADO. DAO Recordsets don't have an
existence of their own: you can't use CreateObject to instantiate one.
Instead, you need to use the OpenRecordset method of either the Database or
QueryDef objects.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"C Hayes" <(E-Mail Removed)> wrote in message
news:5433DB45-2E8D-468B-8D59-(E-Mail Removed)...
> I'm IN Outlook. I've seen tons of examples on how to program Access to
> manipulate Outlook but a few archaic examples from Outlook, none of which
> I
> can understand.
>
> I'd like to use ado because I know it.
>
> I'll try anything right now. The DAO.Recordset object won't work with
>
> Dim rs as DAO.Recordset
> or
> Dim rs
> Set rs = CreateObject("DAO.RecordSet")
>
> Something with this CreateObject method that's needed in Outlook
>
> Any suggestions would be greatly welcomed.

Thank you.

"Douglas J. Steele" wrote:

> When you say "The DAO.Recordset object won't work", do you mean that you're
> getting a "user-type not defined" error?
>
> If so, the problem is likely that you haven't set a reference to DAO. While
> in the VB Editor with no code running, select Tools | References from the
> menu bar, scroll through the list of available references until you find the
> entry for Microsoft DAO 3.6 Object Library, select it, then exit the dialog.
>
> Also, the DAO model is different than the ADO. DAO Recordsets don't have an
> existence of their own: you can't use CreateObject to instantiate one.
> Instead, you need to use the OpenRecordset method of either the Database or
> QueryDef objects.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "C Hayes" <(E-Mail Removed)> wrote in message
> news:5433DB45-2E8D-468B-8D59-(E-Mail Removed)...
> > I'm IN Outlook. I've seen tons of examples on how to program Access to
> > manipulate Outlook but a few archaic examples from Outlook, none of which
> > I
> > can understand.
> >
> > I'd like to use ado because I know it.
> >
> > I'll try anything right now. The DAO.Recordset object won't work with
> >
> > Dim rs as DAO.Recordset
> > or
> > Dim rs
> > Set rs = CreateObject("DAO.RecordSet")
> >
> > Something with this CreateObject method that's needed in Outlook
> >
> > Any suggestions would be greatly welcomed.
>
>
>