Can you make a copy+paste macro in access?

[chris.madmanger]

Hi

I am currently making a database for my A-level ict using microsoft
access. I have recently hit a dead end and require some dire
assistance.

How can you copy a record on a form to a seperate table in the same
database using a macro.

The required fields include:

Part ID
Part Type
Item Description
Price

all 4 fields to a table of the same headings.

Would really appriciate some assistance

Regards

Manger

 

[Steve Schapel]

Manger,

What you are proposing would normally be regarded as an invalid
procedure in a database. You should normally never have two tables with
the same structure. Except in very specific and unusual circumstances,
this represents a database design flaw. Your example does not appear to
be one of those exceptional circumstances.

With that disclaimer... you can do this by using an Append Query. The
query would select the form's current record from the first table, and
insert it to the second table. If you want to automate this with a
macro, then you would use an OpenQuery action in the macro, to run the
append.