DAO in OLXP?

[Andy Bowden]

Morning All,

I would love to know how to populate standard fields in
the task request frm from a record set obtained from
either SQL or Jet. i know a little VBA & have written a
few apps in access, but im not sure how you open a recSet
from within an OL form and then use the result to populate
a combo box. i know im asking a lot, but any help would be
appreciated.

Many thanks

Newbie

 

[Ken Slovak - [MVP - Outlook]]

You can certainly use DAO in Outlook code as well as ADO and direct
control of Access using Access object model code (automation code).
However you can't directly work with task request items. You must
create a task item, assign it and then add a recipient and then send
it to have Outlook create the task request item.

For examples of Outlook forms using database code see
http://www.slipstick.com/dev/database.htm

For information about developing with Outlook forms see
http://www.slipstick.com/dev/forms.htm

 

[andy bowden]

Ken,

thank you very much for your help

-----Original Message-----
You can certainly use DAO in Outlook code as well as ADO and direct
control of Access using Access object model code (automation code).
However you can't directly work with task request items. You must
create a task item, assign it and then add a recipient and then send
it to have Outlook create the task request item.

For examples of Outlook forms using database code see
http://www.slipstick.com/dev/database.htm

For information about developing with Outlook forms see
http://www.slipstick.com/dev/forms.htm







.