printing forms in access 1

[p3ngu1n1337]

Hi all,
First of all........AHHHHHHHHHHHHHHHHHH!
I have been working on this issue for days now and can't seem to get the result I am trying for.
I have a three part preprinted form I need to print on.
The three parts are all identical (it's an invoice).
I have created the form in access to print data only and that works great. The data is all lined up and prints in the boxes perfectly. I use another form, the main one, to enter all of the paticulars for all clients. On the main form I created a button that will print the invoice form with the data I need from the main form. This workss great except for one thing.....it prints the same data in all three invoices on the page. What I want to be able to do is find a way to print three different invoice on the the invoice form since each pre printed form contains 3 identical invoices.
I hope this makes sense.
I guess and option would be if there is some way to print all recently created invoice at once after all the info has been entered. Again the trick is to be able to have 3 different sets of identical info on one form.
Please help if you can.
Thanx in advance

 

[bhoran]

You could try building a report to print the dat rather than printing the form, that may give you more flexibility with layout.

Then I guess you could use the same source for 1 report with 2 subreports or you just be able to repeat the detail over again, I have not tried this.

When the user hits the button you could just send the report to the printer or you could allow the user to preview it.

 

[p3ngu1n1337]

That is not a bad idea.
The only problem is I will, I think, Be in the same situation as with a form.

The one factor of the three invoices that will Always be unique is the invoice number. Is there any way I can make a rule that only one appearence of any one invoice will appear one the form??

Or is there a btn I could create in the switchboard that would allow me to print the form based on basis of only the unprinted invoices to date are printed??

Have you hugged your Penguin today???

 

[bhoran]

You can produce your report to group by invoice number and to page break after each invoice number thereby only ever printing 1 invoice per page.

You could also add a formula or criteria to your form and query to choose which invoices should be printed.

 

[p3ngu1n1337]

That sounds like an awsome idea.
How would I create the page break in the form I was loking for it and could not find it.
I had thought of using a page break in a different way but could not find the way to utilize it.


Thanxs so Much!

Have you hugged your Penguin today???

 

[ptpaton]

p3...

1. Insert a group header for InvoiceNumber
2. In the "ForceNewPage" condition, select "AfterSection"

This will break the report after every instance of a new invoice number.

Good luck!

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[ptpaton]

OOps..sorry...should have previewed my post first.

P3...insert a group FOOTER and change the ForceNewPage to "After Section"

Changing that on the group header will insert a page break before your new invoice number.

Sorry!

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[bhoran]

the grouping sorting pop-up window can be found under the View menu list. View / Groupng & Sorting - this is where you select the field to be grouped (invoice number) and say YES to group header.

I don't think you need to add a the pagebreak after the footer (or even need to add a footer) but you certainly can do that if you want to.

You change the page break properies by clicking on the header row in the report design view and right clicking your mouse to get the properties pop-up window then you will the Force New Page prperty under Format. Have a play with it until you are happy with the breaking.

 

[p3ngu1n1337]

Awsome, I imagine this will work great!!
You guys have all been a great help
I hope I can you out sometime
Take care thanx


Have you hugged your Penguin today???

 

[p3ngu1n1337]

Thanx again for the help.

New issue,
The grouping works and I will be able to set up the form and to print data only.

I cannot, however, find a way to keep three different records on the same page. I add the group footer and select page break after section, but it puts the next series of daa on a new page. How can I keep it on the same page for three records??

Have you hugged your Penguin today???

 

[bhoran]

Sorry I don't fully understand your issue.

If you put a page break after section on InvoiceNo it will page break whenever the InvoiceNo field changes value.

I thought you had indicated earlier that you have only 1 InvoiceNo per page?

I also thought you wanted the same data printed 3 times on one page?

I would suggest unless someone has a better idea that you setup your report with the InvoiceNo in it header, then add your detail for the 1st section in the details area, under that (still in the detail area) I would create a subreport over the same query that the data as your main report, and then repeat that so you have the 3 sectiosn al sitting in trhe Detail header of the report. You may have to link the subreports to the main report via InvoiceNo.

Then when then when the InvoiceNo changes on the Main report it will break to a new page but each page consists of 3 reports 1 main and 2 Subs.

 

[p3ngu1n1337]

I got it!!!
I tried the subforms, but it got a little messy.
Once I put the page break in and set the size of the form properly it worked out great!
Thank you for your help in this matter. I am sure you saved my the new addition of a few gray hairs.

Have you hugged your Penguin today???

 

[bhoran]

Your welcome, I am glad you got it sorted out.

thanks for the star.