Print a single invoice from a form
- Thread starter Avick
- Start date
Travis
Registered User.
- Local time
- Today, 07:02
- Joined
- Dec 17, 1999
- Messages
- 1,332
Have you tried using the Parent/Child properties on the SubReport to limit it to only the Parent Infomation.
If the Sub report is printing fine for the Parent Report have you sent a Where clause with you commad to open the report:
docmd.OpenReport "ReportName",acViewPreview ,,"[Something]= [LimitData]"
If the Sub report is printing fine for the Parent Report have you sent a Where clause with you commad to open the report:
docmd.OpenReport "ReportName",acViewPreview ,,"[Something]= [LimitData]"
I have a field called "Order ID" in the main report and i have "Order ID" in the sub report. I have tried linking the information using this in the Perent/child fields and still no luck.
I did manage to get the page to show only the
Information for each record but can't get the dam thing out on paper.
The problem comes when i try to click a button on the form where i write the invoice. It won't print that record only. I get every invoice i ever recorded.
The Querys that the report and form are based on are called:
order details & order details extended
I have set-up a one to meany relation and that works fine.
I did manage to get the page to show only the
Information for each record but can't get the dam thing out on paper.
The problem comes when i try to click a button on the form where i write the invoice. It won't print that record only. I get every invoice i ever recorded.
The Querys that the report and form are based on are called:
order details & order details extended
I have set-up a one to meany relation and that works fine.
I have managed to get it to work Thanks to you.
I done as you said Travis and when i clicked the button it asked me for Invoice number. when i typed it in it opened the invoice as a single record.
I then changed the text to the following.
DoCmd.OpenReport "print invoice", acViewPreview, , "[Order ID]=Forms![Invoice]![Order ID]"
After inserting this i no longer needed to use the pop up box. This text opened the report directly.
Thanks again
I done as you said Travis and when i clicked the button it asked me for Invoice number. when i typed it in it opened the invoice as a single record.
I then changed the text to the following.
DoCmd.OpenReport "print invoice", acViewPreview, , "[Order ID]=Forms![Invoice]![Order ID]"
After inserting this i no longer needed to use the pop up box. This text opened the report directly.
Thanks again
Why is it so bloody hard to print a single invoice.
I have just discovered that if i put one item in the invoice i get a one page invoice. If i put 2/3 or more i get lots of pages. if i have 2 items i get two items, even though i only have one invoice.
Is it realy that hard to solve this problem.
It seems that Access 2000 can tell you what strand of hair was pulled from your grannys head in 1850 but it can't put that information on a single page.
I have just discovered that if i put one item in the invoice i get a one page invoice. If i put 2/3 or more i get lots of pages. if i have 2 items i get two items, even though i only have one invoice.
Is it realy that hard to solve this problem.
It seems that Access 2000 can tell you what strand of hair was pulled from your grannys head in 1850 but it can't put that information on a single page.
Your problem here is in the layout for the actual report. The detail section of your report should contain only the field names. This section should allow for the width of one line only. On your sorting and grouping properties for the report, set a sorting by Order ID with a group header and group footer, grouping on each value. This should solve your problem and allow for single or multiple lines of order within the same report.
