EXPORT CUSTOM FORM FIELDS TO A DATABASE
 

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 ...

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


"Shree" wrote:

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

"Stephaan" wrote:

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:

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

EXPORT CUSTOM FORM FIELDS TO A DATABASE
 

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Sam" wrote in message ...
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 ...

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


"Shree" wrote:

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

"Stephaan" wrote:

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:

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

EXPORT CUSTOM FORM FIELDS TO A DATABASE
 

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 [MVP-Outlook]" wrote:

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Sam" wrote in message ...
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 ...

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


"Shree" wrote:

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

"Stephaan" wrote:

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:

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

EXPORT CUSTOM FORM FIELDS TO A DATABASE
 

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Sam" wrote in message ...

Where is the "CLICK EVENT"?



"Sue Mosher [MVP-Outlook]" wrote:

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

Sub CommandButton1_Click()
' your code goes here
End Sub


"Sam" wrote in message ...
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 ...

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


"Shree" wrote:

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

"Stephaan" wrote:

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:

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

EXPORT CUSTOM FORM FIELDS TO A DATABASE
 

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.


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


"Sue Mosher [MVP-Outlook]" wrote:

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Sam" wrote in message ...

Where is the "CLICK EVENT"?



"Sue Mosher [MVP-Outlook]" wrote:

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

Sub CommandButton1_Click()
' your code goes here
End Sub


"Sam" wrote in message ...
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 ...

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


"Shree" wrote:

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

"Stephaan" wrote:

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:

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

EXPORT CUSTOM FORM FIELDS TO A DATABASE
 

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Sam" wrote in message ...
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.


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


"Sue Mosher [MVP-Outlook]" wrote:

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.

"Sam" wrote in message ...

Where is the "CLICK EVENT"?



"Sue Mosher [MVP-Outlook]" wrote:

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

Sub CommandButton1_Click()
' your code goes here
End Sub


"Sam" wrote in message ...
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 ...

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


"Shree" wrote:

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

"Stephaan" wrote:

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:

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