Hi:
I have a number of queries that run prior to exporting my DB into and XML file. I run the query in a section of VB code as follows:
Dim stDocName As String
stDocName = "flow_e_e_tbl_connection_name_id_update"
DoCmd.OpenQuery stDocName, acNormal, acEdit
The query executes as expected, and gives the usual warnings: You are about to run an update query that will modify your table...proceed Y/N/H....
and the status window:
You are about to update N row(s)...Update? Y/N
Is there a way to run the query in silent mode? e.g. without the popups? If not, is there another way to runthe query in a silent way?
Thanks
J
I have a number of queries that run prior to exporting my DB into and XML file. I run the query in a section of VB code as follows:
Dim stDocName As String
stDocName = "flow_e_e_tbl_connection_name_id_update"
DoCmd.OpenQuery stDocName, acNormal, acEdit
The query executes as expected, and gives the usual warnings: You are about to run an update query that will modify your table...proceed Y/N/H....
and the status window:
You are about to update N row(s)...Update? Y/N
Is there a way to run the query in silent mode? e.g. without the popups? If not, is there another way to runthe query in a silent way?
Thanks
J
