I have a form which displays data in some form of table (not a datasheet).
When you double click a row it takes you to another form so it's activated somehow - what is that?
Anyway, this data can be sorted by clicking on the top row of any column and selecting ascend, etc.
The only problem is that the performance isn't great because it's coming from a SQL backend. I'd like to populate the data using a stored procedure. However, I think this prevents us from using the search and sort functions in Access. Can this be used with stored procedures?
When you double click a row it takes you to another form so it's activated somehow - what is that?
Anyway, this data can be sorted by clicking on the top row of any column and selecting ascend, etc.
The only problem is that the performance isn't great because it's coming from a SQL backend. I'd like to populate the data using a stored procedure. However, I think this prevents us from using the search and sort functions in Access. Can this be used with stored procedures?
?
