Access 2003 VBA Code

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

How do you write records from a temporary table to a permanent table.
I have a one to many form where I am trying to have the user select which
task code they want for a given task. These are in a subform. The subform has
63 DSR codes that will display on the screen. The user has 5 check boxes to
select task code for each of these 63 codes. He can only select 1 from the 5.
I would then like to take the populated check box and write it to a permanent
table.
 
How do you write records from a temporary table to a permanent table.
I have a one to many form where I am trying to have the user select which
task code they want for a given task. These are in a subform. The subformhas
63 DSR codes that will display on the screen. The user has 5 check boxes to
select task code for each of these 63 codes. He can only select 1 from the 5.
I would then like to take the populated check box and write it to a permanent
table.
Click to expand...

use an append query that uses the checkboxes to filter the data.
then create a delete query to delete those records from the original
temp table once completed.
 
Thank you. I will give that a try.
Is it better to use Access queries or write VBA code creating recordsets
etc. to do the same thing. What will give you the greatest efficiency?
 
Using a query is almost always significantly more efficient than using VBA
to perform the same function.
 
Back
Top