Perform actions on selected records

[RAM SYS Matt]

I'm trying to have an access form perform certain actions to user selected records from it's record source (ie print). I was hoping to have a check box that the user can simply click denoting that they want print this record, then continue working and print all of the checked records when they are finished. I have tried several methods and I can not figure out how to accomplish this.

 

[boblarson]

Include a boolean field in your table and use that as the bound field for the checkbox. Then you can do the print by using a filter to open the report for just those records

DoCmd.OpenReport "ReportNameHere", acViewPreview, , "[YourBooleanFieldNameHere] = True"

And then after that just run an update query to reset them all back to false.

 

[RAM SYS Matt]

What if two or more users are currently using the same table? Wouldn't they end up conflicting with each other?

 

[boblarson]

What if two or more users are currently using the same table? Wouldn't they end up conflicting with each other?

Yes, you are correct. So, what I've done in the past is to have a local table which gets populated with enough record information for them to select the prints. It would have to be a different form than the add/edit form but then you could use a delete query first to clear it, then an append query to append the records with the IDs and other needed information and then have the checkbox there and then they can check it. Then the

DoCmd.OpenReport "ReportNameHere", acViewPreview, , "[YourIDField] IN (Select [ID] From localTableNameHere Where [booleanFieldName] = True)"

I believe that should work.