print multiple reports based on number typed into form text box

  • Thread starter Thread starter buddycheck240
  • Start date Start date
B

buddycheck240

This should be an easy one, I just don't know how to do it.

I have a short form that users fill out to help them print a label for
certain parts that we make (the label is created using a custom report
in Access). I want the users to be able to type the number of labels
they need printed into a text box on the form, and then when the PRINT
button is pressed, the requested number of identical copies of that
report (or label in my case) will be printed.

Any and all help is greatly appreciated!! Thank you!!
 
Create a table of numbers (tblNums) with a numeric field (Num) and values 1
through your maximum number of labels needed. Add this table to your
report's record source and don't join it to any other table.

Add the Num field to your query grid and set the criteria under it to
<=Forms![the form]![name of text box on the form]
 
Thanks so much - that was the quickest response I've ever gotten and it
definitely worked. My headache has temporarily gone away!
-Bud
 
I wonder if you could follow on to this answer?

I am new to the forum but will explain as best I can.

I am using a form, again to select the number of print copies as pe
your answer.

The problem is; the labels are not for parts, but for containers of ra
materials, sometimes each container may contain all the same weights
sometimes the weights may vary.

For Example, I may print off 3 labels, all with a container weight o
1000Kg (3000KG Batch), but then again I may want to print off 3 label
with a container weight of 1500Kg, 1000Kg, and 500Kg (3000KG batch). I
there a way of the txtcontrol/combobox on the form that selects th
number of prints, to unhide the same number of text fields on the form
which can be filled in with the corresponding container weights, an
then print the contents of the text fields in each different copy o
the report.

Any questions, please shoot & I will try to clarify!

R.Joh


-
R Joh
 
I would think that you need to store the container weights individually in a
related table.
 
Yes, that works fine for Raw Materials that we get in with the sam
container weights. But some, which come in with different weights, u
to 10 containers with different weights.

I was thinking of having some sort of control that would unhide a se
number of text fields (when you select the total amount of containers
then maybe having the text fields write to tblcount in a weights field
Then using that weight stored with the update query to write to th
report.

not quite sure how to code it though!!

Rod.

Duane said:
I would think that you need to store the container weight
individually in a
related table.
Click to expand...



-
R Joh
 
I'm not sure either since your specifications aren't clear.

Please start a new thread (rather than continuing in an old thread) with a
better explaination of what you have and what you need.

--
Duane Hookom
MS Access MVP
--

R John said:
Yes, that works fine for Raw Materials that we get in with the same
container weights. But some, which come in with different weights, up
to 10 containers with different weights.

I was thinking of having some sort of control that would unhide a set
number of text fields (when you select the total amount of containers)
then maybe having the text fields write to tblcount in a weights field.
Then using that weight stored with the update query to write to the
report.

not quite sure how to code it though!!

Rod.

Duane said:
I would think that you need to store the container weights
individually in a
related table.
Click to expand...
Click to expand...
 
Back
Top