delete record of the table

[fred]

I need know how delete one record of one table in Access through a comand,i
have to do for Visual Basic,that is to say, put the code, I need help

 

[Steve Schapel]

Fred,

I think the key questions here are:
- *when* do you wnat to delete this record?
- how do we identify which record is to be deleted?

 

[fred]

Fred,

I think the key questions here are:
- *when* do you wnat to delete this record?
- how do we identify which record is to be deleted?

this is ok, but I need know the code for put en Visual Basic, for that the
comand "delete", work. Example, I want delete the name the one person through
of the comand delete in the form.

 

[Daryl S]

Fred -

Look up the RunSQL command in Visual Basic Help (not Access Help). Here is
the basic idea:

Dim SQL As String

SQL = "<SQL Statement Goes Here>"

DoCmd.RunSQL SQL

 

[Steve Schapel]

Fred,

Well, the focus of this forum is on Macros in Access, which is not VBA. But
anyway, the VBA code you need is:

DoCmd.RunCommand acCmdDeleteRecord