Adding to a Records Database

D

Darren

This may be too entailed for this but here goes anyway: I have created a form
that asks for input on the exact fields named in my table called
tblBasicEmployeInformation. From the form, how do I transfer all of the
information on the form into the table after pressing the command button "Add
Record"? Any help or websites is greatly appreciated.
 
D

Dylan Moran

Why cant you base your form on the table and have access do it all for you?
You could just create a data entry form, and as soon as the user opens the
form (based on the table), then they are ready to enter data.

But if all all your controls are unbound, and for some reason you want i
this way, then I suppose you could call an "Insert Into" SQL statement
capturing the values of the controls on your unbound form when the user
clicks the add record button.

HTH
 
D

Darren

And how do I set it to do this?

Dylan Moran said:
Why cant you base your form on the table and have access do it all for you?
You could just create a data entry form, and as soon as the user opens the
form (based on the table), then they are ready to enter data.

But if all all your controls are unbound, and for some reason you want i
this way, then I suppose you could call an "Insert Into" SQL statement
capturing the values of the controls on your unbound form when the user
clicks the add record button.

HTH
Click to expand...
 
J

John Vinson

And how do I set it to do this?
Click to expand...

Ummm... what is "this"?

Using a bound form? Just create a form using the Autoform Wizard. Use
it. No programming required.

Using an unbound form? Learn enough VBA and SQL to be able to create a
Recordset and use the AddNew method, using appropriate form references
to retrieve the data. If the previous sentence makes no sense, then
maybe you're trying to use techniques beyond your background; you may
want to hire expert help or take some training.

John W. Vinson[MVP]
 
Top