Running an update query

[markod]

Hello,


It seems there are many ways to skin a cat running SQL in VB. Here's my very basic question.

I have two update queries in my Access database. Query_Update_Avail and Query_Update_NotAvail. The queries simply set the value in a field to Yes or No indicating the line item is available or not. The queries work fine.

I have a checkbox on my form that when checked I would like to execute the Query_Update_Avail. When unchecked it would execute the Query_Update_NotAvail query. Both suppressing any warnings regarding "you are about to update X records"

I'm sure this is simple but I just need the syntax. Thanks very much

[KathyL]

Hello,
It seems there are many ways to skin a cat running SQL in VB. Here's my very basic question.

I have two update queries in my Access database. Query_Update_Avail and Query_Update_NotAvail. The queries simply set the value in a field to Yes or No indicating the line item is available or not. The queries work fine.

I have a checkbox on my form that when checked I would like to execute the Query_Update_Avail. When unchecked it would execute the Query_Update_NotAvail query. Both suppressing any warnings regarding "you are about to update X records"

I'm sure this is simple but I just need the syntax. Thanks very much

Every control can have event processing attached to it. Place an event (like a click event) on the checkbox with VB code behind it to cause the query to run. Use Docmd.setwarnings false or true to suppress warnings.

[markod]

Hi, thanks for the reply. Do you know what the VB code would be to execute the query?

Thanks

[markod]

Thanks for the help. Here is the solution I used.

DoCmd.SetWarnings False
DoCmd.OpenQuery "Query1Name"