M
Michael D
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
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