Inserting or deleting records with out system prompt

  • Thread starter Thread starter Ram
  • Start date Start date
R

Ram

I am trying to delete all the records in a table and try
to insert records after processing the records in a
recordset. Everything went correct except that I have to
click OK each time it prompts for " Deleting 24
records.....", "Inserting a record......" . Now I need
control the system prompting. Please let me know the code
to control this.

Thanks,
Ram
 
Ram said:
I am trying to delete all the records in a table and try
to insert records after processing the records in a
recordset. Everything went correct except that I have to
click OK each time it prompts for " Deleting 24
records.....", "Inserting a record......" . Now I need
control the system prompting. Please let me know the code
to control this.
Click to expand...


Try using the Execute method instead of RunSQL.
 
you may also turn off some options. on the access menu bar
tools > options. click the Edit/Find Tab. In the upper
Click to expand...
right corner comfirm box uncheck record changes,Document
deletions and actions queries. this should turn off all
the warnings. If you wrote code to do something, why do
you need to be warned that the code you wrote is going to
do what you told it to do?!?!?
 
Back
Top