copying records

#1 (**permalink**) 28-Jul-2006, 08:10 AM

Hi all,

I have a form with several subforms. With a click of a button i want to copy
the main
record and all data in the subforms that is linked to the main record.

what is the easiest way to do this?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10186-copying-records.html

TIA
Ted

*

#2 (**permalink**) 28-Jul-2006, 08:10 AM

Hi Ted -- What exactly would you like to accomplish? A properly normalized
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
db should not have duplicate data stored in tables...these usually means
there are design issues.

"T Best" wrote:

> Hi all,
>
> I have a form with several subforms. With a click of a button i want to copy
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
> the main
> record and all data in the subforms that is linked to the main record.
>
> what is the easiest way to do this?
>
> TIA
> Ted
>
>
>

#3 (**permalink**) 28-Jul-2006, 08:10 AM

i'm trying to duplicate the main record with all the "sub records". the
reason being...it's a policy issuance system. when the policy renews i want
to give them the ability to click a button to duplicate last years policy,
check for changes and then print.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186

"xRoachx" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
news:99559959-FA11-4908-A5F0-8415F290B595@microsoft.com...
> Hi Ted -- What exactly would you like to accomplish? A properly
normalized
> db should not have duplicate data stored in tables...these usually means
> there are design issues.
>
> "T Best" wrote:
>
> > Hi all,
> >
> > I have a form with several subforms. With a click of a button i want to
copy
> > the main
> > record and all data in the subforms that is linked to the main record.
> >
> > what is the easiest way to do this?
> >
> > TIA
> > Ted
> >
> >
> >

#4 (**permalink**) 28-Jul-2006, 08:10 AM

Ted,
I have the same question as you. I have a database that contains a mail
table with 7 linked tables - which equates to a main form with 7 embedded
subforms that I wish to copy or duplicate a given record with the click of
one button. The data is entered information for a specific project. My
users will have need to up rev each project record without destroying the
previous rev. One addition to my reqauirement, is that each new duplicate add
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
the value of 1 to the previous key field to enable the record to be savedd as
a new record.

Al T

"T Best" wrote:

> i'm trying to duplicate the main record with all the "sub records". the
> reason being...it's a policy issuance system. when the policy renews i want
> to give them the ability to click a button to duplicate last years policy,
> check for changes and then print.
>
> "xRoachx" wrote in message
> news:99559959-FA11-4908-A5F0-8415F290B595@microsoft.com...
> > Hi Ted -- What exactly would you like to accomplish? A properly
> normalized
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
> > db should not have duplicate data stored in tables...these usually means
> > there are design issues.
> >
> > "T Best" wrote:
> >
> > > Hi all,
> > >
> > > I have a form with several subforms. With a click of a button i want to
> copy
> > > the main
> > > record and all data in the subforms that is linked to the main record.
> > >
> > > what is the easiest way to do this?
> > >
> > > TIA
> > > Ted
> > >
> > >
> > >
>
>
>

#5 (**permalink**) 28-Jul-2006, 08:10 AM

You're going to have to write some code to do this. There is no simple
click-button-copy-paste-master-and-detail-records that I know of.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
Your button would have to make a recordset for the top level data, add a
record, and then copy whatever fields you want in the new copy. Then, make
another recordset for the detail records and repeat the process for that
data.

You can also accomplish the same thing using a database object and writing
SQL on the fly, then using EXECUTE on the database object instead of making
recordsets. I prefer recordsets, but it depends on several factors.

Which are you comfortable with?

#6 (**permalink**) 28-Jul-2006, 08:11 AM

Hi Rick, I'm more familiar with recordsets. I know what you're saying. That
was how I was leaning. I'm just a little unsure of how to do it.

"Rick Wannall" wrote in message
news:vxKcg.76958$F_3.46476@newssvr29.news.prodigy. net...
> You're going to have to write some code to do this. There is no simple
> click-button-copy-paste-master-and-detail-records that I know of.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
>
> Your button would have to make a recordset for the top level data, add a
> record, and then copy whatever fields you want in the new copy. Then,
make
> another recordset for the detail records and repeat the process for that
> data.
>
> You can also accomplish the same thing using a database object and writing
> SQL on the fly, then using EXECUTE on the database object instead of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
making
> recordsets. I prefer recordsets, but it depends on several factors.
>
> Which are you comfortable with?
>
>