Records Order

  • Thread starter Thread starter Richard Shaw
  • Start date Start date
R

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?
 
Richard Shaw said:
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?
Click to expand...

Are you using the table or a query? If you use a query with an OrderBy clause it
should work.
 
-----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
Click to expand...
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?
 
Back
Top