Results 1 to 11 of 11
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can This Be Done ? (A2k)

    Over the weekend, I went to our local bowling alley, and they had some very interesting software monitoring each lane.
    I strained as much as I could (sad I know) to see more but, was persistently asked by the staff if they could help.
    "No" I kept saying, I'm just pinching some idea's from your software. As you can imagine, I got some strange looks !!.
    Any way, here's how there software was laid out.
    Each lane had a (what looked like) a timer bar, which when the lane was activated, the timer bar reduced by the minute,hour etc, until the timer reduced to nothing and the operator was prompted that the lane was either available or needed extending.

    Would this be possible to do, I'm sure it would be, but how to implement it.
    This would not only look stunning in a schedule scenario, but also be very useful.
    Could anyone put together a small demo or point me in the correct direction on how to reproduce this ??

    BTW, I lost miserably <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can This Be Done ? (A2k)

    Before anyone invests time in this, how do you envision using this in a car body shop?

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can This Be Done ? (A2k)

    Hans
    Good question.
    A bowling alley lane isn't really much different than a vehicle that needs repairing.
    A timer starts for each vehicle when it is booked into the workshop, and eventually the timer ends.
    Each repair is given a set time on how long it should take to complete.
    Albeit this works as a daily timer as opposed to the lanes minute to minute timer.
    The parameters would be :
    JobID, Vehicle, DateStart, DateEnd.

    Ideally the bar (kind of like a status bar) would gradually reduce as the date progressed.
    When the bar reached, the expected finish date, prompters could be initialised.

    Many software programs exist within our industry, but none or very few use a visual format.
    I always feel this approach is far better than a screenful of dates.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can This Be Done ? (A2k)

    > A bowling alley lane isn't really much different than a vehicle that needs repairing.

    So your employees throw bowling balls at the car to be repaired until it falls over? I don't know if I would bring my car to you (if I had one).

    But seriously, a bowling alley has a fixed number of lanes that are used over and over again, while a car (hopefully) leaves the body shop after having been repaired.

    If nobody else comes up with an example, I'll see if I can whip up something tonight.

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can This Be Done ? (A2k)

    So your employees throw bowling balls at the car to be repaired until it falls over?

    Why do you think we are so busy ?? <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>

    I've started messing a little with this:
    Three texts, JobID,StartDate,EndDate.
    Unbound text (txtDuration) : =[DateEnd]-[DateStart]+1
    Box control:Width 10cm

    If Me.txtDuration = 10 Then
    Me.BoxDuration.Width = 9
    End If

    Gives the kind of idea of what I'm looking for.

  6. #6
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can This Be Done ? (A2k)

    Dave
    Be aware that the width property needs to be set using twips not cm. There are 567 twips/cm (1400/inch)
    Might save you a handful or two of hair <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can This Be Done ? (A2k)

    If you want to be precise, 1440 (= 20 * 72) twips per inch.

  8. #8
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can This Be Done ? (A2k)

    Whoops! typo! mea culpa! <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    Thanks
    Hans
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  9. #9
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can This Be Done ? (A2k)

    Thanks.
    Yes I saw this when playing with the box control.
    The ideal form would be continuous but the box doesn't resize until the record has focus, but the size doesn't change thru records. All box widths set the same size, until focus is moved(typical of Contiuous forms.
    I'll leave alone for now and hope a good demo can be accomplished.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can This Be Done ? (A2k)

    This won't work in a continuous form except with some tricks that wouldn't be particularly useful here, I think.

    I am still not convinced that it will be useful anyway; I assume the time scale of car repairs is days. In the attached demo (Access 97 zipped to keep the size down), loosely based on your courtesy car planner form, a timer is used to redraw the bars. I chose to represent 1 day by 1440 twips (1 inch); this means that the bars will shorten by 1/1440 inch per minute - not exactly a lively show. But you're welcome to study it and adapt it to your needs.
    Attached Files Attached Files

  11. #11
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can This Be Done ? (A2k)

    Hans

    Thanks for your extended help on this.
    This is loosely what I had envisaged using the planner form I already had, so we're on the same track.
    I'll see what I can do with it when I've had chance to study it.
    Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •