Create a Duplicate Record

C

Connie

Hello everyone,
I am using Access 2002 and would like to create a macro that will allow me
to duplicate a record, but only certain fields in the record. Is there a way
to do this, or do I need code or query.
Thanks for any help
Connie
 
S

Steve Schapel

Connie,

I think you need to make an Append Query, which defines the data you
want to add to the new record.

Then, if you want to automate this process, you can use a macro with an
OpenQuery action in order to run the append query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Macro to select and delete levels of a document 2
Copy previous record into form field 0
Drop down list control value in vba 2
Duplicate Mail Merge Record Every Time 5
Adding data to MS Access from csv file 0
Mail Merge skipping records/sending one at a time 0
Excell Otpions in office environment 0

Top