G
Guest
Hi there,
I have 6 queries I need to run which will fill in null records in 6 fields.
I don't want my users to have to click "Yes" 6 times. How can I suppress the
"You are about to update xxx rows" messages. The following code and sql are
an example.
DoCmd.OpenQuery "qryUpdtGST0", acNormal, acEdit
SQL code from the query SQL View:
UPDATE tblFinalData SET tblFinalData.GSTRatio = 0
WHERE (((tblFinalData.GSTRatio) Is Null));
Could I, as an alternative, run an update query in code? I've just never
been very good at the proper formation of this sort of coding.
All help is greatly appreciated.
Thanks,
JR
I have 6 queries I need to run which will fill in null records in 6 fields.
I don't want my users to have to click "Yes" 6 times. How can I suppress the
"You are about to update xxx rows" messages. The following code and sql are
an example.
DoCmd.OpenQuery "qryUpdtGST0", acNormal, acEdit
SQL code from the query SQL View:
UPDATE tblFinalData SET tblFinalData.GSTRatio = 0
WHERE (((tblFinalData.GSTRatio) Is Null));
Could I, as an alternative, run an update query in code? I've just never
been very good at the proper formation of this sort of coding.
All help is greatly appreciated.
Thanks,
JR