Re: Sorting a table used in a form

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Keith Smothers (Keith.Smothers_at_state.or.us)
Date: 05/18/04 

Date: Tue, 18 May 2004 07:27:05 -0700

Doug -

Thanks for the feedback! I have printed out the article
you provided the link for and I'm going to start hacking.

BTW, I didn't mention this in my original post, but
ultimately I want to be able to use this form in my
emails. I have Word set up as my email editor, so I'm
assuming once I get the form working in Word, I will be
able to use it in Outlook. Any gotchas there?

Thanks again,
Keith

>-----Original Message-----
>Hi Keith,
>
>I thought that you should be able to do that by running a
macro on exit from
>a formfield that unprotected the document, sorted the
table and then
>reprotected the document. However, every time that I
tried it, it caused
>Word to crash, even when I included a command to .Unlink
the formfields.
>
>Regardless, I do not consider this type of form very
suitable for entering
>orders as it is difficult to accomodate varying numbers
of items.
>
>I would use a userform with a listbox that I would
populate with the details
>of each item that would be entered into text boxes on the
form with an add
>button to transfer the data to the listbox. The you
would have another
>button on the form that would transfer the information
from the listbox to a
>table in the document and do the sort.
>
>See the article "How to create a Userform" at:
>
>http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
>
>
>--
>Please post any further questions or followup to the
newsgroups for the
>benefit of others who may be interested. Unsolicited
questions forwarded
>directly to me will only be answered on a paid consulting
basis.
>
>Hope this helps
>Doug Robbins - Word MVP
>"Keith Smothers" <Keith.Smothers@state.or.us> wrote in
message
>news:e47b01c43c53$b939edb0$a601280a@phx.gbl...
>> I have a document set up as an ordering form. I have
used
>> the Form menu to create the various fields I need to
fill
>> in for the order.
>>
>> For the basic layout of the form I used a six column
>> table. After I enter all of my items, I need to be able
to
>> sort the entire table by item number (one of the fields
I
>> have created in the form/table).
>>
>> To speed up data entry, I want to be able to enter the
>> item numbers in order and then sort the table after data
>> entry. Is there any way to do this while using
the 'forms'
>> set up?
>>
>> TIA
>> Keith
>
>.
>

Quantcast