How to I print a particular invoice

[fleurette]

Hi
I have used a report wizard to create invoice format.

Currently, when I run the report, it will generate all the other invoices continously (a bit like a continuous long roll of of toilet paper). However, I only need to print a particular invoice at a time.

1. How do I only print a particular invoice number, without having all the rest to be generated?

2. Is there a way to format the report settings into the print button on the form to print this particular invoice, where the form is showing the record?

thanks!

 

[bulldogs]

Not sure if this is best practice (or if it relates to your situation) as I am learning some hard lessons from this site (which is a good thing) I did give the desired result.
I created a query based on the currently loaded form using criteria Firstname and lastnames(built from expressions) then I create a report based on that query - when the customers details and order are displayed on the form,
I created the report button to view the report and a separate print button to print the report to PDF then I can send the invoice to the customer.

See the test report I added and its output
There are some personal business details I have omitted

 

[fleurette]

Here is one way.

Thanks
I tried the code in the link you provided but can't get it to work.

Is the lingo "Me.Dirty" in the code standard language to use

 

[fleurette]

Not sure if this is best practice (or if it relates to your situation) as I am learning some hard lessons from this site (which is a good thing) I did give the desired result.
I created a query based on the currently loaded form using criteria Firstname and lastnames(built from expressions) then I create a report based on that query - when the customers details and order are displayed on the form,
I created the report button to view the report and a separate print button to print the report to PDF then I can send the invoice to the customer.

See the test report I added and its output
There are some personal business details I have omitted

Hi bulldogs
thank you!
It has been a painstakingly slow process trying to create something on access.

Your invoice looks nice!!!!
I think part of the complication is that I have order number and then I have a few instalment invoices relating to each particular order.

So I have have a main form showing order details and subform showing the detailed instalment amounts and invoice number for the various amounts when they are due.

If I have only 1 invoice per order, I think it might be straightforward.
But given the instalment amounts in the subform in datasheet format, the print function does a print screen.

I don't really know how to get the form to select the specific invoice number for print. :banghead:

 

[fleurette]

Normally you would have a main form showing "orders" and a subform showing "order details" with a single invoice# generated from the main forms before insert properties or something similar. Can you upload an example DB?

Hi AccessBlaster

thanks
here's a sample framework.
Thanks

 

[fleurette]

Hi,
You have some fundamental issues with your table designs. Below are examples of poor Field names.
You also have repeating data within the same tables. I would recommend (Google) reading up on “Database Table Normalization” After you have a good grasp on table design, start with pencil and paper one table at a time. Then move on to forms and queries…reports. Without a good foundation you will have nagging problems for the life of this project.

Bad field names
Brokerage %
NetPayment($)
Will be received soon?
Suburb/State/Postal Code
c/o

Richard

Oh dear!
I will do that, but does that mean that I have to scrap the work that I have done so far? Or am I able to tweek it from there?

Thanks Richard.