How to insert a record when I click a button ?

J

John

Maybe this question is very easy for an experienced MS Access developer.

But now, I need to do the following things :

When a user click a command button, the "Click" Event will insert a new
record to a table.
How can I write the source code for it ?

Thanks a lot.
 
R

Rick Brandt

John said:
Maybe this question is very easy for an experienced MS Access
developer.

But now, I need to do the following things :

When a user click a command button, the "Click" Event will insert a
new record to a table.
How can I write the source code for it ?

Thanks a lot.
Click to expand...

Where is the data for the record coming from? Normally one would execute an
append query to do this, but an append query has to either SELECT data from
another table or query to insert or it needs to have a VALUES list that it uses.
The data has to come from somewhere.
 
J

John

Hi
Not a good idea to insert new record directly to a table! Use a form to
insert the record.
Use the command button wizard in Design Mode for the form to create button
which will add a new record.

HTH

John
 
J

John

But I have to do that because I need to do some day-end calculation jobs and
these jobs will insert some records into my day-end tables, so, I have to
write a function which can insert or update a table's records.

How can I do that ?
 
J

John

Create a form based on the table you want to add records to.
A form is only a way to show a more graphical interface and neater layout
rather than table view.
Everthing you do to a record in the form is related to the table.
When you create a form, by default "Record Selectors" (Add, Next,
Previous,etc) will be shown at the bottom of the form.
Another point is you can show all the calculations on a form using text
boxes but not in a table.

Regards

John
 
Top