Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    ??? Why not a field in the table indicating IsAdmin?



    Do you have a list of specifications or requirements?
    I think there are some data structure issues, but I don't know the details of what you are doing.

    Sorry if I am confusing your issue, but its like trying to solve a specific point while guessing at the requirement.

  2. #17
    Daisy509th's Avatar
    Daisy509th is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    Central Texas
    Posts
    51
    Orange,

    The database is to track safety points through the quarters and year. Now, my company thought it to be a good idea to change the quarters in the year so our quarters goes as follows:
    qtr1 = Dec, Jan, and Feb
    qtr2= Mar, Apr, and May
    qtr3 = Jun, Jul, and Aug
    qtr4 = Sep, Oct, and Nov

    At the beginning of each quarter the teams receive 100 points so a total of 400 points for the year then the teams can gain or lose points along the way

    So I need the ability to see the points for any given period of time
    For individual quarters
    For the whole year

    I also need to be able to assign actions to teams or team members(So we have a list of actions that are worth point or loses you points)
    I need to be able to see actions commit by teams and team members

    I also need to see the teams by division
    Need to be able to see teams and members
    I need to be able to assign and unassign team members to teams

    I need to be able to add Team and retire teams

  3. #18
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Is this a new database or is it in production / operation?

    During the year Points are assigned(+/-) to Team?

    If a Team member can be moved from Team to Team, would his/her Points move with him/her or remain with the Team (that he/her was part of when points assigned)?

    You don't need to see Points by Team Member?

    Each Action has some point value.
    Every Team member is Employed?
    How do you get to your form frmEmpAssign? It's looking for FirstName <>"Team" and Employed <>"Yes"
    so how does an Employee get Employed="No" for example.


    What info is associated with the Team Admin?
    Just some first thoughts.

  4. #19
    Daisy509th's Avatar
    Daisy509th is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    Central Texas
    Posts
    51
    Its a new database
    If a team member moved the points would stay with team
    Yes just missed that but need to see team member points also
    The tblActions have the actions in it and what they are worth
    Employed could have been removed and new. I just use employed to be able to switch teams if necessary. I also use it for those team members who have been fire quit or just left the company.
    So you get a no for one of those last things

    Point adjustments and team meeting points are associated with Team Admin

    Thanks

  5. #20
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Daisy,

    Don't know where you are at with the dB, but I played around with it. I made a lot of changes - mostly converted the macros to code and renamed the controls with more descriptive names. I also renamed the PK/FK fields in the tables. I am not crazy about having TEXT PK field types.... but I left it the way it was..

    Click image for larger version. 

Name:	qry1.png 
Views:	9 
Size:	18.1 KB 
ID:	33244
    For the form "frmEmpAssign", the TEAM combo box has/had the wrong row source. The table "tblEmployees" is what is limiting the Team names to 2 (in this case).
    I created a new query named "qryTeamList" for the combo box row source.

    Read all of the posts, but can't tell if there are other problems....
    Attached Files Attached Files

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update Combobox List from another value
    By Joakim N in forum Access
    Replies: 7
    Last Post: 10-12-2016, 11:19 AM
  2. Limit Combobox list
    By gw2013 in forum Forms
    Replies: 21
    Last Post: 11-26-2015, 12:09 PM
  3. Combobox list does not match query
    By tcox in forum Access
    Replies: 5
    Last Post: 11-20-2015, 10:41 AM
  4. Change Combobox list after use it
    By TesZero in forum Programming
    Replies: 4
    Last Post: 07-22-2014, 02:14 AM
  5. How to select ComboBox list in Run time
    By sdondeti in forum Forms
    Replies: 2
    Last Post: 06-20-2011, 10:21 AM

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