Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Code to index a table (access 97)

    Does any one have some code that I can call or put on a button that would index a table? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Code to index a table (access 97)

    What do you mean by "index a table"? We used to apply indexes like mustard plasters in dBase, but Access doesn't work that way.

    Are you talking about creating indexes on a table? If so, that is something you do once in design view of the table. Or are you talking about sorting a table, or what?
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code to index a table (access 97)

    Sorry to be so vague Charlotte. I mean sorting a table. I'm importing a text file into a new access table and I would like to see if I can find some code to index or sort that table.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Code to index a table (access 97)

    Are you trying to control the order the records append in? If so, you can't, at least not without doing something exotic with recordsets, and there's no point anyhow since record order is meaningless in a relational database. You *can* create indexes from code, but all they do is speed up finds on a particular field. What exactly do you want to do and to what purpose are you trying to sort the data?
    Charlotte

Posting Permissions

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