What Access 2000 code can I use to create a new record in a table? The table
is not the record source for the form where I have the code.

--
Thank you,
Del

I need to write a number of variables into the new record and I'm not sure
how to use the append query to do that.
--
Thank you,
Del


"ruralguy via AccessMonster.com" wrote:

> Look into an APPEND query.
>
> Del wrote:
> >What Access 2000 code can I use to create a new record in a table? The table
> >is not the record source for the form where I have the code.
> >
>
> --
> RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
> Please post back to this forum so all may benefit.
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200807/1
>
>

thank you for the code
--
Thank you,
Del


"ruralguy via AccessMonster.com" wrote:

> Something like:
> Dim MySQL As String
> MySQL = "Insert Into tblNAME(FIELD1, FIELD2, FIELD3) " & _
> "Values( '" & Me.txtFIELD1 & "','" & Me.txtFIELD2 & "',27)"
> CurrentDB.Execute MySQL, dbFailOnError
> Set db = Nothing
>
> Using YOUR FIELD AND CONTROL NAMES of course.
>
> Del wrote:
> >I need to write a number of variables into the new record and I'm not sure
> >how to use the append query to do that.
> >> Look into an APPEND query.
> >>
> >> >What Access 2000 code can I use to create a new record in a table? The table
> >> >is not the record source for the form where I have the code.
>
> --
> RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
> Please post back to this forum so all may benefit.
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200807/1
>
>