Access automatically moving reports

[Guest]

I am creating this database of school in each state. When i first started and
reopened the table i am working with access will select a group of records i
was working with the previous session and place them at the top for some
reason and when i corrected the table, saved and reopened it the fields would
move back to the top. After wasting hours playing around i solved the
problem. Then on another table i was working on i played around and fix the
problem. But now the problem is back this time acces moves the record from
the previous session down to the bottom everytime i reopen the table. Can
anyone tell me what is going on and how to fix it without wasting hours
playing around? Just to let you know i have already tried selecting all and
removing filters or sorts.

 

[Roger Carlson]

Why do you care where they are in the table? Access tables have no fixed
record order. If you need an order, you should impose it in the sort order
of a query. In addition, you shouldn't be entering data directly into a
table, but should use a form based on a query.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

What i am trying to do is instead of having diffent tables for each state i
am puting them all together on one table. Breaking it down state by state.
The order matters because i don't want a school in north carolina to be up at
the top or mix in the schools of maryland or whatever school. The reason i am
using a table is just i am more comfortable with enter information in a table
the query.

 

[Roger Carlson]

Well, unfortunately, you can't count on the order of records in a table to
remain in the order you entered them. You have to sort it on something.
The best place to do this is in a query. However, you might get the results
you want by sorting it in the table on the State field.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[John Vinson]

On Wed, 4 Jan 2006 08:38:06 -0800, Unhappy dude <Unhappy

I am creating this database of school in each state. When i first started and
reopened the table i am working with access will select a group of records i
was working with the previous session and place them at the top for some
reason and when i corrected the table, saved and reopened it the fields would
move back to the top. After wasting hours playing around i solved the
problem. Then on another table i was working on i played around and fix the
problem. But now the problem is back this time acces moves the record from
the previous session down to the bottom everytime i reopen the table. Can
anyone tell me what is going on and how to fix it without wasting hours
playing around? Just to let you know i have already tried selecting all and
removing filters or sorts.

You are assuming that a table has a top and a bottom.

IT DOESN'T.

A table is an unordered "heap" of data. If you want to select certain
records or display records in a particular sorted sequence, you must -
no options - use a Query.

Stop wasting your time trying to manually move records around in the
table. Instead, be sure you have some field or fields in the table
which specify the desired sort order; and use a Query sorting by those
fields.

Secondly, you should not be using the table datasheet for data entry
or editing. Table datasheet view is useful for debugging only; to
manage data in your tables, create a Form (usually based on a
selective and/or sorted Query) and do your editing using the Form.

John W. Vinson[MVP]

 

[BruceM]

How did you establish your comfort level with entering information into a
table in the first place? You will not know the difference between entering
the information in a query and entering it in a table, assuming you insist
on going against Roger's advice and entering information directly into a
table. That advice, by the way, is shared by virtually every experienced
Access person you will find here. You could always use a form formatted in
datasheet view to simulate the look of a table, if you prefer a sort of
retro look, but you would be doing yourself a favor by exploring what Access
can do for you rather than trying to throttle it back.

 

[John Vinson]

What i am trying to do is instead of having diffent tables for each state i
am puting them all together on one table. Breaking it down state by state.
The order matters because i don't want a school in north carolina to be up at
the top or mix in the schools of maryland or whatever school. The reason i am
using a table is just i am more comfortable with enter information in a table
the query.

A Query with a criterion of "MD" on the State field, and a sort term
Ascending on the school name, will show you only the schools in
Maryland, sorted in alphabetical order.

You can use this Query in datasheet view in exactly and precisely the
same way that you would use a Table. It will edit, let you add records
(though if you add a NC record to this query it will quite properly
disappear from the Query after it's added to the table; you can then
see it in your North Carolina query).

You can base a Form on this query as well. In fact it would be a great
idea!

Not using Queries in Access is a bit like not using expressions in
Excel, or not using the gearshift in your car. You can drive a car in
first gear all the time, if you wish. Doesn't mean that you should!

John W. Vinson[MVP]

 

[Joseph Meehan]

I suspect you are going to continue to be unhappy if you insist on
trying to use it in a manor other than that for which it was designed.
This is database, not spreadsheet. It takes an adjustment of the mind to
make sense of it. Once you do and you embrace the Access way of doing
things, life will be a lot easier.