how to add tabular record into table ?

[Dlovan-IT]

hello all friends


i have a form the control source of form is getting information from table and the type of form is tabular i want when the user input for example 10 person into form when click in the button all the record stored from another table , how to do it ?

look my attachment to see the database

 

[Cronk]

Can I check exactly what it is that you want?

You want the user to enter a number of records and then copy they to another table, so that the data exists in Table1 as well as some other table?

Then after the user enters another set of records, clicking the button will repeat that process, but only for the new records added?

What are you trying to achieve with this?

 

[Dlovan-IT]

my friend i want when the user input another record in form and click on the button the record was stored into another table

 

[Cronk]

Why would you want to store a record in two tables?

But to answer your question, you could put in the forms AfterInsert event, the code to run an append query.

 

[Dlovan-IT]

dear Cronk , do you see the database ? i suggest looked database , i have a one table and form the form is getting information from table , but i want when the user input the new record in form store into another table , my friend i know how to add into table but it is tabular form it means the record in form is not limited i want create a loop for all the record when click on the button stored in the table . can you do it ? really i need my friend i hope u do it for me ,...... thanks so much for helping

 

[Cronk]

I did look at your database. Why do you want to store records in another table? And where is this other table located? Execute an append query on clicking your button.

I support myself by charging people to "do it". Here I offer to help people so they can do it.

 

[Dlovan-IT]

any table is not important for me you can create by any name in the database , but append query is not do it for me my brother i used but it was not doing for me . it can be doing it by SQL or Visual Basic code .... please i'm wait all my project was stopped by this process if any one can solved it please help me

 

[Cronk]

Post the SQL for your append query that did not work.

 

[Dlovan-IT]

my friend can u give me an append example ?

 

[Cronk]

A google search will give lots of examples, including utube demonstrations.

You still have not responded why you want to copy a record from one table to another.

I won't be responding any more until I see that you have done something for yourself.