Button on Form to Clear All Table Records (1 Viewer)

L

leladavis

New member

Local time

Today, 04:31

Joined

Jul 14, 2011

Messages

7

• Aug 19, 2011

• #1

Can someone please suggest the VBA code to use on a button in a form that would delete all the records from a table called "tbl_FMC_List"?

I am the only person using this form so I just want to click the button and clear all the records from the table.

 

J

JANR

Registered User.

Local time

Today, 11:31

Joined

Jan 21, 2009

Messages

1,623

• Aug 19, 2011

• #2

Currentdb.Execute "Delete * From tbl_FMC_List", dbFailOnError

will remove all records, perhaps you should give your self a chance to stop deleting with a msgbox in case you accedently click on your button

JR

 

L

leladavis

New member

Local time

Today, 04:31

Joined

Jul 14, 2011

Messages

7

• Aug 19, 2011

• #3

Thanks so much for the fast reply. That worked perfect!