Report issues

[HoustonOil]

I have created a report for orders and order details that works just fine when only one order is entered in the system. When I enter a second order that order is printed on page two of the report, but I need it to be in it's own report. I am using this report as an invoice, so I need each order printed/displayed on its own page.

Any ideas, direction?

 

[lightray]

Hi, You say that you want each order on it's own page, and that the second order is on page two? sounds like this is what you want. Is it the report header that is not printing on all pages? confused!

 

[HoustonOil]

Good question, sorry for not being more clear.

Yes, the report header is not printing on the second page. But, if I have the report header print on the second page, page 2 will save pg 2 of 2 at the bottom when I only want it to say page 1 of 1.

I need to be able to print reports for seperate quotes. Right now while I am playing with trying to figure it all out the quotes are only one page. But in the future when this database is actually being used, a single quote could easily exceed 50 pages or so.

Hi, You say that you want each order on it's own page, and that the second order is on page two? sounds like this is what you want. Is it the report header that is not printing on all pages? confused!

 

[lightray]

Sounds to me like you need a form that allows you to select from a combo list of quote numbers, which then runs the report with a parameter value.

 

[boblarson]

Just an FYI -

The Report HEADER will ONLY print on page 1. It is a header that heads up the entire report. If you want something on page one of a certain grouping, you need to put it on the GROUP HEADER. You can set Force New Page after the grouping level that you have set as the top level grouping to get the next group to print. Or, you can use the page break object (which is in the toolbox down somewhere near the Picture box object on the toolbox) and put it in the GROUP FOOTER.

 

[HoustonOil]

I understand what you mean, but that is not what I need to do. I am trying to create a quotation for orders. Maybe I am creating the report wrong. The report is creating a report for each quotation in the system at once, instead of each quotation at a time. Do you, or a does anyone else, know how I would go about doing this?

 

[HoustonOil]

I created a form that allows me to select the quote number from the combo list. How do I run a report off that form? I tried to create a report again, but failed to tie the report to the form.

Sounds to me like you need a form that allows you to select from a combo list of quote numbers, which then runs the report with a parameter value.

 

[lightray]

You will need a command button. In the Onclick event you will need to use the DoCmd procedure to run the report. Something like: DoCmd.OpenReport YourReportName, acPreview, , "QuoteNoName = " & cboQuoteNoName

 

[HoustonOil]

Ok, I am trying and cannot get it. Do I enter the code under "report" or under "details". I don't understand, maybe I am in over my head? . . . .

 

[Wiz47]

Ok, I am trying and cannot get it. Do I enter the code under "report" or under "details". I don't understand, maybe I am in over my head? . . . .

Private Sub CmdPrintPass_Click()

Dim strDocName As String
Dim strLinkCriteria As String
DoCmd.RunCommand acCmdSaveRecord
strDocName = "rpt_Print_Pass"

  strLinkCriteria = "tblPass.ID = Forms![frmPass]![verification_Code]"
    DoCmd.OpenReport strDocName, acViewPreview, , strLinkCriteria
End Sub

This may or not help. But I had to tackle this problem over the weekend. I wanted to show only One record at a time in my report so that I could print individual passes. The above code allows me to print only the current record. It is based on the Primary Key tblPass.ID and reads the current record [Verification_Code] Your PK and Current Record code will be different - so change them appropriately.