Web Development
I want a report to prompt me to specify a record to print.
How do i create a report to print a specific record from a table?
by sgt_shultz
make a parameter query that prompts for the record number or whatever you are wanting to use to get the specific record. then make your report based on that query...
do you know how to make queries? look in help for how to make a parameter query. it is very easy. write us back for more help...
by sgt_shultz
How to make a parameter query:
(below is pasted from Access 2000 help:
-------------------------------------------------
Create a select or crosstab query.
In query Design view, drag the fields from the field list to the query design grid.
In the Criteria cell for each field you want to use as a parameter, type a prompt enclosed in square brackets. Microsoft Access will display this prompt when the query is run. The text of the prompt must be different from the field name, although it can include the field name.par
For a field that displays dates, you can display the prompts "Type the beginning date:" and "Type the ending date:" to specify a range of values. In the field's Criteria cell, type Between [Type the beginning date:] And [Type the ending date:]
To view the results, click the View button on the toolbar, and then type a value for the parameter. To return to query Design view, click the View button on the toolbar again
by john_wills
Start the report from a form, in which the record is specified by the user in a text box. The strating should be via a button to click. The click event code should include
DoCmd.OpenReport "ReportName",,"ClientID=" & me.ClientID
This discussion is closed to new replies.
Sort by Trending