Page 1 of 3 123 LastLast
Results 1 to 15 of 36
  1. #1
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    210

    Use Access to schedule labs and personal?


    Would an Access db be a good way to assign and track Test Events to different labs and then personal to those events, or is there a better MS program to do that with?

    Say I have Events 1, 2, 3 and Labs A, B and C. I want to assign Event 1 to Lab B and then assign John, Sue, and Harry to Event 1. Drilling down further, I'd to assign those employees to certain positions in the lab. I'd like the user to be able to view a calendar style display that shows who is assigned to what position for what lab and what event it is.

    Can Access handle this in a clear and easy to use manner?

  2. #2
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    429
    Hi

    I would switch the process slightly

    Each Lab can have an Event and Each Event can have 1 or More Persons

    Each Person would be assigned to Positions

  3. #3
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    210
    Quote Originally Posted by mike60smart View Post
    Hi

    I would switch the process slightly

    Each Lab can have an Event and Each Event can have 1 or More Persons

    Each Person would be assigned to Positions
    That process could work. I'm now trying to visualize how to make those assignments and how to display it so we can see each Lab and Event on a calendar at a glance.
    Last edited by Etoimos; 08-06-2020 at 09:50 AM.

  4. #4
    CarlettoFed is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    82
    Of course it can be done.

  5. #5
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    429
    Hi

    Can you upload a zipped copy of your database?

  6. #6
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,554
    @mike - OP is asking whether to use access or another MS product

  7. #7
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    429

    Tasks

    Hi Ajax

    True I only addressed the creation of the process using Access.

    I did not mention the requirement to display the data in a Calendar.

  8. #8
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    210
    Quote Originally Posted by mike60smart View Post
    Hi

    Can you upload a zipped copy of your database?
    That gets a little touchy as my db is full of proprietary info that I have strip out and fill with dummy data. Right now I'm just trying to work through what all it would take to do this in Access and the best way to have Access display this to the users.

    Some of the things I have to work through are:

    1. We will have up to 6 positions per Event and can have multiple Events running on the same day. I need this to allow our manager to easily assign a person to each position for each Event without assigning the same person to more than one Event per day. My thought process here is to have a combo box of the employees that can work a position and if they are assigned to an Event, they don't show up in the combo box for a different Event on that same day.

    2. How to quickly and easily show the manning for different Events simultaneously (or near simultaneously) so that the manager can see that he has all positions filled across all Events and who is working them. I'm thinking either radio buttons at the top of the calendar to switch between Events, or if it is possible to have each day in the calendar have a column for each or the Events (and rows for the positions).

  9. #9
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    429
    Hi

    I would not have any idea how to set this up on a Calendar.

  10. #10
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,330
    If you can make use of an Outlook style calendar db, there is one floating around. I may have a copy of it - I've never used it but have looked at it. Thus whether or not it serves your purpose (e.g. cannot book same person to a task during the same time period) I don't know, but the visual view of the calendar should at least show calendar assignments. Perhaps you could modify the db so as to not be able to double book if it doesn't do that already. Post back if you want me to look for a copy.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  11. #11
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    429
    Hi Micron

    I tried modifying Peter Hibbs version of the Calendar with no success.

    See the attached
    Attached Files Attached Files

  12. #12
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    210
    Quote Originally Posted by Micron View Post
    If you can make use of an Outlook style calendar db, there is one floating around. I may have a copy of it - I've never used it but have looked at it. Thus whether or not it serves your purpose (e.g. cannot book same person to a task during the same time period) I don't know, but the visual view of the calendar should at least show calendar assignments. Perhaps you could modify the db so as to not be able to double book if it doesn't do that already. Post back if you want me to look for a copy.
    Micron, if it is different then the one Mike posted I would like to at least see it if it is not too much trouble for you to find and post it. Seeing how different ones work and looking under the covers gives me insight into how I might ultimately build what I need.

  13. #13
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    210
    Quote Originally Posted by mike60smart View Post
    Hi Micron

    I tried modifying Peter Hibbs version of the Calendar with no success.

    See the attached
    Thanks for posting this Mike, I poked around with it and we might be able to make this work with some tweaks. The biggest one I see right off the bat is where it has Employee at the top with a combo box. I'd need to change that (and it's function) to become the Event. Everything we do is event centric, so we need to see the see all the employees assigned to that Event. As it is now, it shows the Employee and an employee can not have an appointment at the same time on the same day.

    Hopefully that made sense.

    Oh, I'm going on vacation until Tuesday, so I may not reply for a few days on this.

  14. #14
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,330
    It would be the same one. The design should provide a template for making an event the entity instead of an employee. Just a guess.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  15. #15
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    429
    Hi

    The Calendar I uploaded contains a lot of VB Code

    In order not to break any of the Code I left the names of the table the same.

    All you need to do is change the Label from Employee to Event for the Combobox

    The Contents of tblEmployees is actually a list of your Events

Page 1 of 3 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Using access to schedule help
    By scoobz1234 in forum Access
    Replies: 11
    Last Post: 02-23-2018, 02:05 PM
  2. MS Access Personal Finance Budget Template
    By Kaloyanides in forum Access
    Replies: 0
    Last Post: 01-28-2015, 08:09 AM
  3. Replies: 6
    Last Post: 07-13-2014, 07:12 PM
  4. Replies: 7
    Last Post: 01-21-2014, 11:35 AM
  5. Time Schedule display in access
    By snoopy2003 in forum Database Design
    Replies: 3
    Last Post: 03-23-2011, 04:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums