EXPORT CUSTOM FORM FIELDS TO A DATABASE

[Shree]

Hello,
I have created several custom fields in a form(Message). I have 7
tabs(layers) in the form since it has to go to seven other people before the
response in received by me. I would like to export it to an Access database
to generate reports.
Can anyone please show me how to code in order to retrieve the data in access.
Thanks in advance.
Shree

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/d/customimport.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Hollis D. Paul]

Can anyone please show me how to code in order to retrieve the data in access.
Thanks in advance.

Go to www.outlook-cod.com and/or www.slipstick.com and search on access. I am
sure you can find a sample code there that you can modify for your purposes.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA

 

[Stephaan]

Hi Shree
I have the same problem as you have and I was wondering whether you have
been able to solve it with the responses given. I have browsed through the
presented wites but I have not found something usefull yet
Should you have been able to solve your problem, would you share the result
with me ?
Thanks in advance
Stephaan

"Shree" schreef:

 

[Shree]

Thanks Sue,
I tried codes that you indicated.
After I create a table in access with the custom fields that I have in
outlook forms, what should be my next step.
I tried 23.2.1 about the DSN tab in your book, what should I do after that
to get fields in to the access database. I do not know that much coding,
Being a beginner at this, I'm lost. Please help.
Thanks.

 

[Shree]

I tried the same, but to no avail. I will let you know if I come up with
anything.
Shree

 

[Sam]

Okay ... I've read this, looked at it and I'm still a bit baffled.

How do you get this code into your form so the end user can print it in a
usable form? I didn't program my form in VBA (I don't understand VBA) ... I
used design forms in OUTLOOK.

I'm 95% done with the way "they" want it to look on the screen; now to get
it to look right for the end user(s).

I'm open to NETMEETING help; phone help; email help.

Thanx ...

 

[Sue Mosher [MVP-Outlook]]

Put a command button on the form and add code to its Click event:

Sub CommandButton1_Click()
' your code goes here
End Sub

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Sam]

Thanx ....

Where is the "CLICK EVENT"?

--
"To dream of the person you would like to be is to waste the person you are."

Put a command button on the form and add code to its Click event:

Sub CommandButton1_Click()
' your code goes here
End Sub

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Sue Mosher [MVP-Outlook]]

Click is the event that fires when a user clicks a command button on a published custom Outlook form. The code for the Click event handler is located wherever you write it in the Outlook form VBScript code window, using the basic structure that I provided to declare the procedure.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Sam]

When I open the control box and drag the "COMMAND BUTTON" icon to my form.
How do I get to the script page to place your code to export the form's
information.

When I right click on the box, I don't see anywhere in the Properties or
Advance Properties to place script.

 

[Sue Mosher [MVP-Outlook]]

Open the custom form code's window with the Form | View Code command, then type in your code there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers