I am using Access to write a tool that will be used by "less technical" people and I use a lot of SQL statements. All the reports that are generated require at least one SQL statement. When the dialog box comes up asking if they are sure that they want to delete or append rows (the dialog box that comes up before the SQL statement executes) they freak out and say "no" which then gives them a run time error. Is there any way to just say "yes" to all the dialog boxes before they come up?
Any help would be appreciated. Thanks