Create new record

[Del]

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 via AccessMonster.com]

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.

 

[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.

 

[ruralguy via AccessMonster.com]

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]

thank you for the code
--
Thank you,
Del

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.

 

[ruralguy via AccessMonster.com]

You're welcome. Post back here if you are still having problems.

thank you for the code

Something like:
Dim MySQL As String

[quoted text clipped - 11 lines]