Resort Table After Append - VBA

[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...

 

[Guest]

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?

 

[aaron.kempf]

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