B
Buddy
I have a form that generates a unique serial number. The user chooses
a value from two combo boxes and a list box; a separate text box on
the same form then displays a serial number based on the selected
values, date(), and an autonumber through use of its control source.
There is a print button that sends this unique serial number to a
report and prints it out onto 4 small labels to be placed on the
finished goods.
Here's my question: The users need to be able to enter the quantity
of serial numbers they wish to generate. For example, if 100 units of
the same product are coming down the line, they need to be able say
they want to generate 100 of these unique serial numbers (with all
information in said form being stored in tblSerialNumber) and print
out all these labels at the same time, all at the touch of a button.
It will print four copies of each unique serial number because the
report it prints each serial number to is set to do so. Likewise, if
they know that 87 units are coming down the line, they need to be able
to choose 87 units.
Furthermore, touch screens are being used - is there a way to pull up
a small number pad on the screen so they can enter the quantity?
I'd really appreciate any help. Thanks in advance,
Buddy
(e-mail address removed)
a value from two combo boxes and a list box; a separate text box on
the same form then displays a serial number based on the selected
values, date(), and an autonumber through use of its control source.
There is a print button that sends this unique serial number to a
report and prints it out onto 4 small labels to be placed on the
finished goods.
Here's my question: The users need to be able to enter the quantity
of serial numbers they wish to generate. For example, if 100 units of
the same product are coming down the line, they need to be able say
they want to generate 100 of these unique serial numbers (with all
information in said form being stored in tblSerialNumber) and print
out all these labels at the same time, all at the touch of a button.
It will print four copies of each unique serial number because the
report it prints each serial number to is set to do so. Likewise, if
they know that 87 units are coming down the line, they need to be able
to choose 87 units.
Furthermore, touch screens are being used - is there a way to pull up
a small number pad on the screen so they can enter the quantity?
I'd really appreciate any help. Thanks in advance,
Buddy
(e-mail address removed)