Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Macros / August 2006

Tip: Looking for answers? Try searching our database.

Copy record to new record

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave Couch - 23 Aug 2006 14:48 GMT
Using Acess 2003.  I have a database to create tranmittals.  Very often we
send the same things, or similar to the same person.  I want to create a new
record based on an exsiting record number (using an entry "form") and then be
able to edit the new record.  Any help would be appreciated.
NetworkTrade - 23 Aug 2006 18:16 GMT
If the data really does not change often (but still must be edit-able) then
you can enter text as a default value for each text box of the Form....and
this will work fine.

However if the data does change with some regularity...maybe every couple
days or so - - then this static fixed method will be a pain in the neck -
particularly if your form has alot of text boxes....

I can't think of an easy & elegant way to "roll" the prior records value to
the next record that can be changed on the fly....you can of course go to the
Table and simply copy/paste the record to new record and then alter....

others may be more helpful than this.....

Signature

NTC

> Using Acess 2003.  I have a database to create tranmittals.  Very often we
> send the same things, or similar to the same person.  I want to create a new
> record based on an exsiting record number (using an entry "form") and then be
> able to edit the new record.  Any help would be appreciated.
Kernow Girl - 25 Aug 2006 15:04 GMT
Hi Dave - create a Command Button and attach the Duplicate Record command to
it. With one click you have your new record!
HTH -- yours Dika

> Using Acess 2003.  I have a database to create tranmittals.  Very often we
> send the same things, or similar to the same person.  I want to create a new
> record based on an exsiting record number (using an entry "form") and then be
> able to edit the new record.  Any help would be appreciated.
 
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.