Fields Moving Around

Hi and HELP

I have inherited a very large table probably almost to 200 columns. I have
been asked to add 4 columns in a specific order in the table. When I add them
where I want them and then save they seemingly move and other columns are
intervening. How can I make them stay where I want them in the table?

Can something be done in design view to place them in the order that I want
them in?

Hi

If you hve 200+ fields in one table it is almost certain you have too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you don't use
them to enter data. Create a query or form from the table and use that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200 columns. I have
been asked to add 4 columns in a specific order in the table. When I add them
where I want them and then save they seemingly move and other columns are
intervening. How can I make them stay where I want them in the table?

Can something be done in design view to place them in the order that I want
them in?

Hey Wayne,
Lyne from Manchester here. I wish it were that easy. I actually created a
little form for this pereson that had all of her fields neatly arranged.
They are very backward here and want to enter the data directly into the
fields. WAAH

"Wayne-I-M" wrote:

Hi

If you hve 200+ fields in one table it is almost certain you have too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you don't use
them to enter data. Create a query or form from the table and use that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200 columns. I have
been asked to add 4 columns in a specific order in the table. When I add them
where I want them and then save they seemingly move and other columns are
intervening. How can I make them stay where I want them in the table?

Can something be done in design view to place them in the order that I want
them in?

You could set the On Open of the database with some form a switchboard that
would not allow access to the tables !! - thats what I have done for the
past 5 years - anyone who "needs" to get into the tables will know how to
anyway and anyone else should only be using the sections they are meant to.



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hey Wayne,
Lyne from Manchester here. I wish it were that easy. I actually created a
little form for this pereson that had all of her fields neatly arranged.
They are very backward here and want to enter the data directly into the
fields. WAAH

"Wayne-I-M" wrote:

Hi

If you hve 200+ fields in one table it is almost certain you have too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you don't use
them to enter data. Create a query or form from the table and use that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200 columns. I have
been asked to add 4 columns in a specific order in the table. When I add them
where I want them and then save they seemingly move and other columns are
intervening. How can I make them stay where I want them in the table?

Can something be done in design view to place them in the order that I want
them in?

I totally agree, but this is the wife of the boss, and she is very stubborn.
Old habits die hard. Thanks for you advice though.



"Wayne-I-M" wrote:

You could set the On Open of the database with some form a switchboard that
would not allow access to the tables !! - thats what I have done for the
past 5 years - anyone who "needs" to get into the tables will know how to
anyway and anyone else should only be using the sections they are meant to.



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hey Wayne,
Lyne from Manchester here. I wish it were that easy. I actually created a
little form for this pereson that had all of her fields neatly arranged.
They are very backward here and want to enter the data directly into the
fields. WAAH

"Wayne-I-M" wrote:

Hi

If you hve 200+ fields in one table it is almost certain you have too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you don't use
them to enter data. Create a query or form from the table and use that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200 columns. I have
been asked to add 4 columns in a specific order in the table. When I add them
where I want them and then save they seemingly move and other columns are
intervening. How can I make them stay where I want them in the table?

Can something be done in design view to place them in the order that I want
them in?

Wayne's suggestion is sound. There is an additional wrinkle to this that may
help.
That would be to create a datasheet form based on a query with the columns
in the order the moron - oops! - boss's wife - wants.

I know the type you are dealing with, seen a lot of them. But, you can
explain to here that tables may or may not keep the order of fields like you
want them and that you are providing her a way to get what she wants. In a
real database (you don't have one), it never matters. The datasheet view
looks and behaves enough like going directly to a table, it shouldn't matter
to her.

"Novice2000" wrote:

I totally agree, but this is the wife of the boss, and she is very stubborn.
Old habits die hard. Thanks for you advice though.



"Wayne-I-M" wrote:

You could set the On Open of the database with some form a switchboard that
would not allow access to the tables !! - thats what I have done for the
past 5 years - anyone who "needs" to get into the tables will know how to
anyway and anyone else should only be using the sections they are meant to.



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hey Wayne,
Lyne from Manchester here. I wish it were that easy. I actually created a
little form for this pereson that had all of her fields neatly arranged.
They are very backward here and want to enter the data directly into the
fields. WAAH

"Wayne-I-M" wrote:

Hi

If you hve 200+ fields in one table it is almost certain you have too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you don't use
them to enter data. Create a query or form from the table and use that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200 columns. I have
been asked to add 4 columns in a specific order in the table. When I add them
where I want them and then save they seemingly move and other columns are
intervening. How can I make them stay where I want them in the table?

Can something be done in design view to place them in the order that I want
them in?

The order that fields are displayed in the Datasheet view don't have to
parallel the order they are in design view. You can drag the fields to a
new position in Datasheet view and save this configuation. It can be
different then the order of the fields in design view.

-- Click on the column title (header) so the entire column is selected
-- Drag the column to a new position.
-- Repeat as needed
-- Save the change by selecting Save from the file menu.

Once this is done, changing the order of the columns in design view will not
change the order of the columns in datasheet view. I know of no good way to
restore the default behavior (parallel columns in design and datasheet
view).


"Klatuu" wrote in message
...
Wayne's suggestion is sound. There is an additional wrinkle to this that
may
help.
That would be to create a datasheet form based on a query with the columns
in the order the moron - oops! - boss's wife - wants.

I know the type you are dealing with, seen a lot of them. But, you can
explain to here that tables may or may not keep the order of fields like
you
want them and that you are providing her a way to get what she wants. In
a
real database (you don't have one), it never matters. The datasheet view
looks and behaves enough like going directly to a table, it shouldn't
matter
to her.

"Novice2000" wrote:

I totally agree, but this is the wife of the boss, and she is very
stubborn.
Old habits die hard. Thanks for you advice though.



"Wayne-I-M" wrote:

You could set the On Open of the database with some form a switchboard
that
would not allow access to the tables !! - thats what I have done for
the
past 5 years - anyone who "needs" to get into the tables will know how
to
anyway and anyone else should only be using the sections they are meant
to.



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hey Wayne,
Lyne from Manchester here. I wish it were that easy. I actually
created a
little form for this pereson that had all of her fields neatly
arranged.
They are very backward here and want to enter the data directly into
the
fields. WAAH

"Wayne-I-M" wrote:

Hi

If you hve 200+ fields in one table it is almost certain you have
too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you
don't use
them to enter data. Create a query or form from the table and use
that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200
columns. I have
been asked to add 4 columns in a specific order in the table.
When I add them
where I want them and then save they seemingly move and other
columns are
intervening. How can I make them stay where I want them in the
table?

Can something be done in design view to place them in the order
that I want
them in?

Good point, John. That did not occur to me. This way, the boss's wife gets
what she wants.

"John Spencer" wrote:

The order that fields are displayed in the Datasheet view don't have to
parallel the order they are in design view. You can drag the fields to a
new position in Datasheet view and save this configuation. It can be
different then the order of the fields in design view.

-- Click on the column title (header) so the entire column is selected
-- Drag the column to a new position.
-- Repeat as needed
-- Save the change by selecting Save from the file menu.

Once this is done, changing the order of the columns in design view will not
change the order of the columns in datasheet view. I know of no good way to
restore the default behavior (parallel columns in design and datasheet
view).


"Klatuu" wrote in message
...
Wayne's suggestion is sound. There is an additional wrinkle to this that
may
help.
That would be to create a datasheet form based on a query with the columns
in the order the moron - oops! - boss's wife - wants.

I know the type you are dealing with, seen a lot of them. But, you can
explain to here that tables may or may not keep the order of fields like
you
want them and that you are providing her a way to get what she wants. In
a
real database (you don't have one), it never matters. The datasheet view
looks and behaves enough like going directly to a table, it shouldn't
matter
to her.

"Novice2000" wrote:

I totally agree, but this is the wife of the boss, and she is very
stubborn.
Old habits die hard. Thanks for you advice though.



"Wayne-I-M" wrote:

You could set the On Open of the database with some form a switchboard
that
would not allow access to the tables !! - thats what I have done for
the
past 5 years - anyone who "needs" to get into the tables will know how
to
anyway and anyone else should only be using the sections they are meant
to.



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hey Wayne,
Lyne from Manchester here. I wish it were that easy. I actually
created a
little form for this pereson that had all of her fields neatly
arranged.
They are very backward here and want to enter the data directly into
the
fields. WAAH

"Wayne-I-M" wrote:

Hi

If you hve 200+ fields in one table it is almost certain you have
too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you
don't use
them to enter data. Create a query or form from the table and use
that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200
columns. I have
been asked to add 4 columns in a specific order in the table.
When I add them
where I want them and then save they seemingly move and other
columns are
intervening. How can I make them stay where I want them in the
table?

Can something be done in design view to place them in the order
that I want
them in?

John's and Klatu's advice about datasheet view is good although I would tend
to use a continous form formated to look as much like a table as you need to
(to keep everyone happy). There are quite few reasons for this but maybe
this is just me being lazy :-)

Good luck with your project.


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Klatuu" wrote:

Good point, John. That did not occur to me. This way, the boss's wife gets
what she wants.

"John Spencer" wrote:

The order that fields are displayed in the Datasheet view don't have to
parallel the order they are in design view. You can drag the fields to a
new position in Datasheet view and save this configuation. It can be
different then the order of the fields in design view.

-- Click on the column title (header) so the entire column is selected
-- Drag the column to a new position.
-- Repeat as needed
-- Save the change by selecting Save from the file menu.

Once this is done, changing the order of the columns in design view will not
change the order of the columns in datasheet view. I know of no good way to
restore the default behavior (parallel columns in design and datasheet
view).


"Klatuu" wrote in message
...
Wayne's suggestion is sound. There is an additional wrinkle to this that
may
help.
That would be to create a datasheet form based on a query with the columns
in the order the moron - oops! - boss's wife - wants.

I know the type you are dealing with, seen a lot of them. But, you can
explain to here that tables may or may not keep the order of fields like
you
want them and that you are providing her a way to get what she wants. In
a
real database (you don't have one), it never matters. The datasheet view
looks and behaves enough like going directly to a table, it shouldn't
matter
to her.

"Novice2000" wrote:

I totally agree, but this is the wife of the boss, and she is very
stubborn.
Old habits die hard. Thanks for you advice though.



"Wayne-I-M" wrote:

You could set the On Open of the database with some form a switchboard
that
would not allow access to the tables !! - thats what I have done for
the
past 5 years - anyone who "needs" to get into the tables will know how
to
anyway and anyone else should only be using the sections they are meant
to.



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hey Wayne,
Lyne from Manchester here. I wish it were that easy. I actually
created a
little form for this pereson that had all of her fields neatly
arranged.
They are very backward here and want to enter the data directly into
the
fields. WAAH

"Wayne-I-M" wrote:

Hi

If you hve 200+ fields in one table it is almost certain you have
too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you
don't use
them to enter data. Create a query or form from the table and use
that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200
columns. I have
been asked to add 4 columns in a specific order in the table.
When I add them
where I want them and then save they seemingly move and other
columns are
intervening. How can I make them stay where I want them in the
table?

Can something be done in design view to place them in the order
that I want
them in?

Well, I agree that it is NOT a good idea to do the data entry directly in a
table or a query. You lose too much capability to do data checking to ensure
accurate entry.

It's too bad that the user insists on bad design. You can sometimes show them
the benefits of using a continuous form (or even a form in datasheet view) and
they will realize that they are better off. BUT sometimes the boss is the boss
(the boss's wife).

As my brother once pointed out to me boss spelled backward is
Double Ess OH Bee

Wayne-I-M wrote:

John's and Klatu's advice about datasheet view is good although I would tend
to use a continous form formated to look as much like a table as you need to
(to keep everyone happy). There are quite few reasons for this but maybe
this is just me being lazy :-)

Good luck with your project.

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.

"Klatuu" wrote:

Good point, John. That did not occur to me. This way, the boss's wife gets
what she wants.

"John Spencer" wrote:

The order that fields are displayed in the Datasheet view don't have to
parallel the order they are in design view. You can drag the fields to a
new position in Datasheet view and save this configuation. It can be
different then the order of the fields in design view.

-- Click on the column title (header) so the entire column is selected
-- Drag the column to a new position.
-- Repeat as needed
-- Save the change by selecting Save from the file menu.

Once this is done, changing the order of the columns in design view will not
change the order of the columns in datasheet view. I know of no good way to
restore the default behavior (parallel columns in design and datasheet
view).


"Klatuu" wrote in message
...
Wayne's suggestion is sound. There is an additional wrinkle to this that
may
help.
That would be to create a datasheet form based on a query with the columns
in the order the moron - oops! - boss's wife - wants.

I know the type you are dealing with, seen a lot of them. But, you can
explain to here that tables may or may not keep the order of fields like
you
want them and that you are providing her a way to get what she wants. In
a
real database (you don't have one), it never matters. The datasheet view
looks and behaves enough like going directly to a table, it shouldn't
matter
to her.

"Novice2000" wrote:

I totally agree, but this is the wife of the boss, and she is very
stubborn.
Old habits die hard. Thanks for you advice though.



"Wayne-I-M" wrote:

You could set the On Open of the database with some form a switchboard
that
would not allow access to the tables !! - thats what I have done for
the
past 5 years - anyone who "needs" to get into the tables will know how
to
anyway and anyone else should only be using the sections they are meant
to.



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hey Wayne,
Lyne from Manchester here. I wish it were that easy. I actually
created a
little form for this pereson that had all of her fields neatly
arranged.
They are very backward here and want to enter the data directly into
the
fields. WAAH

"Wayne-I-M" wrote:

Hi

If you hve 200+ fields in one table it is almost certain you have
too many.
You need to normalise the database.

But anyway

It does not matter where your "columns" (?) are in a table as you
don't use
them to enter data. Create a query or form from the table and use
that to
enter / view / do other things with / etc the data

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"Novice2000" wrote:

Hi and HELP

I have inherited a very large table probably almost to 200
columns. I have
been asked to add 4 columns in a specific order in the table.
When I add them
where I want them and then save they seemingly move and other
columns are
intervening. How can I make them stay where I want them in the
table?

Can something be done in design view to place them in the order
that I want
them in?