Re: What is the Best Way to Fill a Pre Printed Form With Various Data
- From: "Rob Giordano \(Crash\)" <webmaster@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 5 Mar 2006 23:11:19 -0700
Probably a zillion ways to do this.
Create the form in Word and save it as a template - a .dot file.
Or if you need to calculate items on hand etc....create it in Excel as a
blank Worksheet then save new worksheets as you need every month.
Or as a fillable PDF?
"Michael D" <MichaelD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:784D18AA-7591-4534-A5D8-75468354A3D2@xxxxxxxxxxxxxxxx
| Hello,
|
| Please pardon my sounding like a beginner. I am one.
|
| I have a legacy form which I am mandated to use to do an inventory of
| material on a daily basis.
|
| 1. The form is used on a monthly basis and a new form must be made each
| month.
| 1. All header information is preprinted and does not change.
| 2. The body consists of seventeen lines.
| a. Each line has three different fields of information that is subject
| to change.
| (1) The name of the item. Max 25 char. This needs to wrap to fit
in
| the box.
| (2) The quantity. Max 2 digits.
| (3) Serial numbers. This can be from one to eleven digits. It may
| also express a range such as 12345-12346
| b. Some lines will be deleted each month, and some new lines will be
| added each month.
| c. Each line has 31 blocks which are manually checked when doing
| inventory.
| 3. The footer has 4 items of information.
| a. The month (January, February, etc.).
| b. The page number (single digit)
| c. The number of pages (single digit)
| d. The container number (single digit).
|
| Right now I am producing the monthly forms manually which means I must
type
| in each element every time every month.
|
| I want to automate this so that I can simply edit the information for the
| body of the form, deleting items no longer in possession, and adding those
| few items added each month.
|
| The forms should be produced with the body lines in alpha-numeric order
with
| a different batch for each container with the page and number of pages
| reflecting the number of forms produced for that container. I want to
begin
| with a new batch of page and number of pages for each container. Once the
| body information is modified for the month, I want to produce the forms
for
| all containers in a single execution.
|
| I tried to produce this in MS Access using reports, but reached the 754
| limit on controls.
|
| Does anyone have any ideas about the best way to go about automating
this???
|
| Thank you
| --
| Michael D
| Seoul ROK
.
- Prev by Date: Re: files won't open
- Next by Date: Caption - reference problems
- Previous by thread: Re: Shred - Wash with Bleach??
- Next by thread: Caption - reference problems
- Index(es):
Relevant Pages
|
