Printing selected records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a previous question I asked how to give the user the ability to select the records he would like to print out of the entire database. Tyler responded with the following:

<You can push all of that data to a form and let the user place a check in a <checkbox to print that record. Of course, more than 1 record can be chosen and <printed. I'd be a good idea to add a yes/no field to your table called "Print". <When the user clicks the print button on the form (oh, you'll need to have a print <button on the form. haha), a query will look at the table and choose only those <records marked for printing, as marked by the user. In other words, the query <will take all records whose "Print" value equals true. After the report has printed, <an update query would then deselect those records.

I have been able to create the form listing the necessary fields for each record (each within it's own box). I've added a check box with yes/no. I've added a print button to the form. Now - does anyone how I should write the code for the printing of the checked items and how to do the update to deselect the records.

As if you can't tell - I'm quite new to Access and don't quite get all of the VBA language.

Any help will be appreciated.
 
Design by Sue said:
In a previous question I asked how to give the user the ability to select
Click to expand...
the records he would like to print out of the entire database. Tyler
responded with the following:
<You can push all of that data to a form and let the user place a check in
Click to expand...
a <checkbox to print that record. Of course, more than 1 record can be
chosen and <printed. I'd be a good idea to add a yes/no field to your table
called "Print". <When the user clicks the print button on the form (oh,
you'll need to have a print <button on the form. haha), a query will look
at the table and choose only those <records marked for printing, as marked
by the user. In other words, the query <will take all records whose "Print"
value equals true. After the report has printed, <an update query would
then deselect those records.
I have been able to create the form listing the necessary fields for each
Click to expand...
record (each within it's own box). I've added a check box with yes/no.
I've added a print button to the form. Now - does anyone how I should write
the code for the printing of the checked items and how to do the update to
deselect the records.

Base the report on a query with the check box criteria set to True.
In a separate button run an update query that sets the value to False.

That way you can reprint the report if something got messed up.
 
Back
Top