Records Order

[Richard Shaw]

I have several VB projects which link to Access databases.
Even though I sort the random records in Access by "Last
Name" and save it, the record order in VB is still the
original random order. I can change the order in VB with
the "Order by name" command in the SQL statement. But, is
there a way for the form load to accept the sorted Access
file?

 

[Rick Brandt]

I have several VB projects which link to Access databases.
Even though I sort the random records in Access by "Last
Name" and save it, the record order in VB is still the
original random order. I can change the order in VB with
the "Order by name" command in the SQL statement. But, is
there a way for the form load to accept the sorted Access
file?

Are you using the table or a query? If you use a query with an OrderBy clause it
should work.

 

[Richard Shaw]

-----Original Message-----


Are you using the table or a query? If you use a query with an OrderBy clause it
should work.

Thanks for your reply. I'm using a table, but in trying

to use your suggestion of using a query, I can't find the
right wording in my SQL to link with the query. Can you
suggest the proper wording?