Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Anyone know the solution for this one?

    I'm using:

    CurrentDb.TableDefs(1).Properties(12).Value = "[Entered]"

    The above being an attempt to change the Order BY property of the first Table in an access database.

    I've cycled through all of the properties Via Reference (by Changing 12 Above) but can't seem to find "OrderBy" it does however appear in the Properties sheet in Design view for the Table.

    Any Clues out there. Thank_you

  2. #2
    Platinum Lounger
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    3,619
    Thanks
    7
    Thanked 231 Times in 219 Posts
    The database is not ordered, the results are/can be.
    Are you trying to return results in a particular order or re-structure the database?

    cheers, Paul

  3. #3
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks For your input.

    I've found a work around that does not involve setting the search order of the underlying table on the form. IE the form will happily hold the table format as I want it if there are no Indexes.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    3,619
    Thanks
    7
    Thanked 231 Times in 219 Posts
    You should always have an index field, even if it's only auto number. You never know when you may need to reference your data.

    cheers, Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •