Results 1 to 7 of 7
  1. #1
    scottjas is offline Novice
    Windows XP Access 2000
    Join Date
    Apr 2011
    Posts
    2

    how do you display forms numerically using id number

    I have been using access 2000 for some time now to record my cd collection. The forms were shown in numerical order, using "RecordingID" - AutoNumber (Data Type).

    Now the forms are being displayed in a random order. I must have unknowingly clicked on something.

    On investigation it appears that the records are being displayed in the order in which the artists were added to the Recording Artist Table.

    How do I get back to how it was?



    jim scott

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The RecordSource of your form should be a query with an OrderBy Clause.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    How do I get back to how it was?

    jim scott
    You might try looking in the menu bar under "Records". If the command "Remove Filter/Sort" is not grayed out, try clicking it.

  4. #4
    accesskid is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    17
    If it is the Primary key and the order has been changed, you may try firstly trying to compact and repair your database.

  5. #5
    scottjas is offline Novice
    Windows XP Access 2000
    Join Date
    Apr 2011
    Posts
    2
    thanks to all who have replied.
    ssanfu - tried your suggestion with no luck
    ruralguy - "The RecordSource of your form should be a query with an OrderBy Clause". Sorry my knowkledge is somewhat lacking. i don't know what you mean or how to carryout the suggestion.
    accesskid - the primary key has been allocated to RecordingID in the Recordings: Table. How do you compact and repair the database?

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Create a query of your table that sorts on the columns you want. Then assign that query as the RecordSource of your form.

  7. #7
    accesskid is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    17
    scottjas: simply click onto file on the ribbon and under information there is a choice to select compact and repair, make sure all your recent work is saved before hand so nothing is lost.

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

Similar Threads

  1. Replies: 1
    Last Post: 04-01-2011, 01:28 PM
  2. Code to display latest record number field created?
    By rowardHoark in forum Programming
    Replies: 1
    Last Post: 01-31-2011, 08:03 AM
  3. Changing information display method in forms
    By mrbaggins in forum Forms
    Replies: 5
    Last Post: 10-21-2010, 06:00 AM
  4. how to display a table into vba forms?
    By sunny in forum Access
    Replies: 1
    Last Post: 07-11-2010, 04:33 AM
  5. Replies: 3
    Last Post: 10-23-2009, 05:03 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