I think I need a VBA code

[gregoryharvey]

i've tried the web, manuals, books for dummies can anyone help?
I know reports are for printing records, but I've built a program that's a form. Its used to print labels for different patient medications and one user may need 1 label while other user quanities will vary constantly
everything works fine except when a user clicks a print button i created using a command they either:
1. get all of the records
2. get only one thats selected
3. get whatever number i specify in building the program
or
I create a macro using the printout function and in the action arguments i have to select a number there.thats a lot to ask a user to do for every time they want to print

What I want is for the user to specify how many labels they need to print before or after they hit the print button.

please help

 

[MrTibbs]

Access db for patient records?

What decides how many labels are required? The size of medicine bottle used? Number of pills? It may be more useful to specify the package size and allow the system to record: For Mr Blogs 200 of X in 4 off 'small' bottles. This may improve traceability and would enable the system to also track container useage hence easing re-ordering. alternatively: Why is it so difficult for staff to enter the number of labels they require? Once you can calculate the number of labels required you can then create a temporary table or query with the right details on and just print the whole temporary table (allowing print of bottle 3 of 4 for example). [remember to include a label re-print function to avoid over-counting bottles] btw: What is an Access database doing anywhere near patient / medication records? btw2: why did you create a form if you believe a report is the right way forward? Is this database meant to print labels for more than 1 patient at a time? I suggest that would be a BAD THING because it would make mixing up labels much too easy.