from query to form to table

[Bob]

I have a table from where I am getting some data by a
query,in the query I am adding two fields for some
calculation fields. This data from the query is then
displayed on a form where two more fields are added.

Now on the click of a button on this form I want to put
all the data on the form in to a seperate table (not the
original table).

How would I do that?

 

[Van T. Dinh]

I am questioning whether it is the correct thing to do?

It sounds like you store the same data twice and storing duplicated merely
add inefficiencies and inconsistencies problem in your database.

The Relational Database Design Theory also advises that Calculated Values
should be re-calculated whenever needed and should not be stored in Tables
since storing Calculated Values will create inconsistencies sooner or later.

 

[Sean Jackson]

When you click the button, use the recordsetclone method, which will create
a NEW recordset which is a copy of the forms recordset.

dim rs as recordset
set rs = me.recordsetclone (or whatever)

scroll thru the new recordset, using

do until rs.eof

'''do the INSERTS here
rs.movenext
loop

 

[bob]

Does this sound right then?

this is what my plan is........

write a select query to get the data from that table which
already exists with the students records and do that T
hours calc in the query.

Put all this data on a form. Now using the exempt,login
time,program code etc for the user to slect all that.

then this form1 is ready to be submitted.

But do not submitt it straightaway instead create a
recordset clone.....form2.

dim rs as recordset
set rs=me.recordsetclone
do until rs.eof
insert.....
rs.movenext
loop

now table_temp is ready with all the data

then use another button on that form which will append
this data to the tblattendance.
then some another button will go and delete all the
records in this temp_table. So it now has zero records.

 

[bob]

Hello Van:

Does this sound Ok then?

I do not know if I have any otehr alternatives.

this is what my plan is........

write a select query to get the data from that table which
already exists with the students records and do that T
hours calc in the query.

Put all this data on a form. Now using the exempt,login
time,program code etc for the user to slect all that.

then this form1 is ready to be submitted.

But do not submitt it straightaway instead create a
recordset clone.....form2.

dim rs as recordset
set rs=me.recordsetclone
do until rs.eof
insert.....
rs.movenext
loop

now table_temp is ready with all the data

then use another button on that form which will append
this data to the tblattendance.
then some another button will go and delete all the
records in this temp_table. So it now has zero records.

-----Original Message-----
I am questioning whether it is the correct thing to do?

It sounds like you store the same data twice and storing duplicated merely
add inefficiencies and inconsistencies problem in your database.

The Relational Database Design Theory also advises that Calculated Values
should be re-calculated whenever needed and should not be stored in Tables
since storing Calculated Values will create

inconsistencies sooner or later.

 

[Van T. Dinh]

Sorry, I got no ideas of what you are describing.