RE: Where is the Order of this Form Set?

Open the form in design view and click on menu VIEW - Properties View. Look
at the Order By: This will tell you. This can be change by anyone using
the form by clicking in a field they wish to sort by and clicking on the icon
in the tool bar A-Z or Z-A.
Like John said it is best to use a query for the order. In the query the
order can include multiple fields such as date, catalogue number, color, etc.

"TheScullster" wrote:

> I have inherited a database and have one machine that regularly seems to
> screw up the front end!
> Developed on access2000 front end then moved to Access (part of Office 2003)
> with back end moved from NT4 to Windows Server 2003.
> Don't really expect that the platforms are an issue here, these problems did
> not appear immediately the changes were made.
>
> Anyway back to the story line.
>
> The database stores drawing numbers, titles and fixed attributes in one
> table and job specific issue dates etc in another table.
> The form comprises main and subform showing info from the above tables
> respectively.
>
> Problem: every now and then, one PC which is used almost entirely for
> drawing data input seems to screw up the front end. The main form suddenly
> stops showing the drawing numbers in alpha numeric order.
> The thing is I don't see where this order is being set in the first place.
> The main form is based on a table rather than an ordered query and the order
> by property is not set in the main form properties.
>
> Question:
>
> Where else could this order be set and what could be causing this PC to lose
> the order on this form?
> I should point out that this is the only PC that will be giving this form
> serious hammer in edit mode.
>
> TIA
>
> Phil
>
>
>
.

Relevant Pages

  • Re: Where is the Order of this Form Set?
    ... > I have inherited a database and have one machine that regularly seems to ... > drawing data input seems to screw up the front end. ... > The main form is based on a table rather than an ordered query and the ...
    (microsoft.public.access.gettingstarted)
  • Re: Selecting latest revision but with criteria...
    ... Try modifying the query to read as follows. ... All drawing numbers from max query and all from qBaseNumbers query combined in one column ... But the base drawing numbers from the qBaseNumbers query, I only need those that did not have a rev to them. ... This can probably be done in one query if your field and table names contain ONLY letters, numbers, and the underscore character. ...
    (microsoft.public.access.queries)
  • Where is the Order of this Form Set?
    ... I have inherited a database and have one machine that regularly seems to ... The database stores drawing numbers, titles and fixed attributes in one ... drawing data input seems to screw up the front end. ... by property is not set in the main form properties. ...
    (microsoft.public.access.gettingstarted)
  • Re: Showing cosmetic thread in drawing of assembly
    ... If I set the drawing view of the assembly to "shaded" it shows the shaded representation of the thread, but it won't show the lines for the thread when the view is in "hidden line" mode. ... First insert model items as John wrote. ... In the feature manager of the screw you can find the thread representation which may be suppresed. ...
    (comp.cad.solidworks)
  • Re: Selecting latest revision but with criteria...
    ... All drawing numbers from max query and all from qBaseNumbers query ... But the base drawing numbers from the qBaseNumbers query, ... "Ken Snell MVP" wrote: ...
    (microsoft.public.access.queries)