Auto reply to prompts 1

[GRM1T]

I am using a RUNSQL as below:-
strUpdatePalletQty = "UPDATE PalletInfo " & _
"SET Qty = Qty+1 " & _
"WHERE PalletNo = [PalletNo];"
DoCmd.RunSQL strUpdatePalletQty

MSAccess requests an input to confirm update of one raw. The answer is always going to be YES.
Can this be done automatically so that the program doesn't wait for the user to press "Y" or a mouse click?

 

[dhookom]

strUpdatePalletQty = "UPDATE PalletInfo " & _
     "SET Qty = Qty+1 " & _
     "WHERE PalletNo = [PalletNo];"
DoCmd.SetWarnings False
DoCmd.RunSQL strUpdatePalletQty
DoCmd.SetWarnings True

Duane
Hook'D on Access
MS Access MVP

 

[JerryKlmns]

If you use

CurrentDB.Execute strUpdatePalletQty

you wont have to mess with warnings!