Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007

    Unanswered: Cinema Type Of Reservation Records

    Hi Everyone,

    Does anyone knows how to create the cinema type of reservation records?

    Hmm... I want to create system such that it can able to view the date and also view the availability of the tools.

    For eg. Let say from this particular dates 1/9/07 to 8/9/07

    1. Available dates for tool booking (Appear red in the square box)
    2. Tool is being reserved by other people (Appear yellow in the square box)
    3. Tool Repair (Appear blue in the square box)
    4. Tool Calibration (Appear green in the square box)

    Thus, the user can view all the status of the tool and at the same time can select the red square box for booking of the tool.

    And also after the dates should be appearing the today date. The past date should not be appear. And also add the timing record from 9am to 6pm.

    How can I create those 4 types of the boxes in the Access Database???


  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    If Status = 1 Then 'booked
     Me.theSquare.BackColor = RGB(255,0,0)
    Home | Blog

Posting Permissions

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