Create new record

D

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

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

Del

thank you for the code
--
Thank you,
Del


ruralguy via AccessMonster.com said:
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 (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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to export table from outlook into ms access table? 0
Record insert/delete anomaly 0
Access Automatically Send a notification email once a record is added 0
Access 2010 Report Button 0
Save New Record that is not dirty 2
New record in subform with Access 2000 3
Append Query 3

Top