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


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

Forms_ReGroupRecords.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: Forms_ReGroupRecords.mdb
    Posted: 08 Jul 2008 at 10:55pm
This sample db demonstrates movement of records amongst groups. The example 
covers an electrical distribution system comprising of circuits & lamps. It shows how 
the user can re-assign selected lamps from one circuit to another.
 
Subform A at left displays the lamps belonging to destination circuit (Circuit A), as 
selected in the combo box. Subform B at right displays all other lamps (not 
belonging to circuit A).
 
Lamps selected in Circuit B (subform at right) get transferred to Circuit A (subform at 
left). The transferred records get inserted just after the current cursor position in 
subform A. The user can determine the precise insertion point by suitable 
placement of cursor in this subform, before clicking the command button for moving 
the records. Freshly moved lamps get highlighted in special color in suform A. 

 
Lamp in newly inserted records get renumbered by suffixing .001, .002 etc just after 
the lamp number below which the insertion takes place. Overall numbering for the 
current circuit in subform A, can be dressed up by clicking the command button for 
renumbering. This gets rid of the extra decimal suffix and renumbers all the lamps in 
proper sequence, retaining their intended sort order.

Three categories of lamp numbering are demonstrated as follows:
    (a) Pure digits (four digits format).
    (b) Prefix "FL-" followed by four digits - denoting fluorescent lamps.
    (c) Prefix "SV-" followed by four digits - denoting sodium vapor lamps.
 
Note:
    (a) If it is anticipated that the number of lamps per circuit might exceed 9999, the 
         length of format string ("0000") used in re-numbering module, can be 
         increased suitably.
    (b) Freshly moved lamps acquire the existing prefix (if any) for the current record 
         in subform A, below which the insertion takes place.
    (c) On renumbering in subform A, digital sequence for each group of lamps (as 
         identified by the prefix), starts at "0001".
Download: uploads/37/Forms_ReGroupRecords.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