Printing invoices.

[abcman]

Hi all,

I created an invoicing system on Access and when I need to print I will need to key-in the invoice number. How can I print multiple invoice numbers like do I put a comma in between or what ?. Thanks.

 

[Poppa Smurf]

On your form have two text boxes one called StartNumber and the other EndNumber. When you enter the StartNumber, use the After Update evnt to set the EndNumber to the same value as the StartNumber. If multiple invoices are required then just change the EndNumber.

To print the invoices, the Invoice Number criteria will be between StartNumber and EndNumber.

 

[PNGBill]

I would set up my Form to allow for an individual Invoice (Report) to be printed or a selection of reports.

As very few times do we ever Key in a Number in our database, (all done by click on a form) I would Print an invoice from a form displaying a Customer, A Sale, or A Days Sales etc and the Invoice Report would then be filtered by the vba code behind the Command Button that is clicked in each situation.

Essentially the Invoice Report, if left to it's own devices (never is) would print all the invoices ever raised.

We never "print" always "Preview" first but this is just a choice of syntax in the vba code.

 

[Pyro]

Check out this link.