Custom form for Access

[Gargamil]

I am doing some consulting work whereby I need to request information back
from the customers. All are using Outlook so I was hoping I could create a
custom Outlook form which they could update and return to me. So,
* can I generate the contents of the custom form and send it in code from
Access
* can the form have more than one record ala a spreadsheet type table of
data?
* can this form be modified by the end user and returned?
* can the results be read out of Outlook into an Access database
I'm conversant in the use of the automation object of Outlook via Access,
what I lack is the knowledge on the creation and dissemination of the
Outlook forms, and the reading of this info back into Access.

What is the best online reference for creating this type of form???

g

 

[Sue Mosher [MVP-Outlook]]

Comments inline.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

I am doing some consulting work whereby I need to request information back
from the customers. All are using Outlook so I was hoping I could create
a
custom Outlook form which they could update and return to me. So,
* can I generate the contents of the custom form and send it in code from
Access
Yes.

* can the form have more than one record ala a spreadsheet type table of
data?

Not directly. Each Outlook item is a separate data record. You can, however,
write code to use a spreadsheete control to present the item's data. See
http://www.outlookcode.com/d/spreadsheetcontrol.htm

* can this form be modified by the end user and returned?

Not the form, which is a UI/code template, but the item.

* can the results be read out of Outlook into an Access database

Yes, but you'll have to write the custom code to do this.

I'm conversant in the use of the automation object of Outlook via Access,
what I lack is the knowledge on the creation and dissemination of the
Outlook forms, and the reading of this info back into Access.

See http://www.outlookcode.com/d/forms.htm and
http://www.outlookcode.com/d/database.htm

 

[Gargamil]

Thanks Sue. Ironically I was asking the question because your book had not
yet turned up. Hope it's a page turner