Need a button to view a specific report so I can print it.

[Marq]

Access 2007

I want to create a button to view a specific report. The report, of course, is the information from one record in a table. The button I have created opens up the report but it shows every record..for example I have 22 records thus far, so when I click on my "view Report" button I get 22 pages to view. I just want one, specific, report to show up.

Which brings me to my second issue..I want to have a button that when clicked a window pops up asking what report I want to view, I type in the report number, then I can click print to print that specific report.

Would I have make a query with a "Like" command in order to do any of the above?

 

[Trevor G]

If your report is created from a query, then what you do is go into the query and from the field you want to set as the record, go into the criteria and place in something like this:

[Enter the record number to print]

This will then display a parameter box and you would type in the number of the record

If you want the option to show all then thats when you would use the like

like[Enter the record number to print]&"*"

Then save and close the query then test your button

 

[alansidman]

On occaison I have a user that wants to print in a report what is in a particular record that is displayed in a form on the screen. I use a command button and assign the following code to that button. It is important to note that you must have a unique identifer for the record.

Private Sub RecordReport_Click()
On Error GoTo RecordReport_Click_Err
    Dim stDocName As String
    stDocName = "ReportName"
   DoCmd.OpenReport stDocName, acViewReport, , "[ID] = Forms![FormName]!ID"
RecordReport_Click_Exit:
    Exit Sub
RecordReport_Click_Err:
    MsgBox Error$
    Resume RecordReport_Click_Exit
End Sub

Make sure you use your own form names and field name. Additionally, my report is generated from a query using the fields from the table bound to the form.

HTH
Alan

 

[Marq]

If your report is created from a query, then what you do is go into the query and from the field you want to set as the record, go into the criteria and place in something like this:

[Enter the record number to print]

This will then display a parameter box and you would type in the number of the record

If you want the option to show all then thats when you would use the like

like[Enter the record number to print]&"*"

Then save and close the query then test your button

works!..thanks