Resort Table After Append - VBA

  • Thread starter Thread starter hmiller
  • Start date Start date
H

hmiller

Hey Folks,

How can I re-sort a table using DAO VBA after an append? My first
column, "Age", is appended to every couple hours and I have to manually
re-sort the thing every time. Any suggestions would be great.

Also, does any one know of a good place to learn about efficeint vba
code and Database design. I'm am some what new to this stuff and now
that I can write VBA off the top of my head I'm wondering if there is
an efficeint way to structure or write my code.

Thanks Much...
 
Why a manual resort? Why not just have it sorted in your query, form or
report?

Or are you using the datasheet view of the table?
 
you don't need to worry about the sort order in a table; you just need
to sort it on your query.

on the other hand; if you used 'Access Data Proejcts' then you could
just use a real 'clustered index' that would really specify which way
you physically sort the data.

-Aaron
 
Back
Top