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

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

MatchPipeSequence.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: MatchPipeSequence.mdb
    Posted: 08 Jul 2008 at 10:34pm
This sample db deals with raw data where each record shows a PrevPipe 
connected to the NextPipe through a Joint. There are different installation groups, 
each containing a number of pipe sets with joint in-between as mentioned.

Goal: Re-arrange the records in such a manner that for each installation group, the 
pipes are in sequence, i.e. NextPipe in one record is the PrevPipe in next record. 

For each sequence set pertaining to a given Instal Group, the very first pipe at left 
of joint and the very last pipe at right of joint are highlighted in special colors. 

For testing the sample, try to put the raw data in most severely disorganized manner 
and then click the command button captioned  "<< Update Pipe Sequence >>".  
The subform at right will now display the pipe sets re-arranged in correct sequence. 

In the report also, very first pipe (left of joint) & very last pipe (right of joint) in the 
sequence set for each Instal Group have been highlighted in distinct colors.

Versions - Access 2000 File Format (Developed on Access 2003. Also tested on Access XP & 2K)

Download Access 2000 format: uploads/37/MatchPipeSequence.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.