RSS Feeds :: DEVPPL - Forums > Visual Basic Forum : Topics : Create New Record based on Exisitng record TOGETHER WE ARE THE BEST http://www.devppl.com/forum en-gb Tue, 17 Aug 2004 14:07:13 +0100 Mon, 23 Nov 2009 20:16:15 +0000 http://blogs.law.harvard.edu/tech/rss MSSTI v0.0.1 - (C) 2008 leviatan21 - http://www.mssti.com/ Copyright : (c) RSS Feeds :: DEVPPL - Tue, 17 Aug 2004 14:07:13 +0100 webmaster@devppl.com (DEVPPL) RSS Feeds :: DEVPPL - Forums > Visual Basic Forum : Topics : Create New Record based on Exisitng record http://www.devppl.com/forum/styles/DEVPPL-v2/imageset/site_logo.gif http://www.devppl.com/forum 60 Create New Record based on Exisitng record http://www.devppl.com/forum/./viewtopic.php?p=52280#p52280
I have a database with a dozen tables (ie. tblPage1, tblPage2, tblPage3, ..., tblPage13, tblCustomer, tblInspection ...) and I am looking to loop through all tables, and only duplicate 1 particular record (the one thats currently in focus from my combo box) and then add it as a new record.

Note: The columns in each table tblPage1,2,3... are different in that one table would have several date and result columns and another tables have less columns.

I have attached my MS Access database/vb below. The part that i'm working on is frmNewfromExisingInsp and I believe it may have something to do with Recordsetclone...

Thank you in advance for your help!!!

Statistics : Posted by bradlannon • on Mon Jun 29, 2009 3:29 pm • Replies 0 • Views 73

]]>
I have a database with a dozen tables (ie. tblPage1, tblPage2, tblPage3, ..., tblPage13, tblCustomer, tblInspection ...) and I am looking to loop through all tables, and only duplicate 1 particular record (the one thats currently in focus from my combo box) and then add it as a new record.

Note: The columns in each table tblPage1,2,3... are different in that one table would have several date and result columns and another tables have less columns.

I have attached my MS Access database/vb below. The part that i'm working on is frmNewfromExisingInsp and I believe it may have something to do with Recordsetclone...

Thank you in advance for your help!!!]]> 2009-06-29T15:29:14+01:00 http://www.devppl.com/forum/./viewtopic.php?p=52280#p52280