Print Selected Records

  • Thread starter Thread starter TheCaptain
  • Start date Start date
T

TheCaptain

Hello,

I am using a form that shows the results of a query. I would like to print
only selected records using a check box. So, for example: If I run my query
and get 10 results I can check the box yes for 4 records and then hit print
(or a print button) and only print the four. Any ideas?

Thanks
 
It works thanks.

Steve said:
Add a field called "Selected" (Yes/No data type) to your table. Add nthat
field to your query and form. You can now check the records you want to
print. Create a new query to be the recordsource of your report. Base the
new query on your existing query. In the new query, set the criteria for the
Selected field to True. After you print, be sure to update the Selected
field to False.

Steve
 
Hi

The less "stuff" you have in a DB the better it is IMO. You don't really
need another query - you just need to filter the report OnPrint

Follow Steve's good advice and create a yes no field in the table. Add this
to your form (so you can click it or not) to select which record you want
included in the report.
Add it to the report details as well (set to Visible = No)

On your form add a button and have this as the OnClick event

Private Sub ButtonName_Click()
DoCmd.OpenReport "ReportName", acViewPreview, "", "[YesNoField]=-1", acNormal
End Sub

Change ButtonName, ReportName,YesNoField to the names you have used in your
application

Hope this helps
 
That's better. Thanks

Wayne-I-M said:
Hi

The less "stuff" you have in a DB the better it is IMO. You don't really
need another query - you just need to filter the report OnPrint

Follow Steve's good advice and create a yes no field in the table. Add this
to your form (so you can click it or not) to select which record you want
included in the report.
Add it to the report details as well (set to Visible = No)

On your form add a button and have this as the OnClick event

Private Sub ButtonName_Click()
DoCmd.OpenReport "ReportName", acViewPreview, "", "[YesNoField]=-1", acNormal
End Sub

Change ButtonName, ReportName,YesNoField to the names you have used in your
application

Hope this helps


--
Wayne
Manchester, England.



TheCaptain said:
It works thanks.
 
Back
Top