reording table after entering a new record

[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

 

[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

 

[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

 

[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.

 

[nzquikster]

OK got it working now, thank you.

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