Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Daily Schedule for Employees (97 or 2000)

    I have been asked by a friend to develop a program for creating an employee schedule.

    I've attached what I am needing the output to look like in an Excel spreadsheet.

    The problem is that this has to be done in ALL Access, no Excel.

    Anyone know how to create a report that could show what I am looking for?

    Thanks!
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

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

    Re: Daily Schedule for Employees (97 or 2000)

    See the attached demo. Key features:
    - A table containing a list of times with 30 minute intervals.
    - A crosstab query that shows if an employee worked a 30 minute interval.
    - Two reports based on the crosstab query. The first one uses conditional formatting, so it will only work in Access 2000 and up. The second uses standard formatting and should work in Access 97 too.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Daily Schedule for Employees (97 or 2000)

    Hans

    Using a2k (9.0.6926) SP-3 Jet 4.0 SP-8

    When I run rptSchedule, I get the following error message:

    The Microsoft Jet database engine does not recognize

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

    Re: Daily Schedule for Employees (97 or 2000)

    Probably an international formatting issue. If you open the query qrySchedule, what are the field names, apart from Start and Employee? For me, they are 00:00:00 etc, for you probably 00:00:00 AM or something like that.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Daily Schedule for Employees (97 or 2000)

    That is the case

    What can I change on my end to run the report?

    Thanks, John

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

    Re: Daily Schedule for Employees (97 or 2000)

    There are two possibilities, both rather tedious:

    - Create a new report based on the query, and then modify the layout the way I did.

    or

    - Change the Control Source of the text boxes in the detail section to match the field names of the query; ideally, change the caption of the labels in the page header too.

  7. #7
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Daily Schedule for Employees (97 or 2000)

    Those are beautiful, Hans! Thank you so much.

    I had to change my control sources, but it wasn't hard.

    This looks like exactly what I need.
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

Posting Permissions

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