Page 1 of 3 123 LastLast
Results 1 to 15 of 41
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Design Grid (A2k)

    RE: Attachment

    I've attached a screen dump of a form along with its module.

    I've managed to get this form working with the minimul of clicks to fill the data.

    4 items are req:-

    Toggle to the left, tglUnit01 thru to 20, this fills the txtVehicleID

    Day toggles at the top, tglDay01 thru to 31, this will fill txtDateFrom & txtDateThru.

    Combo at the bottom fills the txtColor.

    With all these elements, a grid is drawn within the grid strucrure.

    The date toggles at the top enable the user to scroll thru the dates and the arrows move in situe.

    Each arrow holds a periodID in the underlying table tblPeriod, which is always unique with a Primary Key Field (PeriodID).
    Looking in the table, you have:-

    PeriodID | UnitID | Unit | DateFrom | DateThru | Colorkey | JobID | Client

    I need to pass data thru to the vertical texts on the left of the grid,. one row for the periodID and one row for the Client or JobID.
    I have spoken to the software writer which I have copied his mail to the top of the grid pic.

    The code behind the form looks a little daunting to me although some bits are now becoming clear.
    I really don't know how to pass this data ie Period, Job or Client.
    Would some-one mind taking a look and advise.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Design Grid (A2k)

    If you don't understand it, then who created it?
    Charlotte

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

    Re: Design Grid (A2k)

    Charlotte

    It's designed by www.Datasperellc.com as a useful utility to schedule pretty much any thing.

    We use a similar paper version to schedule our courtesy cars using a pencil and series of arrows with the dates as you see in the grid.
    So you can see my interest in purchasing.
    I purchased it about 2 yrs ago and not really done alot with it.
    Obviously now knowing a little more than I did back then, some elements are beginning to make sense.

    In the screen dump you see the Car Registration No.s imposed on the vertical toggles to the left.
    The form has several form modules which are called specifically further down the code.
    What I was after was a way to fill the texts again on the left with data relating to each toggle caption ie Car registration and its date range.
    As I said earlier each one is uniquely identified with a PeriodID autonumber.
    So in laymans terms, If the toggle caption is KM51KTA with a date range of 21/11/2002 to 23/11/2002, it has a PeriodID lying in the tblPeriod table.:-

    So if I scroll thru the dates, the text on the left needs to change as we scroll.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Design Grid (A2k)

    Hi Dave, I have studied your question and the picture of the form your trying to modify. I think that you want to fill the text boxes to the left of the command buttons with information about the booking date for the vehicle which is actually being displayed on the grid. Is that about right?

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Design Grid (A2k)

    And there was no documentation with it? BTW the address you put in your message doesn't appear to exist. You might want to check the spelling.
    Charlotte

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

    Re: Design Grid (A2k)

    Sorry Charlotte:- http://www.dataspherellc.com/


    Yes Rupert thats about right.
    I have the Registration, but infor is required for Who has the vehicle at that particuler date range changing when scrolling thru the dates.
    I think I need to pass the PeriodID to one text and then I can link other info from their.

    Sorry all about the attachment, but alls relevent.
    The module shows all the constants etc which are used later in the coding.

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

    Re: Design Grid (A2k)

    Dave,

    I assume that you have named the text boxes systematically, for example txtPeriod01 to txtPeriod17. You will probably need to use something like the following in the <font face="Georgia">For x = 1 To 17 ... Next x</font face=georgia> loop in the FillUnits procedure:

    Me("txtPeriod" & Format(x, "00")) = DLookup("PeriodID", "tblPeriod", "UnitID=" & .Fields(cUnitPK))

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

    Re: Design Grid (A2k)

    Hans
    I knew you couldn't resist the challenge.
    You are SOOOOOOO Close.

    We now have the PeriodID in txtPeriod text's.

    How do I change the function ScrollUnits so the data is updated as we scroll thru the coloured date ranges.
    Attached Files Attached Files

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

    Re: Design Grid (A2k)

    Dave,

    ScrollUnits calls FillUnits, which updates the txtPeriod text boxes now, so it should be OK.

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

    Re: Design Grid (A2k)

    Oops, I just realised that I didn't read your original question carefully. I see now that here can be multiple PeriodID's for the same UnitID. So displaying PeriodID is confusing. Which one do you want to show in the text box? the first one (from left to right) that is visible? Or the first one that is visible in its entirety? Or something else?

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

    Re: Design Grid (A2k)

    <P ID="edit" class=small>(Edited by D Willett on 22-Nov-02 12:24. )</P>Well looking at my attachment, on the date toggles at the top, tglDay01 thru to 31, when either the dateFrom through to dateThru is within the region of tglDay01, the PeriodID's are updated to txtPeriod's

    So by this as we scroll, the txtPeriod's change to suit the date range

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

    Re: Design Grid (A2k)

    And if there is no arrow straight below "Today" (as is the case for SD52RTU, for instance), should the text box be empty?

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

    Re: Design Grid (A2k)

    you got it exactly

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

    Re: Design Grid (A2k)

    Dave,

    If I find time, I will try to solve this, but I won't be able to reply before Monday.

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

    Re: Design Grid (A2k)

    Not a problem
    Thanks

Page 1 of 3 123 LastLast

Posting Permissions

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