N
nzquikster
After adding a record how do you re-order the table so that a form doesn't
recognize the new record as the last record
recognize the new record as the last record
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom van Stiphout
On Thu, 16 Jul 2009 06:36:01 -0700, nzquikster
For maximum flexibility a form should be bound to a query rather than
a table. You can start with a query that simply selects everything
from the table:
select *
from myTable
Then you can sort the records, by adding the field to sort by, uncheck
the Show checkbox (otherwise you would have this data twice), and
select Ascending or Descending in the Sort row:
select *
from myTable
order by myField
The form will now display the records in that order.
There are additional sort options in form design - see the OrderBy and
OrderByOn properties. This would override what the query said and is
for more advanced applications.
-Tom.
Microsoft Access MVP
For maximum flexibility a form should be bound to a query rather than
a table. You can start with a query that simply selects everything
from the table:
select *
from myTable
Then you can sort the records, by adding the field to sort by, uncheck
the Show checkbox (otherwise you would have this data twice), and
select Ascending or Descending in the Sort row:
select *
from myTable
order by myField
The form will now display the records in that order.
There are additional sort options in form design - see the OrderBy and
OrderByOn properties. This would override what the query said and is
for more advanced applications.
-Tom.
Microsoft Access MVP
W
Wayne-I-M
Thats not normal. A table is just somewhere to store data is not really for
anything else (OK a few thing indexing, formating fields etc - but nothing
else)
What is it you're trying to do - can you give more details
anything else (OK a few thing indexing, formating fields etc - but nothing
else)
What is it you're trying to do - can you give more details
N
nzquikster
I was adding parts to a database with each part having its own number. i
wanted to put the parts in order so that i could find the next available
number.
wanted to put the parts in order so that i could find the next available
number.
N
nzquikster
OK got it working now, thank you.
Tom van Stiphout said:On Thu, 16 Jul 2009 06:36:01 -0700, nzquikster
For maximum flexibility a form should be bound to a query rather than
a table. You can start with a query that simply selects everything
from the table:
select *
from myTable
Then you can sort the records, by adding the field to sort by, uncheck
the Show checkbox (otherwise you would have this data twice), and
select Ascending or Descending in the Sort row:
select *
from myTable
order by myField
The form will now display the records in that order.
There are additional sort options in form design - see the OrderBy and
OrderByOn properties. This would override what the query said and is
for more advanced applications.
-Tom.
Microsoft Access MVP