Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    mugwione19 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    7

    Unhappy Add records to a table

    I have a database with multiple tables that I inherited from the previous person doing my job. The table in question is church attenders, fields - Name, Spouse Name, Address, City, State, Zip and E-mail address. Currently the table has 84 entries, I have at least 16 more to add to the table. I add them, can print them. When I close out of the database and then open at another time, those records are not saved in the table? Oh, and I consider myself a """"NEWBIE""" at Access! Thanks in advance!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    IF you added the data via a form, then the form MUST be connected to the table.
    if you added straight to the table , then it is saved. It is automatic. It would not delete them.

    make sure you don't have a filter on to 'hide' new data.

  3. #3
    mugwione19 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    7
    Did you happen to see the newbie statement?

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Explain the steps you do to get to the point where you can add the records to the table.

  5. #5
    mugwione19 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    7
    I am in the table. I am at the last row and I add a record, Joe Cindy Smythe 1237 Anywhere St Orlando FL 55555 joe@joe.com cindy@cindy.com, and so on and so forth.... Can see them, can print them, can export them. Close out of database. work on something else, 3 hours later go back into the database to that table and no Joe and Cindy Smythe????

  6. #6
    Cottonshirt is offline Competent Performer
    Windows 8 Access 2007
    Join Date
    Feb 2018
    Posts
    116
    we need you to clarify what you mean by, "3 hours later go back into the database to that table and no Joe and Cindy Smythe????"

    do you mean: I looked at the bottom of the table and they weren't there?

    or do you mean: I have rigourously investigated the entire table and they are definitely not in it?

    because one thought that occurs to me is that the table is indexed, which would mean that when you close it, and open it again, it opens in indexed order rather than in data entry order. that would mean Joe and Cindy will not be at the bottom, but probably under S for Smythe.


    many thanks,


    Cottonshirt

  7. #7
    mugwione19 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    7
    Prior to adding a record:

    After adding Record:

    After closing database and opening it back up:

  8. #8
    Cottonshirt is offline Competent Performer
    Windows 8 Access 2007
    Join Date
    Feb 2018
    Posts
    116
    those images are not visible. clicking on them returns the error: The requested URL's length exceeds the capacity limit for this server.



    Cottonshirt

  9. #9
    mugwione19 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    7
    I think I copied and pasted, sorry!Click image for larger version. 

Name:	db prior to add a record.png 
Views:	22 
Size:	7.6 KB 
ID:	41438 Click image for larger version. 

Name:	db after add a record.png 
Views:	22 
Size:	10.5 KB 
ID:	41439 Click image for larger version. 

Name:	reopened db table.png 
Views:	22 
Size:	11.1 KB 
ID:	41440

  10. #10
    CarlettoFed is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    255
    Attach a copy of the file and maybe you can understand the problem.

  11. #11
    mugwione19 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    7

    Table issue

    It is the curentexhaustivecongregatelist table. THE compete database is 10.5 mb!!! Won't upload the file size is restricted!

  12. #12
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Quote Originally Posted by mugwione19 View Post
    It is the curentexhaustivecongregatelist table. THE compete database is 10.5 mb!!! Won't upload the file size is restricted!
    Do a compact/repair then zip the DB file to reduce the size...

  13. #13
    mugwione19 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    7

    Thumbs up zipped file

    Quote Originally Posted by davegri View Post
    Do a compact/repair then zip the DB file to reduce the size...

    EFC Membership.zip I believe tha ti Have it xipped and attached?

  14. #14
    Cottonshirt is offline Competent Performer
    Windows 8 Access 2007
    Join Date
    Feb 2018
    Posts
    116
    I wasn't able to open your database, because ACCESS displayed the following error message:

    "Your Microsoft Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5. To ensure that your database or project works properly, you must fix this reference."


    there was a button labelled Help that displayed the following advice:

    "The application you are attempting to use has a reference that it cannot resolve to an object, type library, DLL, or external database. Either the object, type library, DLL, or database was deleted or renamed. Examine the Available references list in the References dialog box in the Visual Basic Editor ( Tools menu) to determine if any action is required. If you did not create this application, contact the programmer or administrator of the system.

    If the reference listed in the Available references list is preceded with "MISSING:" clear the check box to remove the reference if it is no longer required. If you still need to use the reference, clear the check box entry for "MISSING: <referencename>" in the Available references list, and then create a new reference to the file using the Browse... button. If this is an installed database application, you may need to reinstall or repair the application."


    "Examine the Available references list in the References dialog box in the Visual Basic Editor ( Tools menu) to determine if any action is required."

    to do this, follow these steps.

    1. with your databse open, on the ribbon, click: Create
    2. in the Macros & Code section, click: Visual Basic
    3. on the menu bar, Click: Tools
    4. Click: References

    this will show you a list of objects your database references. the one the error message referred to 'dao2535.tlb' will be in htere. follow the instructions in hte second half the Help Screen.


    good luck,



    Cottonshirt

  15. #15
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    curentexhaustivecongregatelist is a query (not a table) that is based on the membership table. Entering records in the query DOES update the table. The problem is, when you run the query 3 hours later (or 10 seconds later for that matter), it has criteria that restricts what records it can show.

    Click image for larger version. 

Name:	criteria.png 
Views:	15 
Size:	6.5 KB 
ID:	41443
    Last edited by davegri; 04-01-2020 at 08:14 PM.

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

Similar Threads

  1. Replies: 13
    Last Post: 05-10-2017, 12:43 AM
  2. Replies: 83
    Last Post: 11-29-2016, 09:38 AM
  3. Replies: 1
    Last Post: 12-20-2015, 01:09 PM
  4. Replies: 1
    Last Post: 10-07-2015, 11:33 AM
  5. Replies: 4
    Last Post: 07-14-2015, 06:49 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