Results 1 to 15 of 15
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    What is wrong with the form?

    In the attached db file, I have a problem in that when I open the form frmEmail; the form opens blank, just white. I am not sure why, I thought it was because there was no data


    in its record source query and the query's two supporting tables, but that cannot be correct. The form should open for inputting that first piece of data.

    Please tell me what the problem is with the form frmEmail; it opening as a white sheet.

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed
    Attached Files Attached Files
    Last edited by Lou_Reed; 04-25-2017 at 11:13 AM. Reason: correction

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    The query the form is based on doesn't return any records, and doesn't allow new records. That will cause the form to open as it does.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, but does it not have to have a first record capability? The first time something is put in the form?

    How do I account for that?

    Respectfully,


    Lou Reed

  4. #4
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    Because you have inner joins to the tables on the many side of tblPersonnel - there are no records in tblAttendance.

    IF it is valid to have no attendance records, then make the joins to Include ALL records from 'tblPersonnel' and only those records from xyz where the joined fields are equal.

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I am familiar with the Allen Browne website. But not in this particular case. Please give me a more specific reference. This one is too general. I am lost.

    R,

    Lou Reed

  7. #7
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    I looked further at your database table design and UI, and believe that you should make a new thread in "Database Design" asking others to review your table structures, table fields, and UI - things aren't looking good. Off the top, tblPersonnel should hold all people data - no need to duplicate this in tblBranchID (tblBranches might be a better name). In tblBranches you would have BranchID (instead of "tblBranch" and "Branch_ID"), and then PersonnelID from tblPersonnel. In tblPersonnel, no need to store [FullName] as that can always be obtained by joining [FirstName] and [LastName].

    A great way to start the thread is to outline the processes the database is attempting to automate, and post the latest copy of your DB.

  8. #8
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I see your point on the tblBranches is not good. It is clearly unneeded. It can merge into tblPersonnel. There would be a few changes in tblPersonnel and that would be it.

    Thanks for your input. Please understand this is my first db and I inherited this from someone else who has since left our group.

    Respectfully,

    Loiu Reed

  9. #9
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Code:
    IF it is valid to have no attendance records, then make the joins to Include ALL records from 'tblPersonnel' and only those records from xyz where the joined fields are equal.
    Could elaborate on this point. I am still, not clear on what you said.

    Any references would also be good.

    Respectfully,

    Lou Reed

  10. #10
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I made the corrections suggested in Post #7. They were ones that I already was concerned about.

    I need some kind of answer to post or question #9. It seems that the form should be open and viewable even if there are no records in tblAttendence.

    As I said there is always a first time. Please expand on your answer.

    Any help appreciated.


    Respectfully,


    Lou Reed

  11. #11
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, I got it. No need to expand on your answer.

    Respectfully,

    Lou Reed

  12. #12
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    What is an ambiguous outer join?

    In the file attached, I created a new query qryPersonnelMeeting. When I tried to run it, the program said that it could not be run because it contains ambiguous outer joins.

    I am not sure exactly what it asked me to do to fix this. It was something about create one query first and then used that in a second query. I am not sure what error message is talking about.

    If you run qryPersonneMeetingl then I am sure that you will get the same error. Please explain the error and explain the correction. What is an ambiguous outer join?

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed
    Attached Files Attached Files

  13. #13
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    What is an ambiguous outer join of tables? It is causing my db to crash on a query. How do I fix it?

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed

  14. #14
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  15. #15
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, but you see I am not completely sure what is an ambiguous join (whether inner or outer). It says create a query using two tables, and then create a second query using the first query and the one remaining table.

    That seems fine. But I have two tables to select and the one that is selected clearly affects the outcome. I am just trying to get three data tables on the same page. That is it.

    I can do as they say in the error. But isn't that dependent on how I build the first query and what table I select? Or does that not matter? Do I just pick one and get started?

    I put tblBranchID into tblPersonnel. I thus removed tblBranchID. I then made a few slight changes to tblPersonnel. The relationships diagram hardly changed. I am trying hard to find out how that changed
    the whole system enough to create an outer join ambiguity.

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA for search form - SQL wrong ?
    By Lukael in forum Programming
    Replies: 4
    Last Post: 02-04-2016, 12:44 AM
  2. Form Calculation is wrong!
    By Lou_Reed in forum Access
    Replies: 32
    Last Post: 08-04-2015, 02:16 PM
  3. Can not refresh a form - what am I doing wrong?
    By RedGoneWILD in forum Forms
    Replies: 9
    Last Post: 06-26-2012, 04:53 PM
  4. Form with Subreport Displaying Wrong
    By claysea in forum Forms
    Replies: 3
    Last Post: 02-14-2012, 03:25 PM
  5. Replies: 1
    Last Post: 09-30-2011, 06:54 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