Multi Update

[NigelShaw]

Hi,

i have a query that pulls up all records from a table with a tickbox that is false. i have based a form around this too to see the records. once a month, i HAVE to make all boxes ticked regardless so not to include the records in the following month. the form is continuous but i am struggling to update all of the tick boxes together.

with code, how could i update all of the tickboxes together? the tickbox is called "PaymentsProcessedChk"

many thanks,


Nigel

 

[boblarson]

Just build and use an Update Query.

 

[NigelShaw]

Thanks Bob. sometimes the easiest things....... i was looking at code!

regs,

NS

 

[g28dman]

Just build and use an Update Query.

Hey Bob, I have an update query like this.

My query pulls up information that needs to be printed, I then choose which ones to print and when my update query runs it changes my yes/no field to yes it was printed.

My question is what if a user make a mistake after firing the code and decides that it shouldn't have been printed - is there a way to "undo" the items that were just chosen and updated back to their original "haven't been printed status"

My fields
SelectToPrint
Printed

 

[boblarson]

In order to do that you would need to at least temporarily keep track of the ID numbers of the items updated so that you could do that. Not sure what the best method would be, but maybe add them to a collection and if the print is okay then just set the collection = Nothing and that will remove it from memory. If you need it then you can iterate through the collection and build a dynamic sql string to update the fields to false. Sorry, but I'm not able to think through that process any further. I need to go get some sleep.

 

[Pat Hartman]

I usually use dates rather than flags for purposes such as these. A date is far more meaningful when you are trying to do historical reporting.

If you want to "unset" a group you will need a way of identifying the group and with your method, there is none. If you use a date, you can set the date to null for all rows where the "printDate" matches whatever date you want to undo. The alternative is doing them one record at a time if you have to use a less-specific selection criteria.