Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    creating scheduler form (a2k3, win xp sp 2)

    I need to learn how to create a continuous spreadsheet-like scheduler form with 7 dates running horizontally and various time periods vertically. I'd like to be able to both view and enter appointments.

    Don't have a clue how to get started. Does anyone have a demo/sample that I could look at? Once I understand the basic approach I can ask more intelligent questions.

    Eli

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

    Re: creating scheduler form (a2k3, win xp sp 2)

    Do you really need to do this in Access? Creating an appointment calendar type of form is a lot of work. Outlook has extensive schedule/calendar features, and recent versions support group schedules.

    <!profile=D Willett>D Willett<!/profile> posted a monthly calendar demo in <post#=285719>post 285719</post#>.

    Several members of the UtterAccess discussion forum have posted appointment calendars; there may be something you can use. You have to become a member to be able to download files.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: creating scheduler form (a2k3, win xp sp 2)

    In addition to the suggestions by Hans, we have had good results using ActiveX controls to do this sort of thing. Check out the Calendar controls available from DBI Technologies, Inc. at http://www.dbi-tech.com/product_page_Calendar_Tools.asp. They also have more sophisticated scheduler controls that you might want to consider. I should warn you that using such controls often results in fairly complex VBA projects, but they do offer much more complete solutions with features such as conflict detection and avoidance, the ability to schedule a maximum number of simultaneous activities and the like. Post back if you have further questions.
    Wendell

Posting Permissions

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