Search results for query: *

Thanks a bunch Mike. My problem was that since there was already an order there, I couldn't specify one myself (it was ignored). The solution: 1) I deleted all the columns in the order/group list 2) After calling Open Record, I issued the sentence: Reports![MyReport].OrderBy=Field1 Bye...

A list (List.Rowsource).

A list called List.Rowsource.

On Access 97 there's no view->sorting/grouping, and if there was I wouldn't want to use it everytime I print a report which source (List.Rowsource) is already filtered and ordered (why re-order?). The filter is applied, however, I can't manage to sort the records using the OrderBy and OrderByOn...

But List.Rowsource is a query (when messageboxed it reads "select A, B FROM C WHERE D=E ORDER BY A), so I assume I am using a query in the report, not a table (the list is ordered and filtered, however the report is filtered but not ordered). Strange...

Hi there, I have (on Access97) a form that has a list that can be reordered on runtime. On the same form I have a button to print the Rowsource of this list item. However, even though the list is ordered, the report always prints in the same order. This is how I open the report...

Hi there, I have (on Access97) a form that has a list that can be reordered on runtime. On the same form I have a button to print the Rowsource of this list item. However, even though the list is ordered, the report always prints in the same order. This is how I open the report...