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

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?

--
Steve Schapel, Microsoft Access MVP


"fred" <(E-Mail Removed)> wrote in message
news:C7B3E918-DB0E-419B-81FC-(E-Mail Removed)...
> 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" wrote:

> 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.
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "fred" <(E-Mail Removed)> wrote in message
> news:C7B3E918-DB0E-419B-81FC-(E-Mail Removed)...
> > 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
> >
> .
>

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


--
Daryl S


"fred" wrote:

>
>
> "Steve Schapel" wrote:
>
> > 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.
> > --
> > Steve Schapel, Microsoft Access MVP
> >
> >
> > "fred" <(E-Mail Removed)> wrote in message
> > news:C7B3E918-DB0E-419B-81FC-(E-Mail Removed)...
> > > 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
> > >
> > .
> >

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

--
Steve Schapel, Microsoft Access MVP


"fred" <(E-Mail Removed)> wrote in message
news:EA8A9069-B2FE-4057-9890-(E-Mail Removed)...
>
>
> "Steve Schapel" wrote:
>
>> 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.