Copying data from one form to another

  • Thread starter Thread starter Eddie
  • Start date Start date
E

Eddie

I need to copy all of my data fields from one table to
another, possibly two. Anyone know what the code would
look like to do this?

Your assistance is appreciated.

-Edm
 
I need to copy all of my data fields from one table to
another, possibly two. Anyone know what the code would
look like to do this?

Your assistance is appreciated.

-Edm
Click to expand...

An Append query (or a MakeTable query for a new table) is the simplest
way to do this.

HOWEVER - storing the same data redundantly in multiple tables is
generally a Very Bad Idea. Could you explain why you need to do this?
What is your intended use of the second/third tables?
 
Hey,

The first table is actually a temporary storage table used
to filter out bad or redundant data. Once the fields are
all verified as accurate the record is then copied over
into our actual inventory (and the temporary entry is
deleted), where it sits until it is again shipped (the
inventory is cleared), and copied over into our outgoing
archive.


Thanks,

Edm
 
Hey,

The first table is actually a temporary storage table used
to filter out bad or redundant data. Once the fields are
all verified as accurate the record is then copied over
into our actual inventory (and the temporary entry is
deleted), where it sits until it is again shipped (the
inventory is cleared), and copied over into our outgoing
archive.
Click to expand...

Ok... that makes plenty of sense.

Simply run an Append query appending from the temp table into the real
table.

If you'll be doing this routinely, be sure to Compact your database
regularly; the space occupied by the deleted records will not be
reused, and you can get the database bloating pretty rapidly.
 
Back
Top