Hi Noel
On 29/08/13 06:12, Marion Noel Lodge wrote:
Hi Ian,
With a Form, I have found the following is the way to lock in the Form's
sort order -
1. Open the Form in Edit mode
2. Right click on the form and from the dropdown choose Form...
3. Click on the Data Tab
4. The contents field
Hi Noel
On 29/08/13 06:12, Marion Noel Lodge wrote:
Hi Ian,
With a Form, I have found the following is the way to lock in the Form's
sort order -
1. Open the Form in Edit mode
2. Right click on the form and from the dropdown choose Form...
3. Click on the Data Tab
4. The contents field
Hi Ian,
There is another way -
1. After opening your Form in design mode, click on View | Toolbars | and
make sure Form Design is ticked
2. On that toolbar, click on Form Navigator (5th from left on my toolbar -
it's the one with the 4 point star on it)
3. Right click on your Form name
On 08/29/2013 12:30 AM, Ian Whitfield wrote:
Hi Noel
On 29/08/13 06:12, Marion Noel Lodge wrote:
Hi Ian,
With a Form, I have found the following is the way to lock in the Form's
sort order -
1. Open the Form in Edit mode
2. Right click on the form and from the dropdown choose Form...
3.
Hi Ian,
With a Form, I have found the following is the way to lock in the Form's
sort order -
1. Open the Form in Edit mode
2. Right click on the form and from the dropdown choose Form...
3. Click on the Data Tab
4. The contents field should be pointing to your Table
5. Click on the box to
Thanks Jay
On 26/08/13 15:54, Jay Lozier wrote:
Ian,
Is there an id key field? If there is the default sorting is by the id
key (usually numerical order).
In SQL you can add the line:
ORDER BY Last-Name, First-Name
The default order is ascending (ASC) if descending is needed
ORDER BY
Ian
Unless the query contains ORDER BY clause in general the return set will
be whatever default order of the dataset. Usually what I have seen, is to
have a saved query that has the all the relevant options built-in and run
it. I am not sure how to do this best in Base; I tend to use
Hi All
I now have my new MySQL/LO Base Database up, running and fully edited
from the old one. And what a pleasure it is to work with!! This IS the
way to go,
One question - It seems to have a strange way of sorting the Data as
displayed in the Form I designed and I have to select 'Sort' in
Ian,
Is there an id key field? If there is the default sorting is by the id key
(usually numerical order).
In SQL you can add the line:
ORDER BY Last-Name, First-Name
The default order is ascending (ASC) if descending is needed
ORDER BY Last-Name DESC, First-Name DESC
On Mon, 26 Aug
