By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

On my Form not all my database shows on the form view.

P: 34
I have everything setup in Access 2007. When I go to my form view, not all my database shows up. I feel there is a break somewhere but I am new to Access and need help.
Feb 2 '17 #1
Share this Question
Share on Google+
57 Replies


Seth Schrock
Expert 2.5K+
P: 2,930
You don't provide much information for us to go off of, but here are a few places to look.

Does your form have anything in its Filter property?
Is your form's Record Source a table or query or a SQL string?
If it is a query or a SQL string, is there a WHERE clause in either one?
While I'm guessing not, is there any code in the form's events (On_Load, On_Current, etc.) that could filter the results?
Feb 2 '17 #2

P: 34
Steve I am so new to this. It was created before I started to work here. It was working fine about 8 months but when we went to put a new contact in and save - It saved it to our database but will not show on the form
Feb 2 '17 #3

P: 34
Seth this is a query and on the form property sheet under event there is nothing in "on Current" or "on Load".
Feb 2 '17 #4

Seth Schrock
Expert 2.5K+
P: 2,930
Go into design view on the query and see if there is any criteria listed. Also, did you look in the form's Filter property?
Feb 2 '17 #5

P: 34
Seth is this on the property sheet of the form? I don't see them
Feb 2 '17 #6

Seth Schrock
Expert 2.5K+
P: 2,930
Yes, in the Data tab of the property sheet.
Feb 2 '17 #7

P: 34
I see no criteria field
Feb 2 '17 #8

Seth Schrock
Expert 2.5K+
P: 2,930
The form property is called Filter. In the query it is called criteria.
Feb 2 '17 #9

P: 34
ok I see Filter but where do I see query
Feb 2 '17 #10

Seth Schrock
Expert 2.5K+
P: 2,930
If you click inside the Record Source property, you should be able to click on the ellipsis button (three dots), which should open the query.
Feb 2 '17 #11

P: 34
Ok I see criteria and the line is blank
Feb 2 '17 #12

Seth Schrock
Expert 2.5K+
P: 2,930
Of course. That would be too easy :).

This is a bit of a stretch, but while looking at the query in design view, switch to SQL view (Design tab, far left button of the ribbon) and tell me if you see the word TOP right after the first word SELECT.

Also, switch back to design view on the query. How many tables are shown in the top part of the window?
Feb 2 '17 #13

P: 34
Top is not after select - in design view I have 5 tables on top part and 4 tables below them
Feb 2 '17 #14

Seth Schrock
Expert 2.5K+
P: 2,930
Ok. You say that the new contact did save in the database. Can you look for that record in the main table and see if there are any blank fields?
Feb 2 '17 #15

P: 34
Ok it is in my main 1 st box contact information but not in my database
Feb 2 '17 #16

P: 34
I know I put it in the database. It is like it does not save
Feb 2 '17 #17

Seth Schrock
Expert 2.5K+
P: 2,930
Please explain more. What do you mean that it is in your main 1 st box contact information, but not the database.
Feb 2 '17 #18

P: 34
I put it in my database and saved. So when I closed out of access and went back in - it was not in my database but was in my table which is contact information.
Feb 3 '17 #19

Seth Schrock
Expert 2.5K+
P: 2,930
A database is "a structured set of data held in a computer, especially one that is accessible in various ways." So, if it is in the table, then it is in the database.

So again, if you look at the record in the table, are there any blank fields? What I'm driving at is that I'm guessing that there some records in one table that don't match up with records in a joined tabled in the query, resulting in your new contact not being returned. Please copy and paste the SQL code of your form's Record Source query into this thread using the [CODE/] tags (see the button at the top of the text entry box).
Feb 3 '17 #20

P: 34
Can you please call me at (pm with phone number)....Thanks Tami
Feb 3 '17 #21

P: 34
In all 9 of my tables I have different number of records. Should all tables be the same records number...Thanks Tami
Feb 3 '17 #22

Seth Schrock
Expert 2.5K+
P: 2,930
Sorry, I can't call. If you don't know how to do something, then you can ask and I'll try to step you through it here.
Feb 3 '17 #23

P: 34
Ok my 9 tables do not have the same record number. 1 as like 240 records and 1 as like 213 records. So is this my problem. Can you send me an attachment on how to past SQL I do not understand this.
Feb 3 '17 #24

Seth Schrock
Expert 2.5K+
P: 2,930
No, there doesn't need to be a matching number of records. What I'm referring to is the relationship between Primary Keys and Foreign Keys. For example, if you have a table for the contact's status (tblContactStatus) setup like the following:
Expand|Select|Wrap|Line Numbers
  1. tblContactStatus
  2. StatusId_pk   StatusName
  3. 1             New
  4. 2             Active
  5. 3             Archive
Then in your contacts table (I'll call it tblContacts)You have the matching foreign key field StatusId_fk:
Expand|Select|Wrap|Line Numbers
  1. tblContacts
  2. ContactId_pk   ContactName   StatusId_fk
  3. 1              Tami          2
  4. 2              Seth          2
  5. 3              Jane          3
  6. 4              Alex           
  7. 5              Joe           2
Notice how there are more contact records than status records. Also, how Alex doesn't have anything in the StatusId_fk field. Depending on how the join between the tables is setup in the query, Alex's record might not show up because there isn't a match in the tblContactStatus table.
Feb 3 '17 #25

Seth Schrock
Expert 2.5K+
P: 2,930
See post #13 where I had you look for the word TOP. Do the same thing and then select all the text and copy it (Ctrl + C). Then click the [CODE/] button here in the text entry box to add the code tags and then paste (Ctrl + V) the text inside the tags.
Feb 3 '17 #26

P: 34
ok so how do I do this...Where do I go to fix this.
Feb 3 '17 #27

Seth Schrock
Expert 2.5K+
P: 2,930
Once I have the SQL code, then I can instruct you how to find where the problem occurs.

Also, if you look at the record in the contact information table, are there any blank fields?
Feb 3 '17 #28

P: 34
I don't see the code/button in entry box
Feb 3 '17 #29

P: 34
Is the text entry box the box I just copied
Feb 3 '17 #30

P: 34
Expand|Select|Wrap|Line Numbers
  1. SELECT [Contact Information].ID, [Contact Information].[Year Entered or Updated], [Contact Information].Prefix
  2.          , [Contact Information].FName, [Contact Information].LName, [Contact Information].Address, [Contact Information].City
  3.          , [Contact Information].State, [Contact Information].[Zip Code], [Contact Information].Township, [Contact Information].Phone
  4.          , [Contact Information].[E-mail]
  5.    , [Personal Information].Male, [Personal Information].Female, [Personal Information].Ethnicity
  6.          , [Personal Information].[Under 25], [Personal Information].[25-35 yrs], [Personal Information].[36-45 yrs]
  7.          , [Personal Information].[46-55 yrs], [Personal Information].[56-65 yrs], [Personal Information].[66 yrs and up]
  8.          , [Personal Information].[Not Given]
  9.    , [Work Information].Employer, [Work Information].[Type of Business], [Work Information].[Position/Title]
  10.          , [Work Information].[Work Not Given]
  11.    , [Work/Professional Skills].Agriculture, [Work/Professional Skills].Business, [Work/Professional Skills].Clergy
  12.          , [Work/Professional Skills].Education, [Work/Professional Skills].Finance, [Work/Professional Skills].Fundraising
  13.          , [Work/Professional Skills].Government, [Work/Professional Skills].[Human Resources], [Work/Professional Skills].Legal
  14.          , [Work/Professional Skills].Nonprofit, [Work/Professional Skills].Other, [Work/Professional Skills].[Other Text]
  15.          , [Work/Professional Skills].[Work Skills Not Given]
  16.    , [Relevant Experience].[Nonprofit Board], [Relevant Experience].[RE Fundraising], [Relevant Experience].[Grant Writing]
  17.          , [Relevant Experience].[RE Other], [Relevant Experience].[Other Text]
  18.    , [Time to Give].[1-2 hrs], [Time to Give].[3-5 hrs]
  19.          , [Time to Give].[6+ hrs], [Time to Give].[Time Not Given]
  20.    , Notes.Notes
  21.    , [Areas of Expertise & Talent].Administration, [Areas of Expertise & Talent].[ET Agriculture]
  22.          , [Areas of Expertise & Talent].Audit, [Areas of Expertise & Talent].[Business Management]
  23.          , [Areas of Expertise & Talent].Construction, [Areas of Expertise & Talent].[ET Education]
  24.          , [Areas of Expertise & Talent].[Event Planning], [Areas of Expertise & Talent].[Facilities Maintenance]
  25.          , [Areas of Expertise & Talent].[ET Finance], [Areas of Expertise & Talent].[ET Grant Writing]
  26.          , [Areas of Expertise & Talent].Investment, [Areas of Expertise & Talent].IT, [Areas of Expertise & Talent].[ET Legal]
  27.          , [Areas of Expertise & Talent].Marketing, [Areas of Expertise & Talent].[Nonprofit Board Service]
  28.          , [Areas of Expertise & Talent].[Public Speaking], [Areas of Expertise & Talent].[Strategic Planning]
  29.          , [Areas of Expertise & Talent].[ET Other], [Areas of Expertise & Talent].[Other Text]
  30.          , [Areas of Expertise & Talent].[ET Not Given]
  31.    , [Areas of Interest].Activities, [Areas of Interest].[Addiction/Substance Abuse], [Areas of Interest].[AI Agriculture]
  32.          , [Areas of Interest].[Animal Welfare], [Areas of Interest].Arts, [Areas of Interest].[Child Abuse/Neglect]
  33.          , [Areas of Interest].[Conservation/Wildlife], [Areas of Interest].[Culture/Museum]
  34.          , [Areas of Interest].Daycare, [Areas of Interest].[Disaster Relief], [Areas of Interest].[Diversity]
  35.          , [Areas of Interest].[Domestic Violence/Abuse], [Areas of Interest].[Economic Development]
  36.          , [Areas of Interest].[AI Education], [Areas of Interest].[Elderly/Aged], [Areas of Interest].ESL
  37.          , [Areas of Interest].[Environment/Water Quality], [Areas of Interest].[Financial Literacy]
  38.          , [Areas of Interest].[Genealogy/Historic Preservation], [Areas of Interest].[AI Government], [Areas of Interest].[Grant Maker]
  39.          , [Areas of Interest].[Group Homes], [Areas of Interest].[Health/Wellness], [Areas of Interest].Healthcare
  40.          , [Areas of Interest].Homelessness, [Areas of Interest].[Hospice/Palliative], [Areas of Interest].Leadership
  41.          , [Areas of Interest].[Library Services], [Areas of Interest].Literacy, [Areas of Interest].[Low income housing]
  42.          , [Areas of Interest].[Mental Health], [Areas of Interest].Mentoring, [Areas of Interest].[Missions/Ministry/Outreach]
  43.          , [Areas of Interest].[Parks & Rec], [Areas of Interest].[Physical/Mental Disabilities]
  44.          , [Areas of Interest].[Poverty/Self-Sufficiency], [Areas of Interest].[Public Transportation]
  45.          , [Areas of Interest].[Teen Preg/Adoption], [Areas of Interest].Therapy, [Areas of Interest].Tolerance
  46.          , [Areas of Interest].Tourism, [Areas of Interest].[AI Other], [Areas of Interest].[Other Text]
  47.          , [Areas of Interest].[AI Not Given]
  48.    , [Relevant Experience].[RE Not Given]
  49.    , [Personal Information].Visionary, [Personal Information].[Strategic Thinker], [Personal Information].Entrepreneurial
  50.          , [Personal Information].[Detail Oriented], [Personal Information].[High Energy], [Personal Information].[Low Key]
  51.          , [Personal Information].[PC Other], [Personal Information].[Other Text], [Personal Information].[PC Not Given]
  52.    , [Areas of Expertise & Talent].[ET Not Used]
  53.    , [Relevant Experience].[RE Not Used]
  54.    , [Work/Professional Skills].[Skills Merged]
  55.    , [Personal Information].Male, [Personal Information].Female
  56. FROM ((((((([Contact Information] 
  57.    INNER JOIN [Areas of Expertise & Talent] ON [Contact Information].ID = [Areas of Expertise & Talent].ID) 
  58.    INNER JOIN [Areas of Interest] ON [Contact Information].ID = [Areas of Interest].ID) 
  59.    INNER JOIN Notes ON [Contact Information].ID = Notes.ID) 
  60.    INNER JOIN [Personal Information] ON [Contact Information].ID = [Personal Information].ID) 
  61.    INNER JOIN [Relevant Experience] ON [Contact Information].ID = [Relevant Experience].ID) 
  62.    INNER JOIN [Time to Give] ON [Contact Information].ID = [Time to Give].ID) 
  63.    INNER JOIN [Work Information] ON [Contact Information].ID = [Work Information].ID) 
  64.    INNER JOIN [Work/Professional Skills] ON [Contact Information].ID = [Work/Professional Skills].ID;
  65.  
Feb 3 '17 #31

Seth Schrock
Expert 2.5K+
P: 2,930
What I'm text entry box that I'm referring to is the one that you type your post in. Above that is a row of styling buttons (left align, center align, right align, number and dotted bullets, indents, bold, italics, underline, links, images and then the [CODE/] button. Just click the [CODE/] button and it will add the code tags to your post for you.
Feb 3 '17 #32

Seth Schrock
Expert 2.5K+
P: 2,930
Can you please confirm that the following are all tables and not other queries?
  • Contact Information
  • Areas of Expertise & Talent
  • Areas of Interest
  • Notes
  • Personal Information
  • Relevant Experience
  • Time to Give
  • Work Information
  • Work/Professional Skills
Feb 3 '17 #33

P: 34
on the left side box I have tables which have all these under then below that I have queries - where to find duplicates and then below that I have my form. So I would say these are tables
Feb 3 '17 #34

Seth Schrock
Expert 2.5K+
P: 2,930
Okay. I made a slight change to the query and I would like you to test it. In the ribbon bar, click the Create tab and then Query Design button (sixth button from the left). A box asking you to select a table should open. Just close out of that and then click the SQL button up in the ribbon bar (should be far left button). Delete the SELECT text that is prepopulated for you. The copy and and paste the following SQL code into the query and then run it. I don't think that there will be any errors, but I don't have a way to test it on my end. If it doesn't get any errors scroll through it and see if you find the missing contact.

Expand|Select|Wrap|Line Numbers
  1. SELECT [Contact Information].ID
  2. , [Contact Information].[Year Entered or Updated]
  3. , [Contact Information].Prefix
  4. , [Contact Information].FName
  5. , [Contact Information].LName
  6. , [Contact Information].Address
  7. , [Contact Information].City
  8. , [Contact Information].State
  9. , [Contact Information].[Zip Code]
  10. , [Contact Information].Township
  11. , [Contact Information].Phone
  12. , [Contact Information].[E-mail]
  13. , [Personal Information].Male
  14. , [Personal Information].Female
  15. , [Personal Information].Ethnicity
  16. , [Personal Information].[Under 25]
  17. , [Personal Information].[25-35 yrs]
  18. , [Personal Information].[36-45 yrs]
  19. , [Personal Information].[46-55 yrs]
  20. , [Personal Information].[56-65 yrs]
  21. , [Personal Information].[66 yrs and up]
  22. , [Personal Information].[Not Given]
  23. , [Work Information].Employer
  24. , [Work Information].[Type of Business]
  25. , [Work Information].[Position/Title]
  26. , [Work Information].[Work Not Given]
  27. , [Work/Professional Skills].Agriculture
  28. , [Work/Professional Skills].Business
  29. , [Work/Professional Skills].Clergy
  30. , [Work/Professional Skills].Education
  31. , [Work/Professional Skills].Finance
  32. , [Work/Professional Skills].Fundraising
  33. , [Work/Professional Skills].Government
  34. , [Work/Professional Skills].[Human Resources]
  35. , [Work/Professional Skills].Legal
  36. , [Work/Professional Skills].Nonprofit
  37. , [Work/Professional Skills].Other
  38. , [Work/Professional Skills].[Other Text]
  39. , [Work/Professional Skills].[Work Skills Not Given]
  40. , [Relevant Experience].[Nonprofit Board]
  41. , [Relevant Experience].[RE Fundraising]
  42. , [Relevant Experience].[Grant Writing]
  43. , [Relevant Experience].[RE Other]
  44. , [Relevant Experience].[Other Text]
  45. , [Time to Give].[1-2 hrs]
  46. , [Time to Give].[3-5 hrs]
  47. , [Time to Give].[6+ hrs]
  48. , [Time to Give].[Time Not Given]
  49. , Notes.Notes
  50. , [Areas of Expertise & Talent].Administration
  51. , [Areas of Expertise & Talent].[ET Agriculture]
  52. , [Areas of Expertise & Talent].Audit
  53. , [Areas of Expertise & Talent].[Business Management]
  54. , [Areas of Expertise & Talent].Construction
  55. , [Areas of Expertise & Talent].[ET Education]
  56. , [Areas of Expertise & Talent].[Event Planning]
  57. , [Areas of Expertise & Talent].[Facilities Maintenance]
  58. , [Areas of Expertise & Talent].[ET Finance]
  59. , [Areas of Expertise & Talent].[ET Grant Writing]
  60. , [Areas of Expertise & Talent].Investment
  61. , [Areas of Expertise & Talent].IT
  62. , [Areas of Expertise & Talent].[ET Legal]
  63. , [Areas of Expertise & Talent].Marketing
  64. , [Areas of Expertise & Talent].[Nonprofit Board Service]
  65. , [Areas of Expertise & Talent].[Public Speaking]
  66. , [Areas of Expertise & Talent].[Strategic Planning]
  67. , [Areas of Expertise & Talent].[ET Other]
  68. , [Areas of Expertise & Talent].[Other Text]
  69. , [Areas of Expertise & Talent].[ET Not Given]
  70. , [Areas of Interest].Activities
  71. , [Areas of Interest].[Addiction/Substance Abuse]
  72. , [Areas of Interest].[AI Agriculture]
  73. , [Areas of Interest].[Animal Welfare]
  74. , [Areas of Interest].Arts
  75. , [Areas of Interest].[Child Abuse/Neglect]
  76. , [Areas of Interest].[Conservation/Wildlife]
  77. , [Areas of Interest].[Culture/Museum]
  78. , [Areas of Interest].Daycare
  79. , [Areas of Interest].[Disaster Relief]
  80. , [Areas of Interest].Diversity
  81. , [Areas of Interest].[Domestic Violence/Abuse]
  82. , [Areas of Interest].[Economic Development]
  83. , [Areas of Interest].[AI Education]
  84. , [Areas of Interest].[Elderly/Aged]
  85. , [Areas of Interest].ESL
  86. , [Areas of Interest].[Environment/Water Quality]
  87. , [Areas of Interest].[Financial Literacy]
  88. , [Areas of Interest].[Genealogy/Historic Preservation]
  89. , [Areas of Interest].[AI Government]
  90. , [Areas of Interest].[Grant Maker]
  91. , [Areas of Interest].[Group Homes]
  92. , [Areas of Interest].[Health/Wellness]
  93. , [Areas of Interest].Healthcare
  94. , [Areas of Interest].Homelessness
  95. , [Areas of Interest].[Hospice/Palliative]
  96. , [Areas of Interest].Leadership
  97. , [Areas of Interest].[Library Services]
  98. , [Areas of Interest].Literacy
  99. , [Areas of Interest].[Low income housing]
  100. , [Areas of Interest].[Mental Health]
  101. , [Areas of Interest].Mentoring
  102. , [Areas of Interest].[Missions/Ministry/Outreach]
  103. , [Areas of Interest].[Parks & Rec]
  104. , [Areas of Interest].[Physical/Mental Disabilities]
  105. , [Areas of Interest].[Poverty/Self-Sufficiency]
  106. , [Areas of Interest].[Public Transportation]
  107. , [Areas of Interest].[Teen Preg/Adoption]
  108. , [Areas of Interest].Therapy
  109. , [Areas of Interest].Tolerance
  110. , [Areas of Interest].Tourism
  111. , [Areas of Interest].[AI Other]
  112. , [Areas of Interest].[Other Text]
  113. , [Areas of Interest].[AI Not Given]
  114. , [Relevant Experience].[RE Not Given]
  115. , [Personal Information].Visionary
  116. , [Personal Information].[Strategic Thinker]
  117. , [Personal Information].Entrepreneurial
  118. , [Personal Information].[Detail Oriented]
  119. , [Personal Information].[High Energy]
  120. , [Personal Information].[Low Key]
  121. , [Personal Information].[PC Other]
  122. , [Personal Information].[Other Text]
  123. , [Personal Information].[PC Not Given]
  124. , [Areas of Expertise & Talent].[ET Not Used]
  125. , [Relevant Experience].[RE Not Used]
  126. , [Work/Professional Skills].[Skills Merged]
  127. FROM ((((((([Contact Information] LEFT JOIN [Areas of Expertise & Talent] ON [Contact Information].ID = [Areas of Expertise & Talent].ID) 
  128.     RIGHT JOIN [Areas of Interest] ON [Contact Information].ID = [Areas of Interest].ID) 
  129.     RIGHT JOIN Notes ON [Contact Information].ID = Notes.ID) 
  130.     RIGHT JOIN [Personal Information] ON [Contact Information].ID = [Personal Information].ID) 
  131.     RIGHT JOIN [Relevant Experience] ON [Contact Information].ID = [Relevant Experience].ID) 
  132.     RIGHT JOIN [Time to Give] ON [Contact Information].ID = [Time to Give].ID) 
  133.     RIGHT JOIN [Work Information] ON [Contact Information].ID = [Work Information].ID) 
  134.     RIGHT JOIN [Work/Professional Skills] ON [Contact Information].ID = [Work/Professional Skills].ID;
Feb 3 '17 #35

P: 34
How do I copy out of the box you sent me
Feb 3 '17 #36

P: 34
Ok a box came up after I it Run! and it said JOIN expression not supported
Feb 3 '17 #37

Seth Schrock
Expert 2.5K+
P: 2,930
Okay, try this query:
Expand|Select|Wrap|Line Numbers
  1. SELECT [Contact Information].ID
  2. , [Contact Information].[Year Entered or Updated]
  3. , [Contact Information].Prefix
  4. , [Contact Information].FName
  5. , [Contact Information].LName
  6. , [Contact Information].Address
  7. , [Contact Information].City
  8. , [Contact Information].State
  9. , [Contact Information].[Zip Code]
  10. , [Contact Information].Township
  11. , [Contact Information].Phone
  12. , [Contact Information].[E-mail]
  13. , [Personal Information].Male
  14. , [Personal Information].Female
  15. , [Personal Information].Ethnicity
  16. , [Personal Information].[Under 25]
  17. , [Personal Information].[25-35 yrs]
  18. , [Personal Information].[36-45 yrs]
  19. , [Personal Information].[46-55 yrs]
  20. , [Personal Information].[56-65 yrs]
  21. , [Personal Information].[66 yrs and up]
  22. , [Personal Information].[Not Given]
  23. , [Personal Information].Visionary
  24. , [Personal Information].[Strategic Thinker]
  25. , [Personal Information].Entrepreneurial
  26. , [Personal Information].[Detail Oriented]
  27. , [Personal Information].[High Energy]
  28. , [Personal Information].[Low Key]
  29. , [Personal Information].[PC Other]
  30. , [Personal Information].[Other Text]
  31. , [Personal Information].[PC Not Given]
  32. , [Work Information].Employer
  33. , [Work Information].[Type of Business]
  34. , [Work Information].[Position/Title]
  35. , [Work Information].[Work Not Given]
  36. , [Work/Professional Skills].Agriculture
  37. , [Work/Professional Skills].Business
  38. , [Work/Professional Skills].Clergy
  39. , [Work/Professional Skills].Education
  40. , [Work/Professional Skills].Finance
  41. , [Work/Professional Skills].Fundraising
  42. , [Work/Professional Skills].Government
  43. , [Work/Professional Skills].[Human Resources]
  44. , [Work/Professional Skills].Legal
  45. , [Work/Professional Skills].Nonprofit
  46. , [Work/Professional Skills].Other
  47. , [Work/Professional Skills].[Other Text]
  48. , [Work/Professional Skills].[Work Skills Not Given]
  49. , [Work/Professional Skills].[Skills Merged]
  50. , [Relevant Experience].[Nonprofit Board]
  51. , [Relevant Experience].[RE Fundraising]
  52. , [Relevant Experience].[Grant Writing]
  53. , [Relevant Experience].[RE Other]
  54. , [Relevant Experience].[Other Text]
  55. , [Relevant Experience].[RE Not Used]
  56. , [Relevant Experience].[RE Not Given]
  57. FROM (((([Contact Information] INNER JOIN [Personal Information] ON [Contact Information].ID = [Personal Information].ID)
  58.     INNER JOIN [Work Information] ON [Contact Information].ID = [Work Information].ID) 
  59.     INNER JOIN [Work/Professional Skills] ON [Contact Information].ID = [Work/Professional Skills].ID)
  60.     INNER JOIN [Relevant Experience] ON [Contact Information].ID = [Relevant Experience].ID)
This should run. If it does, see if your missing contact is shown. Not all the fields will be displayed, but it will help me to troubleshoot what is happening.

Then try this query:
Expand|Select|Wrap|Line Numbers
  1. SELECT [Contact Information].ID
  2. , [Contact Information].[Year Entered or Updated]
  3. , [Contact Information].Prefix
  4. , [Contact Information].FName
  5. , [Contact Information].LName
  6. , [Contact Information].Address
  7. , [Contact Information].City
  8. , [Contact Information].State
  9. , [Contact Information].[Zip Code]
  10. , [Contact Information].Township
  11. , [Contact Information].Phone
  12. , [Contact Information].[E-mail]
  13. , [Time to Give].[1-2 hrs]
  14. , [Time to Give].[3-5 hrs]
  15. , [Time to Give].[6+ hrs]
  16. , [Time to Give].[Time Not Given]
  17. , Notes.Notes
  18. , [Areas of Expertise & Talent].Administration
  19. , [Areas of Expertise & Talent].[ET Agriculture]
  20. , [Areas of Expertise & Talent].Audit
  21. , [Areas of Expertise & Talent].[Business Management]
  22. , [Areas of Expertise & Talent].Construction
  23. , [Areas of Expertise & Talent].[ET Education]
  24. , [Areas of Expertise & Talent].[Event Planning]
  25. , [Areas of Expertise & Talent].[Facilities Maintenance]
  26. , [Areas of Expertise & Talent].[ET Finance]
  27. , [Areas of Expertise & Talent].[ET Grant Writing]
  28. , [Areas of Expertise & Talent].Investment
  29. , [Areas of Expertise & Talent].IT
  30. , [Areas of Expertise & Talent].[ET Legal]
  31. , [Areas of Expertise & Talent].Marketing
  32. , [Areas of Expertise & Talent].[Nonprofit Board Service]
  33. , [Areas of Expertise & Talent].[Public Speaking]
  34. , [Areas of Expertise & Talent].[Strategic Planning]
  35. , [Areas of Expertise & Talent].[ET Other]
  36. , [Areas of Expertise & Talent].[Other Text]
  37. , [Areas of Expertise & Talent].[ET Not Given]
  38. , [Areas of Expertise & Talent].[ET Not Used]
  39. , [Areas of Interest].Activities
  40. , [Areas of Interest].[Addiction/Substance Abuse]
  41. , [Areas of Interest].[AI Agriculture]
  42. , [Areas of Interest].[Animal Welfare]
  43. , [Areas of Interest].Arts
  44. , [Areas of Interest].[Child Abuse/Neglect]
  45. , [Areas of Interest].[Conservation/Wildlife]
  46. , [Areas of Interest].[Culture/Museum]
  47. , [Areas of Interest].Daycare
  48. , [Areas of Interest].[Disaster Relief]
  49. , [Areas of Interest].Diversity
  50. , [Areas of Interest].[Domestic Violence/Abuse]
  51. , [Areas of Interest].[Economic Development]
  52. , [Areas of Interest].[AI Education]
  53. , [Areas of Interest].[Elderly/Aged]
  54. , [Areas of Interest].ESL
  55. , [Areas of Interest].[Environment/Water Quality]
  56. , [Areas of Interest].[Financial Literacy]
  57. , [Areas of Interest].[Genealogy/Historic Preservation]
  58. , [Areas of Interest].[AI Government]
  59. , [Areas of Interest].[Grant Maker]
  60. , [Areas of Interest].[Group Homes]
  61. , [Areas of Interest].[Health/Wellness]
  62. , [Areas of Interest].Healthcare
  63. , [Areas of Interest].Homelessness
  64. , [Areas of Interest].[Hospice/Palliative]
  65. , [Areas of Interest].Leadership
  66. , [Areas of Interest].[Library Services]
  67. , [Areas of Interest].Literacy
  68. , [Areas of Interest].[Low income housing]
  69. , [Areas of Interest].[Mental Health]
  70. , [Areas of Interest].Mentoring
  71. , [Areas of Interest].[Missions/Ministry/Outreach]
  72. , [Areas of Interest].[Parks & Rec]
  73. , [Areas of Interest].[Physical/Mental Disabilities]
  74. , [Areas of Interest].[Poverty/Self-Sufficiency]
  75. , [Areas of Interest].[Public Transportation]
  76. , [Areas of Interest].[Teen Preg/Adoption]
  77. , [Areas of Interest].Therapy
  78. , [Areas of Interest].Tolerance
  79. , [Areas of Interest].Tourism
  80. , [Areas of Interest].[AI Other]
  81. , [Areas of Interest].[Other Text]
  82. , [Areas of Interest].[AI Not Given]
  83. FROM (((([Contact Information] INNER JOIN [Areas of Expertise & Talent] ON [Contact Information].ID = [Areas of Expertise & Talent].ID)
  84.     INNER JOIN [Time to Give] ON [Contact Information].ID = [Time to Give].ID) 
  85.     INNER JOIN Notes ON [Contact Information].ID = Notes.ID) 
  86.     INNER JOIN [Areas of Interest] ON [Contact Information].ID = [Areas of Interest].ID)
Let me know what happens.
Feb 4 '17 #38

P: 34
Ok no errors just my database came up now. What do I do now.

Thanks Tami
Feb 6 '17 #39

Seth Schrock
Expert 2.5K+
P: 2,930
Did your record appear in either query?
Feb 6 '17 #40

P: 34
Yes they did all of them
Feb 6 '17 #41

Seth Schrock
Expert 2.5K+
P: 2,930
Your missing record? That is very odd that it would appear in these but not your form. Try opening your form's query again and run it and see if your missing record is there.
Feb 6 '17 #42

P: 34
No I am not missing any records...This is perfect. I am still at my database do I go back to my form. Will I loose this database
Feb 6 '17 #43

Seth Schrock
Expert 2.5K+
P: 2,930
Well, neither query is the full query that you need and you can always recreate these queries so losing them doesn't matter. Just open your form in design view, click on the ellipsis button in the form's Record Source property and then click Run and see if your missing record is there.
Feb 6 '17 #44

P: 34
Ok when I am putting in a new contact I get to add but When I go to check the different infor in tables on the form it will not check them.

It did add my new contact
Feb 6 '17 #45

Seth Schrock
Expert 2.5K+
P: 2,930
Define "will not check them". I'm not sure what you mean.

Did you do what I asked in my previous post?
Feb 6 '17 #46

P: 34
I did what you wanted me to do in design form. I ran it and all records were there none missing. On my form I have check boxes we use to search for different skillsets, Area Interest and time and etc.

When I added the new contact, it would not let me check my boxes?
Feb 6 '17 #47

P: 34
Seth it will not add my new contact either
Feb 6 '17 #48

P: 34
Any new information to help...thanks tami
Feb 7 '17 #49

Seth Schrock
Expert 2.5K+
P: 2,930
So your original missing contact is now shown, but when you try to add another one, it is missing now. Is this correct?

Are you still having issues with the checkboxes?
Feb 7 '17 #50

57 Replies

Post your reply

Sign in to post your reply or Sign up for a free account.