Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Query_A2K10_MultiValueFields
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Query_A2K10_MultiValueFields

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Query_A2K10_MultiValueFields
    Posted: 30 Oct 2011 at 9:33pm

Query_A2K10_MultiValueFields
Explanatory Notes

    This sample db demonstrates query based approach to bulk appending / updating / make table actions involving multi-value  fields in Access 2010, without resorting to use of recordset or recordset2 objects, thus overcoming a known limitation associated with such fields.

    In this arrangement, an extra field named TempID is provided in the destination table. The append query is executed in two stages. In first stage, primary key values from source table are appended to TempID field in destination table. In 2nd stage, value elements of MVF field get appended, using an inner join between the source and destination tables (PK of source table equals TempID of destination table).

    Three styles are covered as follows:
   
(a) Bulk appending of selected records (having multi-value fields) from one table to another.
    (b) Bulk updating of multi-value field elements (addition or replacement of values) in destination table based upon values held in source table.
    (c) Make table action covering multi-value fields based upon selected records in source table.  

Version: Access 2010 accdb file.

References: Nothing extra.

Download File >>:  uploads/37/Query_A2K10_MultiValueFields.zip
 
 
--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down