|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
September 20th 06, 04:09 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
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 
|
| Ads |
|
#2
September 20th 06, 05:20 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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
|
|
#3
September 20th 06, 06:08 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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
|
|
#4
September 20th 06, 06:18 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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
|
|
#5
September 20th 06, 06:56 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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
|
|
#6
September 20th 06, 07:10 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I export custom fields into excel? | Sarah S. | Outlook - General Queries | 0 | September 11th 06 11:15 PM |
| How do I export a contacts list which includes custom fields | CarrieW | Outlook - Using Contacts | 2 | March 28th 06 07:47 PM |
| Fields get created in folder, not in custom form | kkarre | Outlook - Using Forms | 2 | February 2nd 06 08:56 PM |
| Can custom form data populate access database | jbtempe | Outlook - Using Forms | 1 | January 20th 06 03:02 PM |
Linear Mode
