Question how can i print a number of boxes based on a value

[nijopo]

i wish to produce a delivery note which needs to print an empty box for manually ticking.
i need a box for each item quantity i.e 5 items on the job print 5 boxes. 20 items print 20 boxes.
i have been able to use very crude code if there is only a few items, using if qty =1 then / 1/ else if qty = 2 then / 1/ / 2 / etc etc that works and prints the / 1 / 2 / which is ok but there must be a simpler way as it the job has more that
it would be much better and far more useful for other reports to print a box or item.

many thanks

 

[jdraw]

How is the "Number of Items/Boxes" determined?

You could possibly have a small loop

eg.

X= "How many boxes are required?"

Some check that X is a reasonable number.
For i = 1 to X
Print a label/box identifier
Next i

 

[nijopo]

thanks for reply
the number of boxes will be supplied by a number in a field in the orders table
eg. Qtyframes this could be up to about 80 per order line

but there could be 4 or more lines of product type - so from 0 - 80 on each line

windows
doors
curtainwall
ancillaries

 

[jdraw]

Show us some sample data that matches your database.

Please describe your situation in some detail - what exactly is a "Box"?
All items go in separate boxes? All boxes are the same size?

Your question is very vague.

 

[nijopo]

yeah sorry it is a bit vague - - makes perfect sense to me

ill post some details later or tomoz if ok - not in office at the moment.

many thanks.

p.s - boxes will be same size approx 8mm square (big enough for a manual tick)
basically it is getting access to print 1 x box for each item on the order, so when delivered the driver ticks a box to confirm each item /quantity.

cheers

 

[jdraw]

So it isn't packaging boxes, it's really check boxes on a form.

I googled dynamic check boxes on a form and this is the recommended approach

[COLOR="Blue"]There is a limit to the number of controls that can be created for a report
or form..... if you programmatically create controls, you'll eventually
reach that limit.

Instead, put on the form or report all the controls that you think you'll
need/want, and make them invisible. Then have your code make them visible if
you want to use those controls for a particular session. You can
programmatically set the caption of the label that is attached to the
controls too so you then can insert the names of fields that you want to
show.

--
Ken Snell
<MS ACCESS MVP>[/COLOR]

 

[nijopo]

thanks for that - i get what they are saying, but its a little beyond my capabilities at the moment. i'm learning as i create...

i used to use access 95 !! loads, but have only recently started using access 07

 

[jdraw]

Try google MS Access dynamic check box