How to Create new records based on old records...

[bradlannon]

Hi All, I am slightly new to VB and I am having difficulty on creating a duplicate record and adding as a new record on same table. Here is what i'm looking for as I cannot wrap my head around how to do this.

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) and then add it as a new record.

Note: each column in the tblPage's are different in that one table would have several date and result columns and another tables will 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!!!


-Brad

 

[SOS]

Actually, I'll be the one to give you the bad news. Your database structure is a mess. It is not normalized and therefore is not going to be easy to do anything. You should not have tables like tblPage1, tblPage2, etc. You are working in a relational database and not on a spreadsheet. I know it is easier for you to design your tables to how you envision your forms, but the fact of the matter is this - a non-normalized design, particularly as non-normalized as yours, will be a pain in the @$$ to get meaningful data out.

You need to read up on normalization and then redesign this from scratch.