 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2006Copying one record to another
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 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 > 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 > Isis > [quoted text clipped - 15 lines] >> >> Thanks 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 Isis Take a look at the Copy and Paste Append commands. Regards Jeff Boyce Microsoft Office/Access MVP >> Isis >> [quoted text clipped - 28 lines] > > Thanks Would duplicating the record work? > Isis > [quoted text clipped - 37 lines] >> >> Thanks > Would duplicating the record work? > [quoted text clipped - 40 lines] >>> >>> Thanks Maybe - but how do you do it ? Thanks 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. >> Would duplicating the record work? >> [quoted text clipped - 44 lines] > > Thanks 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 >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 [quoted text clipped - 57 lines] >> >> Thanks > If I recall correctly, you can use the Command Button wizard in form > design mode to select a record operation to "duplicate" a record. [quoted text clipped - 66 lines] >>> >>> Thanks Thanks to you all for that - the button wizard seems to hold answers to all sorts of questions I had. Regards |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.