Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
Hello
I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
What type of form it this - A custom dialog (user form) or a document that
is protected for filling in forms. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hello I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
Hi Doug
It is a document that is protected for filling in forms. Cheers "Doug Robbins - Word MVP" wrote: What type of form it this - A custom dialog (user form) or a document that is protected for filling in forms. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hello I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
In that case what you have is a dropdown list form field rather than a combo
box, but the list items should remain available unless you are saving data only. OTOH, if there is VBA code involved, then this is more than a protected form. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Owen" wrote in message ... Hi Doug It is a document that is protected for filling in forms. Cheers "Doug Robbins - Word MVP" wrote: What type of form it this - A custom dialog (user form) or a document that is protected for filling in forms. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hello I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
Hi Suzanne
Yes, there is VBA Code within my document template. The lists are definetely Combo Boxes. I couldn't use a List Box as they were limited to 20 items i think, whereas my Combo Box has over 200 items. Any thoughts on why the Combo Box contents is not saving following multiple saves to document format from the original .dot format? Thanks again "Suzanne S. Barnhill" wrote: In that case what you have is a dropdown list form field rather than a combo box, but the list items should remain available unless you are saving data only. OTOH, if there is VBA code involved, then this is more than a protected form. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Owen" wrote in message ... Hi Doug It is a document that is protected for filling in forms. Cheers "Doug Robbins - Word MVP" wrote: What type of form it this - A custom dialog (user form) or a document that is protected for filling in forms. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hello I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
You say the document is protected. Is it protected for forms or some other
kind of protection? ActiveX controls and forms protection are not compatible. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Owen" wrote in message ... Hi Suzanne Yes, there is VBA Code within my document template. The lists are definetely Combo Boxes. I couldn't use a List Box as they were limited to 20 items i think, whereas my Combo Box has over 200 items. Any thoughts on why the Combo Box contents is not saving following multiple saves to document format from the original .dot format? Thanks again "Suzanne S. Barnhill" wrote: In that case what you have is a dropdown list form field rather than a combo box, but the list items should remain available unless you are saving data only. OTOH, if there is VBA code involved, then this is more than a protected form. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Owen" wrote in message ... Hi Doug It is a document that is protected for filling in forms. Cheers "Doug Robbins - Word MVP" wrote: What type of form it this - A custom dialog (user form) or a document that is protected for filling in forms. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hello I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
Show us the code that you are using the populate the combobox in the first
case. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hi Suzanne Yes, there is VBA Code within my document template. The lists are definetely Combo Boxes. I couldn't use a List Box as they were limited to 20 items i think, whereas my Combo Box has over 200 items. Any thoughts on why the Combo Box contents is not saving following multiple saves to document format from the original .dot format? Thanks again "Suzanne S. Barnhill" wrote: In that case what you have is a dropdown list form field rather than a combo box, but the list items should remain available unless you are saving data only. OTOH, if there is VBA code involved, then this is more than a protected form. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Owen" wrote in message ... Hi Doug It is a document that is protected for filling in forms. Cheers "Doug Robbins - Word MVP" wrote: What type of form it this - A custom dialog (user form) or a document that is protected for filling in forms. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hello I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
Hi Doug/Suzanne
The form is protected using Microsoft Word 2003 "Tools/Protect Document" on the main menu. The code used to populate the combo box with numerous items is: Private Sub Document_New() With ComboBox1 ..AddItem "Sample Text" End With End Sub When a document is first opened from the template, all the list items are available. I save the document (.doc) that the user completes using "Save As" to another .doc file. ie i want to now use the completed form as a basis for the next report. At this stage however, the new document loses all the information in the combo box list. Thanks again "Doug Robbins - Word MVP" wrote: Show us the code that you are using the populate the combobox in the first case. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hi Suzanne Yes, there is VBA Code within my document template. The lists are definetely Combo Boxes. I couldn't use a List Box as they were limited to 20 items i think, whereas my Combo Box has over 200 items. Any thoughts on why the Combo Box contents is not saving following multiple saves to document format from the original .dot format? Thanks again "Suzanne S. Barnhill" wrote: In that case what you have is a dropdown list form field rather than a combo box, but the list items should remain available unless you are saving data only. OTOH, if there is VBA code involved, then this is more than a protected form. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Owen" wrote in message ... Hi Doug It is a document that is protected for filling in forms. Cheers "Doug Robbins - Word MVP" wrote: What type of form it this - A custom dialog (user form) or a document that is protected for filling in forms. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hello I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Combo Box
You should save the document as a Template and then use FileNew and select
the template when you want to create a new document. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hi Doug/Suzanne The form is protected using Microsoft Word 2003 "Tools/Protect Document" on the main menu. The code used to populate the combo box with numerous items is: Private Sub Document_New() With ComboBox1 .AddItem "Sample Text" End With End Sub When a document is first opened from the template, all the list items are available. I save the document (.doc) that the user completes using "Save As" to another .doc file. ie i want to now use the completed form as a basis for the next report. At this stage however, the new document loses all the information in the combo box list. Thanks again "Doug Robbins - Word MVP" wrote: Show us the code that you are using the populate the combobox in the first case. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hi Suzanne Yes, there is VBA Code within my document template. The lists are definetely Combo Boxes. I couldn't use a List Box as they were limited to 20 items i think, whereas my Combo Box has over 200 items. Any thoughts on why the Combo Box contents is not saving following multiple saves to document format from the original .dot format? Thanks again "Suzanne S. Barnhill" wrote: In that case what you have is a dropdown list form field rather than a combo box, but the list items should remain available unless you are saving data only. OTOH, if there is VBA code involved, then this is more than a protected form. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Owen" wrote in message ... Hi Doug It is a document that is protected for filling in forms. Cheers "Doug Robbins - Word MVP" wrote: What type of form it this - A custom dialog (user form) or a document that is protected for filling in forms. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Owen" wrote in message ... Hello I have a Microsoft Word 2003 Template Form which contains numerous Combo Boxes. The form is for a daily report we issue to clients. When the user creates a new document from the template, all the items are available within the Combo Box Listing. The user completes the form and saves the document. We then wish to be able to copy the completed form and amend it on a daily basis. The problem we are having, is that the items listed within the Combo Box dissappear when we copy the previous word document. Is there something i can enter within my VBA code to keep the combo boxes populated with the previous selections? Thanks for any help you can provide. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box | Microsoft Word Help | |||
Combo Box | Microsoft Word Help | |||
Combo Box with Yes/No | New Users | |||
Create Protected Word template that uses combo box & combo box val | Microsoft Word Help | |||
combo box | Microsoft Word Help |