Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2004
    Location
    Czech Republic
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need template help (2000)

    <img src=/S/catty.gif border=0 alt=catty width=19 height=18> Can you help?

    I work in a library and teach ECDL -Europe's equivalent to MOS.

    I am trying to write a database to help me.

    We have 8 computers, are open Monday to Friday 9 - 7.30 pm. Users have half hour slots and most take 2 hours.
    I need to be able to put in their name for these slots as well as being able to work out the number of computer hours per day/week and the number of computer users per day/week.

    Any help with regard to templates available will be gratefully received.

  2. #2
    Star Lounger
    Join Date
    Jan 2003
    Location
    Grass Valley, California, USA
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need template help (2000)

    You have chosen one of the more "interesting" tasks to apply to a database solution. I have done an appointment scheduling system, as part of a larger system, and it was the most difficult portion of the entire project. I don't tell you this to discourage you, but to warn you that, depending upon the level of sophistication you want to include, and the level of screen form graphics created to ease the usage of the system, you could be looking at a multi-week effort to get it working. That said, here is a rough table design that mirrors the appointment table I created for use:

    Column Name Data Type Comments
    ApptID Autonumber Generated ID by which the appointment can be referenced
    ApptDate Date/Time Date of appointment
    ApptStart Number 4-digit number which can be formatted as hh:mm to reflect the appointment start time of day
    ApptEnd Number 4-digit number which can be formatted as hh:mm to reflect the appointment end time of day
    ComputerID Number Reference link to the particular computer being scheduled
    UserID Number Reference link to the particular user who is pre-registered as a valid potential user of computer services

    The above table assumes the presence of a Computer table (with a ComputerID key) and a User table (with a UserID key). The content of those tables, beyond their key, I leave to your design.

    The hard part of the problem is the user interface to get data into these tables, and the display of the table data in a meaningful manner. To fully describe my solution would be far too elaborate for this form. Suffice it to say that I allowed the user to select a form date, and from the date, I read the Appointments table filtering out the desired date. Then I created a dynamic array in RAM, with one slot for each 15-min time period on each computer. Into the slot went the ClientID. Then, from the array, I was able to dynamically build a subform display that visually showed which time slots were in use, and by who, and which time slots were open.

    This should give you a general idea of one approach. Good luck.

    -- Jim

  3. #3
    Lounger
    Join Date
    Apr 2004
    Location
    Czech Republic
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need template help (2000)

    Many thanks for that great help.

    Anyone else out there got a TEMPLATE for such an enterprise. As the previous receipient says it might take many weeks to do.

    Cheerz from Scotland

Posting Permissions

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