in my application VBC, I use the SQL statement "Insert into tableName...." in a loop. So each time this statement is executed I get a messge box saying that you are about to append 1 row. Are you sure ......
Imagine that if I have 1000 records to be appended using the previous code, I will be forced to answer with yes for all 1000 records appended.
How can I prevent this message from appearance, and make Access append the records without getting user confirmation.