Docmd.RunSQL vs CurrentDB.Execute in MS Access

MS Access is a simple yet powerful relationship database. Those who has experiences in creating tables and queries. You would probably use form to do the data entry for your staffs. In the form, you can add some VBA code by using command "Build Event..."

Below is to show you how to run SQL delete command over table F0101 without message prompt.

DoCmd.SetWarnings False    

Docmd.Runsql "DELETE F0101.* FROM F0101" 

DoCmd.SetWarnings True

Or

CurrentDB.Execute "DELETE F0101.* FROM F0101"