Invoicing in Microsoft Access

Invoicing
By Richard Rost

17 months ago

Print Preview of Invoice Report Upload Images Link
Despina Karayanni
5 months ago

Hello,
It would we very helpful to open the invoice report in preview mode, without opening the order form. Is that possible?
Thank you very much.

Scott Axton
5 months ago

Yes it certainly is possible.
I'm going to challenge you to walk through and figure this out because you have so many of the courses. I can give you the easy answer and just do it or I can teach you how to figure it out.

Here are some hints:
Look at the print button on the order page.  in design mode, events of the button, how are you doing the print preview from there?
How does the report know which invoice to print?
How can you tell the invoice report to which invoice it is you want to print?

Now back up one step to the form you got to the order from.  How did you get to the order you wanted to view / print?

Given the answers to those questions, how can you apply that process to printing the order with out opening it.

Give it a go!  Come back and ask questions if you get stuck. I'm not trying to be cryptic just trying to help your growth in learning.

Richard Rost
5 months ago

Possible? Sure. You'll have to provide the OrderID for it some other way then... the way that it's built now.

Despina Karayanni
5 months ago

Thank you very much for your answers. The problem was that I wanted to preview the invoice through a searchlist witch was controlled by a path through query, so I actually changed the where condition in the paththrough query (the orderid had to be controlled by the searchlist - not the path through query) in order to be able to see the data in the invoice preview. Thank you very much again.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Invoicing Comments