Results 1 to 5 of 5
  1. #1
    kariyerin is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    2

    what should I do ıf there are huge data set on a table but ıt does not show


    hi everyone I am a very new user access and here
    I have a 14155 data on a table at access but ıt does not show on registration ribbon what it is. ıt shows 14122 How I can manage it

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    What is 'registration ribbon'?

    You are not seeing record number 14155 or you are not seening 14,155 records?
    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.

  3. #3
    kariyerin is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    2
    Quote Originally Posted by June7 View Post
    What is 'registration ribbon'?

    You are not seeing record number 14155 or you are not seening 14,155 records?
    registration ribbon is on an access table on the left at the bottom. ıt shows number which are data on a table.
    I can see 14155 records on table. but ıt is shown on 14122 which I call it registration ribbon section. How I can make it improve.

  4. #4
    SteveH2508 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Chelsea, London, England
    Posts
    117
    Complete SWAG here - OP is seeing 14122 records in the Record Navigation bit at the bottom. He has an Autonumber field in the table and the highest number is 14155 because of aborted records etc...

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Agree with SteveH, most likely situation. The number of records does not always agree with the max record number. Any time a record is initiated by entering data in any field, the autonumber commits the next number, even if the entry is canceled, the number has been committed and will not be reused.
    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.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-13-2012, 02:41 PM
  2. Replies: 1
    Last Post: 01-23-2012, 11:54 PM
  3. Show data not in table A using multiple fields
    By mikesmith01 in forum Access
    Replies: 3
    Last Post: 02-25-2011, 08:38 AM
  4. Show data from table on screen.
    By Sharkun in forum Forms
    Replies: 1
    Last Post: 12-27-2010, 12:36 PM
  5. Data won't show up in table field
    By texzen123 in forum Forms
    Replies: 3
    Last Post: 11-26-2009, 11:20 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