Print selected records in a form created by a query

[Costa]

Hello all ..



I have a form that created by selected records via query .. I want to select some records and print them without printing the other records that are in the same form..

Here is the steps I want to do :

- A query checks for today's appointments
- The results shown up in a form with checkbox near each record
- I select some results (Records) to print them. ( I Want to use checkbox)
- Then refresh the form to uncheck all the checked records.

Is there any code to do this ?

Waiting for your support

Kind regards

[MAF4Fam6]

Recommend creating an Access Report and SECOND Select Query.

1. Create second Query (use the same fields as your Form's query) and type the following Criteria in your Checkbox field's column:

True

2. Create Report for printing versus a Form. Use the second Query as the Record Source for the Report.

3. Create a Command Button on your Form to Print Report

4. Use VBA or Macro to perform the following actions from the Command Button's OnClick Event:

a) Save Current Record

b) Set Warnings to No

c) Use the OpenReport command to Print Report

d) Have a MsgBox ask "Do you want to uncheck ALL Tagged Records?"
- If Yes, 1) Run SQL statement or Update Query to update Checkbox fields to False, 2) Use the Requery command to refresh screen
- If No, do nothing

The last step is entirely up to you, as to how/when you want to uncheck the Checkboxes.

-RC

[Costa]

Hi

thanks for the help ..

Everything is working good .. but I need your help in unchecking the checkboxes

Can you give me the code for this

(( Have a MsgBox ask "Do you want to uncheck ALL Tagged Records?"
- If Yes, 1) Run SQL statement or Update Query to update Checkbox fields to False, 2) Use the Requery command to refresh screen
- If No, do nothing)

thanks again

[MAF4Fam6]

The attached Access database (inside zip file), contains one object (1 Macro).

1. Right-Click and Export the Macro to YOUR database.
2. Open your database, Right-Click the Macro and Open in Design View.
3. Update the Action Arguments (Object Name) of the OutputTo Macro Action.
4. Right Click the SQL Statement (in the Action Arguments of the RunSQL Macro Action) and Click Zoom:

UPDATE MyTableName SET MyTableName.MyCheckboxFieldName = False
WHERE (((MyTableName.MyCheckboxFieldName)=True));

a) Change MyTableName (3 instances) to match the name of your Table
b) Change MyCheckboxFieldName (2 instances) to match the name of your Checkbox's field name

5. Add the Macro to your Command Button's OnClick Event.

-RC

[Costa]

Hello ..

I got all the steps .. but I didn't understand this step :
3. Update the Action Arguments (Object Name) of the OutputTo Macro Action.

Can you explain it please ?

Thanks

[Costa]

My table name is : Main Table
Check box is : PrinReport
Form Name is : DailyApp

The checkbox values are : 0 or -1 (I'm not using True or False)

Can you tell me what to edit in the macro ??

Thanks again

[MAF4Fam6]

Costa,
My mistake...
Please change the OutputTo Macro Action to an OpenReport Macro Action per the following screenshot:

Attachment 711

Thanks.

-RC

[MAF4Fam6]

Just following up.
Please let us know if your issue was resolved.
Thank you.

-RC