EXPORT CUSTOM FORM FIELDS TO A DATABASE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:
 
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.
 
I tried the same, but to no avail. I will let you know if I come up with
anything.
Shree
 
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 ...
 
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
 
Thanx ....

Where is the "CLICK EVENT"?

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


Sue Mosher said:
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
Click to expand...
 
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
 
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.
 
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
 
Back
Top