One Report, several different uses

[mousemat]

Hi all

Been taking a break from Access recently ,but been dragged back into it.

My application is a bespoke quotation/invoicing/customer address type affair. The main structure is up and running.

I want to be able to create one report only for both Invoices and Quotations. This is all driven through a form based on the customer table but with several list boxes added on to.

From the main form, tbl_Customers1, a button is pressed to open a new form (quote entry or invoice entry) and the data from the first form is populated into the second form.

The second form is the form that creates the report. All this works well.

What I want to do now is from the main for, through the list box is to be able to double click the list box entry and display the report again. I can do this by creating a second copy of the report and naming it something different, but I dont want to have lots of the same report.

I'm guessing that the report needs to be driven via the vba coding and onopen properites but I cant seem to get my head round it.

I have added the database to this thread.

Any help would be great

 

[jzwp22]

Looking at your quotation and invoice tables, the list of fields is essentially the same, so why not include both quotes and invoices in 1 table. You can add a field to distinguish the "document" as either a quote or as an invoice. This will then make it easier to use just 1 report.

I made a few other changes to your structure (see the tables and the relationship diagram in the attached).
1. You repeated the company name in the invoice/quote table. You should not do this, you only need the key field. You can get the company name as needed via the join of the key fields
2. Use the VAT_ID field in the quote/invoice table not the actual value (you can get the actual value when needed via the join of the key fields)
3. You used the word date as a field name. The word date is a reserved word in Access so it should not be used as a table or field name. (here is a list of reserved words)

 

[mousemat]

Hi JZW

Thanks for that.

I will download it and have a look at it and see where it takes me.

The reserved word of Date I was aware of but as usual it had slipped my mind.

The idea of putting invoices and quotes in the same table hadn't really occurred to me simply because the invoice number and quote numbers are different sets of numbers. It seems to be a better idea all being in one table. I can work round the number system to please.

Ian

 

[jun-ior]

Report Running Sum

Hi Everyone!
I'm trying to do a running sum like a bank account on descendant but couldn't figure out. Need help, please!
Thanks
Jr.

 

[jzwp22]

Jr.,

You may want to post your question in a new thread since your topic is different from the initial post of this thread. You will need to include information about where you a trying to accomplish this running sum--in a query, a form or a report.