Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 22 Sep 2018 at 9:20pm

Topic: AppendAsPerFieldPos.mdb
Posted By: A.D. Tejpal
Subject: AppendAsPerFieldPos.mdb
Date Posted: 10 Jul 2008 at 1:55am
This sample db demonstrates append action from one table to another, using 
field positions (instead of field names).

The technique can be handy for a set of tables having large number of fields, 
where data types across the tables are similar but field names are not.

The main subroutine accepts five arguments (name of source table, name of target 
table, desired start column in source table, desired start column in target table and 
number of columns to be covered in the range).

Last three arguments are optional. If omitted, all columns (except the one for auto-
number field) get appended.

Download Access XP & 2K: - uploads/37/


Email: -

Print Page | Close Window