Page 3 of 3 FirstFirst 123
Results 31 to 40 of 40
  1. #31
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815

    Composite or compound - synonymous.

    Boris Karloff and Bela Lugosi do not have data in Organization field in tblPersonnel. They are in tblAttendance but because Query2 filters by Organization, they do not show in query. Fix data in tblPersonnel
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  2. #32
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    [code]
    Boris Karloff and Bela Lugosi do not have data in Organization field in tblPersonnel. They are in tblAttendance but because Query2 filters by Organization, they do not show in query. Fix data in tblPersonnel
    [/[code]

    Please elaborate on this.

    Any help appreciated. Thanks in advance.

  3. #33
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Elaborate what? Put data in Organization field in tblPersonnel.

    As you said, Bela Lugosi and Boris Karloff records are in tblAttendance. However, Query2 excludes them because of filter.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #34
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, thanks I will try it.

    Thanks for your input.

    Respectfully,

    Lou Reed

  5. #35
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, I have made a composite key and it seems to work. It works in a way that seems to disallow what I want to do (adding the same personnel on the same date), but it will not give an error.

    All it does when I select a date that has been previously selected with the same personnel, is it fills up sfrmAttendance the previous (first iteration meeting) information. That is all that it does. By default you cannot
    put more in. There is no error message. It is like that is the meeting info so let it alone.

    Is this what is supposed to happen when you create a composite indexed key and try and load the same meetingdate/personnel back into frmAttendance.

    I think it is working. It does give not an error. It does just will not allow one to do the same operation again.

    Respectfully,

    Lou Reed
    Last edited by Lou_Reed; 05-26-2017 at 01:28 PM.

  6. #36
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    If you want to allow personnel to have multiple meetings on the same date, then you need to list multiple meetings for the same date in the combobox. The choices in the combobox list would be like:
    ID Description MtgDateTime
    1 Sales Review 5/23/2017 10:00:00 AM
    2 Budget Review 5/23/2017 2:00:00 PM
    3 Orientation 5/24/2017 8:00:00 AM
    Which means you need those meeting records in tblMeetings. Add a Description field to tblMeetings.

    Otherwise, remove the compound index and allow duplicate records in tblAttendance, which makes no sense to me but go ahead and try it and see if you like it.

    Also, if you want to save Organization ID into tblPersonnel, then Organization field in tblPersonnel needs to be number Long not text.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #37
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I think that it works. It will not allow the same people from a group to be added to the same meeting twice. That is what I want.

    So unless I detect something else, I will keep it the way it is.

    Respectfully,

    Lou Reed

  8. #38
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Okay, I misread post 35. I thought you were not satisfied with use of the compound index but I see now you were just describing the behavior for confirmation. Yes, that is what the compound index should accomplish.

    Glad we got a solution.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #39
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    In Post #2 you state that the form. frmAttendance, was not loading from tblAttendance, but from Query2. Also, that Query2 had a filter that retrieves only the records that have a meeting data that is selected in the combo box. Is this criterion determined in the Where clause of the query design? In other words that filter limits the records to only that query that had the meeting date selected.

    I just need to know this because as of now that form, formAttendance. is loading from tblPersonnel with no criteria to restrict records to a specific meeting data. I need to correct this.

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed

  10. #40
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I believe that what you meant to say was that sfrmAttendance is loading Query2. That I can see. I need to reword my question. Although Query2 only allows records associated with a certain date to loaded it does
    not load from tblAttendance. Form, tblattendance does not load from Query2 instead it loads from tblAttendance.

    My question is in the tblAttendance, the records kept are for all meeting selected not just the meetings that a Branchhead noted each branch member whether they were present or absent. The meetings in which the status is NA, have not happened yet so they need not be listed in the tblAttendance. Their absence indicated that the meeting is yet t happen. N how do I achieve this?

    I want in tblAttendnace only the meetings that have occurred in which attendance was recorded. How can I do that?

    I already set a composite index to prevent repetitive meeting info on the same date from being in tblAttendance.. That works. I just need to get rid of the meeting that have not occurred yet.

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed

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

Similar Threads

  1. Query entire table at once
    By Little in forum Queries
    Replies: 9
    Last Post: 09-01-2016, 05:20 PM
  2. Update and Append Entire table in Access
    By Yoyo120 in forum Access
    Replies: 1
    Last Post: 06-05-2014, 02:42 PM
  3. Insert entire row from query into new row in another table
    By chris.williams in forum Programming
    Replies: 3
    Last Post: 10-13-2011, 01:38 PM
  4. Replies: 1
    Last Post: 07-21-2010, 07:27 AM
  5. How to loop code to run through entire table
    By kmajors in forum Reports
    Replies: 9
    Last Post: 04-23-2010, 09:27 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