Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009

    Unanswered: Need a little Calendar help from experts

    I am trying to set up an access database to help me scedule my service technitions. The process is simple but my programming skills are not even up to that mark. Should just stay with plc's. I put Calendar 11.0 on my form. I wished to be able to click a date and it would go to the record with that date in it. Each record would have a unique date in the record set. For instance a record would be like-date,job slot 1-job slot 2-job slot 3-ect. I just wish to hit one date on the calendar and pull up where all the service techs are working on that day. I hope this is clear. This snags will drive me to the liquor store. Thanks in advance. I have attached a print screen of the basic concept that I have trying to solve.
    Attached Thumbnails Attached Thumbnails tried.bmp  

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    An easy one!?

    AfterUpdate of the calendar object, reset the SQL of your [sub]form to include the date selected and requery the [sub]form to show the data.

    I am making a lot of assumptions here though. Nor do I know what a "plc" is. Dunno what "slot 1" is either. And I have my liquor delivered
    Last edited by StarTrekker; 07-20-09 at 23:48.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jul 2009
    Thank you for replying. I do automation programming on the side, that is what the plc was about. My knowledge of access is not enough to take what you said and run with it. Could you point me towards a tutorial that might help get me up to speed on this? Very much appreciated.

  4. #4
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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