Copying one record to another

[Isis]

Is there an easy way on a form to allow a user to press a button and copy
all the fields from a given record to a new record ?

Thanks

 

[Jeff Boyce]

Isis

It would be fairly rare in a well-normalized database to need to copy all
the fields from one record to a new record. In a spreadsheet, maybe, but
not in a relational database.

You've described "how" you want to solve an issue/problem. If you describe
the issue/problem, perhaps newsgroup readers could offer another approach...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Isis]

Isis

It would be fairly rare in a well-normalized database to need to copy
all the fields from one record to a new record. In a spreadsheet,
maybe, but not in a relational database.

You've described "how" you want to solve an issue/problem. If you
describe the issue/problem, perhaps newsgroup readers could offer
another approach...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for the reply Jeff -

Each of the records, in this instance, contain the code and colours of a
complicated HTML page - There are 3 schemes set up already in the Table
and I want a user to be able to start with something 'known' and working
in a new Record ('scheme' and 'look') - they can then change things on an
element by element basis previewing the results a they go - instead of
having to set every item on the form from scratch - if they can copy a
record they can start with whatever sceme is already 'near' what they
want from the new template.

Thanks

 

[Jeff Boyce]

Isis

Take a look at the Copy and Paste Append commands.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[BruceM]

Would duplicating the record work?

Isis

Take a look at the Copy and Paste Append commands.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Isis]

Would duplicating the record work?

Maybe - but how do you do it ?

Thanks

 

[BruceM]

I should have made clearer that I was asking the question of Jeff, who is
far more knowledgeable that I about Access. The command button wizard can
create a command button to duplicate a record. The code behind that command
button uses an older syntax that I believe was associated with macros in
earlier versions of Access (pre-2000), but I'm not quite sure of that.
Unfortunately the Help file (in Access 2000, at least) seems to be broken in
places, and produces no useful information about Copy or Paste Append
methods, but I believe the command button wizard gets you to the same place
by a different route.
If your primary key is not generated automatically, either through use of
autonumber or through code, you will need to change it before you can save
the new record.

 

[Jeff Boyce]

If I recall correctly, you can use the Command Button wizard in form design
mode to select a record operation to "duplicate" a record.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Isis]

If I recall correctly, you can use the Command Button wizard in form
design mode to select a record operation to "duplicate" a record.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks to you all for that - the button wizard seems to hold answers to
all sorts of questions I had.

Regards