How to delete data from a table in VBA Access

Question

How to delete data from a table in VBA Access

Navigation

#1 by (2 votes)
#2 by (0 votes)

2

I need a command in vba to delete the records from my table REPETIRTEL the moment I close my form. This form does not have this table as the data source, so I need the command to call this table and then disable the delete commit message.

vba ms-access

asked by anonymous 13.03.2014 / 20:35

2 answers

0

Another alternative:

Private Sub Form_Close()
  Application.DoCmd.SetWarnings False
  Application.DoCmd.RunSQL "DELETE * FROM REPETIRTEL"
  Application.DoCmd.SetWarnings True
End Sub

14.03.2017 / 12:53

How to send more than one value in a select element of form html? What does this mean "people [last, first]" in Python?

score 2 · Accepted Answer

First I created a delete query from the REPETIRTEL table with the Delete Query, then I called this query and that's it, it looks like this:

 Private Sub Form_Close()
  Application.DoCmd.SetWarnings False
  DoCmd.OpenQuery "deleteREPETIRTEL", acViewNormal
  Application.DoCmd.SetWarnings True
 End Sub

First I disabled access messages I called Query Re-enabled the messages.