copy a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

What is the recommended way to copy a single record from a query or from a
table into a table?

Is this the only way to use recordset: rs![Field1] = rs2![Field1], or is
there a rs.record.copy method or some other way? I know that I can also do
this with sql: Insert into Table2 Select * From Table1 Where Field1 =
myvariable...

- Beginner -
 
You can do it with VBA, but SQL is more efficient. But, the most basic
question is why? Duplicating a record runs contrary to normalized database
rules. What is it you are trying to do?
 
Hi :)

I'm thinking of storing some selected records of data in a table, because my
data is changing every day. I'd be storing the data for a month or so and
then use it for reports.

- Beginner -

Klatuu said:
You can do it with VBA, but SQL is more efficient. But, the most basic
question is why? Duplicating a record runs contrary to normalized database
rules. What is it you are trying to do?
--
Dave Hargis, Microsoft Access MVP


Beginner said:
Hi!

What is the recommended way to copy a single record from a query or from a
table into a table?

Is this the only way to use recordset: rs![Field1] = rs2![Field1], or is
there a rs.record.copy method or some other way? I know that I can also do
this with sql: Insert into Table2 Select * From Table1 Where Field1 =
myvariable...

- Beginner -
Click to expand...
Click to expand...
 
So what happens to the data you don't want to save for the reports?
I really do want to answer your question, but I don't have much of an idea
what you are doing, so I can't give you a good answer.
--
Dave Hargis, Microsoft Access MVP


Beginner said:
Hi :)

I'm thinking of storing some selected records of data in a table, because my
data is changing every day. I'd be storing the data for a month or so and
then use it for reports.

- Beginner -

Klatuu said:
You can do it with VBA, but SQL is more efficient. But, the most basic
question is why? Duplicating a record runs contrary to normalized database
rules. What is it you are trying to do?
--
Dave Hargis, Microsoft Access MVP


Beginner said:
Hi!

What is the recommended way to copy a single record from a query or from a
table into a table?

Is this the only way to use recordset: rs![Field1] = rs2![Field1], or is
there a rs.record.copy method or some other way? I know that I can also do
this with sql: Insert into Table2 Select * From Table1 Where Field1 =
myvariable...

- Beginner -
Click to expand...
Click to expand...
Click to expand...
 
Hi Klatuu!

Actually I was able to solve my problem a few hours ago, I decided to use
SQL because it is fast and I can esily put a variable into it.

Thaks any way! :)

- Beginner -

Klatuu said:
So what happens to the data you don't want to save for the reports?
I really do want to answer your question, but I don't have much of an idea
what you are doing, so I can't give you a good answer.
--
Dave Hargis, Microsoft Access MVP


Beginner said:
Hi :)

I'm thinking of storing some selected records of data in a table, because my
data is changing every day. I'd be storing the data for a month or so and
then use it for reports.

- Beginner -

Klatuu said:
You can do it with VBA, but SQL is more efficient. But, the most basic
question is why? Duplicating a record runs contrary to normalized database
rules. What is it you are trying to do?
--
Dave Hargis, Microsoft Access MVP


:

Hi!

What is the recommended way to copy a single record from a query or from a
table into a table?

Is this the only way to use recordset: rs![Field1] = rs2![Field1], or is
there a rs.record.copy method or some other way? I know that I can also do
this with sql: Insert into Table2 Select * From Table1 Where Field1 =
myvariable...

- Beginner -
Click to expand...
Click to expand...
Click to expand...
 
Back
Top