By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,479 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,479 IT Pros & Developers. It's quick & easy.

Code to duplicate records

P: n/a
Hello,
I am again submitting my question since have not had much luck with my
previous posting.

What I am trying to do is duplicate data from one table to another. I
know is not the correct procedure but would like some help with code.
Basically I have a form named CLAIMS which has it's record source to a
table also named CLAIMS. This table has 5 fields: SSN, FNAME, LNAME,
DATE, INITIALS.

I would like to add a cmdbutton on my form that duplicates (copies)
the data that I have just entered in the form into another table,
named APPLICATIONS.

Please note that the code should copy the records, close the active
form (in this case will be the form named CLAIMS), paste the data into
the table named APPLICATIONS and finally open the form APPLICATIONS to
show the data that has just been duplicated.

Can anyone help me? Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
jp***@tin.it (Paolo) wrote in news:9f41a860.0402110641.11be4d11
@posting.google.com:
Hello,
I am again submitting my question since have not had much luck with my
previous posting.

What I am trying to do is duplicate data from one table to another. I
know is not the correct procedure but would like some help with code.
Basically I have a form named CLAIMS which has it's record source to a
table also named CLAIMS. This table has 5 fields: SSN, FNAME, LNAME,
DATE, INITIALS.

I would like to add a cmdbutton on my form that duplicates (copies)
the data that I have just entered in the form into another table,
named APPLICATIONS.

Please note that the code should copy the records, close the active
form (in this case will be the form named CLAIMS), paste the data into
the table named APPLICATIONS and finally open the form APPLICATIONS to
show the data that has just been duplicated.

Can anyone help me? Thanks.


Perhaps, here:

http://www.psychosurgery.org/index_files/Page607.htm

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #2

P: n/a
What have you figured out so far, or have you not done any looking through
help files? What you are trying to do is extremely simple, 1 append query, 2
DoCmd Lines.

Mike Storr
www.veraccess.com
"Paolo" <jp***@tin.it> wrote in message
news:9f**************************@posting.google.c om...
Hello,
I am again submitting my question since have not had much luck with my
previous posting.

What I am trying to do is duplicate data from one table to another. I
know is not the correct procedure but would like some help with code.
Basically I have a form named CLAIMS which has it's record source to a
table also named CLAIMS. This table has 5 fields: SSN, FNAME, LNAME,
DATE, INITIALS.

I would like to add a cmdbutton on my form that duplicates (copies)
the data that I have just entered in the form into another table,
named APPLICATIONS.

Please note that the code should copy the records, close the active
form (in this case will be the form named CLAIMS), paste the data into
the table named APPLICATIONS and finally open the form APPLICATIONS to
show the data that has just been duplicated.

Can anyone help me? Thanks.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.