Form Automation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mlevy86@gmail.com - 26 Aug 2006 18:01 GMT

I am currently in the processes of creating a monthly report for an
organization to fill out monthly , but I have run into a bit of a road
block. I am looking for a way to to have the following inputted into
my form when a user needs it:

Date and time of event: Program Length (hrs):
# in attendance: # of members in attendance:
Title of Program:
Types of publicity and area publicized:
Description of event:
Cosponsored with:
National Requirement? Select One

The problem is that since the number of programs changes every month I
want a way so they can click a button and a macro (or anything) would
create the above information below the previous entry. Also in the
text above I would like a form fields inserted where they answer each
of the questions. I would appreciate any help. Thanks.

Reply to this Message

Doug Robbins - Word MVP - 26 Aug 2006 18:29 GMT

I think that the best way to do that would be to make use of a userform that
had controls on it into which the user could insert the information for a
particular program, then they would click either a button which allowed them
to add the information for another program or a button for when they had
entered the information for the last program. The first button would
transfer the information into the document and clear the data from the
controls on the userform so that the user could enter more information. The
second button would transfer the last lot of information into the document
and then dismiss the userform.

For the basics, see the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

However, your application is going to be quite a bit different from that
simple example. We would need to see a sample of the actual layout that you
want to create to tell you exactly how to go about it.

Signature

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

>I am currently in the processes of creating a monthly report for an
> organization to fill out monthly , but I have run into a bit of a road
[quoted text clipped - 14 lines]
> text above I would like a form fields inserted where they answer each
> of the questions. I would appreciate any help. Thanks.

Reply to this Message

mlevy86@gmail.com - 27 Aug 2006 02:02 GMT

is there a way to post the document on here, or what is the best way to
show you the formatting? Thanks for the help!

> I think that the best way to do that would be to make use of a userform that
> had controls on it into which the user could insert the information for a
[quoted text clipped - 40 lines]
> > text above I would like a form fields inserted where they answer each
> > of the questions. I would appreciate any help. Thanks.

Reply to this Message

Doug Robbins - Word MVP - 27 Aug 2006 06:55 GMT

email it to me at dkr@mvps.org

Signature

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

> is there a way to post the document on here, or what is the best way to
> show you the formatting? Thanks for the help!
[quoted text clipped - 47 lines]
>> > text above I would like a form fields inserted where they answer each
>> > of the questions. I would appreciate any help. Thanks.

Reply to this Message