remove records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yvonne - 31 Mar 2005 14:57 GMT

Hi I need to delete all records from a table in my
database. I have a button on a table maintenance form
which I would like to run the code from. Only data
should be removed.

my table is tblplacenames

thanks

Yvonne

Reply to this Message

Nikos Yannacopoulos - 31 Mar 2005 15:15 GMT

Yvonne,

Put this code in the button's On Click event:

cnt = DCount("*", "tblplacenames")
strSQL = "DELETE * FROM tblplacenames"
CurrentDb.Execute strSQL
MsgBox cnt & " Records deleted.", vbInformation, "Place Names table"

HTH,
Nikos

> Hi I need to delete all records from a table in my
> database. I have a button on a table maintenance form
[quoted text clipped - 6 lines]
>
> Yvonne

Reply to this Message