Results 1 to 5 of 5
  1. #1
    Sensenoy is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2018
    Posts
    2

    Record counter at bottom of table doesn't increase as records are added

    Hi everyone,



    I'm a complete beginner at this so I'm sorry if this is a stupid question.

    I'm currently moving records from one table to another and have noticed that when I add new records the record counter at the bottom of the screen doesn't increase, (eg: record 1 of 995 add 20 records still reads 1 of 995).

    Strangely if I remove records the record counter goes down. Any ideas?

    Thanks in advance,

    Sen

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    All depends how you are adding the records. I suspect your table is open in a separate window and you are using an append query in another window, so you need to refresh the table window (i.e. close and reopen) after the append as run.

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    If you are adding the records via VBA, add this code after the addition code:
    Code:
        DoCmd.SelectObject acTable, "MyTable"
        DoCmd.Requery

  4. #4
    Sensenoy is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2018
    Posts
    2
    Thanks for the help guys, this may make sense to you but I realised if I had the add new record line highlighted then the records were added to the table, if I highlighted the whole table it added the records but removed the same amount of records from the table.

    The table has about 24,000 entries and I've been doing it for some time... guess I better start working out what's missing...

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    you should not be working with tables directly once an app goes live - use forms, queries and vba

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

Similar Threads

  1. Replies: 6
    Last Post: 04-22-2018, 03:24 PM
  2. Increase counter when same product given
    By shod90 in forum Forms
    Replies: 4
    Last Post: 03-19-2017, 08:15 AM
  3. Replies: 9
    Last Post: 10-25-2014, 04:09 PM
  4. Replies: 3
    Last Post: 04-23-2014, 12:19 PM
  5. Replies: 1
    Last Post: 02-16-2013, 11:36 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