Inserting or deleting records with out system prompt

[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

 

[Marshall Barton]

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.

Try using the Execute method instead of RunSQL.

 

[Frank Stone]

you may also turn off some options. on the access menu bar

tools > options. click the Edit/Find Tab. In the upper

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?!?!?