copy a record

[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 -

 

[Guest]

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?

 

[Guest]

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 -

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 -

 

[Guest]

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

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 -

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 -

 

[Guest]

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 -

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

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 -

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 -