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 - Form_ContinuousCopyPasteColumns.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Form_ContinuousCopyPasteColumns.mdb

 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: Form_ContinuousCopyPasteColumns.mdb
    Posted: 09 Jul 2008 at 10:34pm
This sample db demonstrates selection of a column in source subform and updating 
the selected target column in destination subform accordingly. Two styles are covered: (a) Full Column. (b) Part Column. Full Column Mode: (a) In full column mode, dbl clicking anywhere in the desired column in source subform selects the entire column. It is a simulated selection, highlighting the column in light blue color. (b) Similarly, dbl clicking anywhere in the desired column in destination subform selects the entire column, highlighting it in yellow color. (c) On clicking the copy/paste command button on parent form, contents of destination column get updated as per the source column. In confirmation of completion of this process, the color of destination column changes to orange. Part-Column Mode: (a) In part-column mode, dbl clicking on any cell in the desired column in source subform selects the cell as start of data block. Dbl clicking any other cell (as end cell) in the same column results in simulated selection of all cells from start cell to end cell. This block of cells gets highlighted in light blue color. (b) Dbl clicking any cell in the desired column in destination subform identifies that cell as starting point for target data block. This cell gets highlighted in yellow color. (c) On clicking the copy/paste command button on parent form, contents of destination data block get updated as per the source data block. In confirmation of completion of this process, the color of destination data block changes to orange.

Download Access 2K/XP/2K3/2K7: uploads/37/Form_ContinuousCopyPasteColumns.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.