Carbonless 3 part order form. How OMG how?

[grtfercho]

I have a small database with a few tables. I want to print Carbonless Order forms 3-part (white/canary/pink).
What I need to print in all is the distributor code, an autonumeric value to represent the Order Number and a few particulars for each part ( on the white for example print 'Customer copy' but on the yellow print 'vendor copy')

So basically if I want to print 5 sets I should have 15 sheets in groups of three.
** All sheets will have the Distributor Code
** Each sheet within a group will have the same autonumeric number ( this means I'll have three with number 1, three with number 2, and so on.)
** Each color will have some minor changes applied.

Since the paper already comes ordered in sets of colors I cannot print once for the white, once for the canary, once for the pink and then try to re-arrenge the individual sheets to create the sets.

I have been battling for a few hours and I cannot find a descent , simple solution.
ANy help would be enormously appreciated, seriously..

Thanks.

grtfercho çB^]\..
"Imagination is more important than Knowledge"A. Einstein

 

[DougP]

Easiest way, you need 3 reports
copy one and rename it 2 more times name one
'rpt-Customer Invoice'
'rpt-Vendor Invoice’
'rpt-Our Invoice’
Then edit each one to have only what you want on it
Then call all three reports in a row
Docmd.openreport “rpt-Our Invoice”…
Docmd.openreport “rpt-Customer Invoice”…
Docmd.openreport “rpt-Vendor Invoice”…

They will all spit out lickity-split

I have done this lots of times
After a while you will see you don't need 3 colors anymore since they have headers telling you what they are.
Saves lots of money
You can even set the “Specific Printer” for each report to go to 3 different places.
This really saves time and money.
Also you can make one “Specific Printer” to a network FAX and it will pop up asking the FAX number as all three are printing.


DougP, MCP, A+

 

[grtfercho]

Probably I should have mentioned that the forms will be all clean and the Order number is only for tracking things. I need to print all in the same printer, set after set because after they are done they'll go out and people will fill the information manually.
I'm basically making my own orders pad. So people can check off/write things on carbonless paper.


grtfercho çB^]\..
"Imagination is more important than Knowledge"A. Einstein

 

[dhookom]

Create a table of copies
tblCopies
CopyNum CopyTitle CopyOtherText
1 Store
2 Customer
3 Vendor
You can then add this table to your report's record source and add the fields to the query grid. Set the first level of sorting and grouping to CopyNum and add fields as required to the report.

This will create three copies of each page/invoice.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[grtfercho]

That seems a good start. But how would I deal with the autonumbering?

I think that everything will come down to a small form where the user will be able to select the vendor name from a drop down, then the starting number for the orders (lets say 1200) and the final one (1250) this would generate 150 sheets (50 sets of 3) .
I guess that having a loop of somekind and inside a call to the report with every new value in the loop would do it.

Thanks guys.



grtfercho çB^]\..
"Imagination is more important than Knowledge"A. Einstein

 

[dhookom]

I would run some code prior to the printing that would place the order numbers in a table. Updating values shouldn't be done in a report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.