Re: Order by property and OrderByOn

One of the simpler methods is to create a query that sorts your data however
you like, then set the record source of your form to that query.
-Ed

"Hughie" <Hughie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4FE5009E-7513-4DAC-806A-2B2D1CCDAD37@xxxxxxxxxxxxxxxx
>I want to have my form set to sort by a particular field each time it
>opens.
> My reference book says to use Order by property in the table and
> OrderByProperty in the form.
> Problem is book doesn't say how to use the Order by property and I can't
> even find the OrderByOn property for the form. Please advise. Thanks.


.

Relevant Pages

  • Re: Differences in Range Scan Performance between Binary and NLS Indexes
    ... And our query plan looks like this and completes in about 120 ms. ... 400 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
  • Re: Sort Multi Time Fields
    ... <MS ACCESS MVP> ... When it sorts now, it sorts numerically (ex: ... I do have the report sorting and grouping by date ... Save the query. ...
    (microsoft.public.access.reports)
  • Re: Order of records on a forn
    ... On the Form Properties I set the Data Properties -- Order By to ... Base the form on a Query - not directly on your table; and sort that Query by ... the OrderByOn property of the form must be set to True for the ...
    (microsoft.public.access.forms)
  • Re: Class reunion query
    ... (no private e-mails, please) ... This query worked, almost. ... It sorts by the first name and not the LastName/as I had ... FROM tblDemographics ...
    (microsoft.public.access.queries)
  • Re: sorting in subform
    ... Try setting the subform's OrderByOn property in its Open event: ... Another option is to create a query, and use the Sorting row in query design ... Then open your subform in design view, ...
    (microsoft.public.access.forms)
Loading