Simple Question

[James]

I've only used macros before and now I'm trying to code everything in
vb... so I'm sure this is simple to do... I've got a table
"UserIdandPassword" with two fields UserID and Password. I've created a
form to add records to this table with a UserID field and a Password
field and an Add button. What code do I put under the Add button to
make it add the record to the table? Thanks!

 

[Jeff Boyce]

James

If you use the Toolbar wizard, Access will walk you through creating a
command button to save/add a new record.

And you could always just leave the record you're on ... when you do that,
Access automatically saves the record.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Graham Mandeno]

Hi James

If your form is bound to the table then you don't need to do anything.
Adding a new record in the form will automatically save it to the table,
unless there is something about it which makes the record invalid.

If, for some reason, you do not want to use a bound form, then you can
either:

a) open a RecordSet based on your table and add a new record (.AddNew) then
fill in the values in the fields, then save it (.Update), or

b) execute a sql "INSERT INTO" statement to create the record:

Dim sSql as string
sSql = "Insert into UserIdAndPassword (UserID, Password) values ('" _
& txtUserID & "', '" & txtPassword & "');"
CurrentDb.Execute sSql, dbFailOnError

I recommend a bound form!