I am stuck at a step

gregoryharvey

Registered User.
Local time
Today, 02:13
Joined
Jul 14, 2006
Messages
24
I have a form that i use to make labels.

I want the user to be able to specify in the form the numbers of labels to print.

After reading access for dummies and other manuals, google and calling my local IT guys, I've exhausted all examples I was given.

CAN/ WILL ANYONE HELP ME?
 
I'm no expert (in fact virtual newbie would be closer the mark!) but I can take a stab at explaining what I think would be the theory behind solving your problem.

I've got a DB that prints after saving a record and I achieved this using a straight forward print macro triggered as the last step in the VB code that saves the record entered.

In your case though for multiple prints I'd advise planning out a VB funtion triggered from a 'print' button on your form. The function would need to take in the value of the Copies field as a variable and also contain another variable as a Count.

The Count variable should begin as 0. The funtion would then need to loop, and add +1 to the counter variable after each print.

The function also needs a step just inside the beginning of the process to compare the Copies Variable to the Count Variable and when they equalise... to goto end function.

Even though I've used a macro for my prints (I only ever need a single copy) I'd be incredibly surprised if you couldn't find a keyword in VB to output a print from the code of a function.

I apologise for not having written out a funtion itself for you, but as I warned I am a newbie to MS Access, but I hope at least this is some help in guiding you to a solution.
 

Users who are viewing this thread

Back
Top Bottom