Fields Moving Around

Double Ess OH Bee ?????

Thanks John,

But I did that three times and saved it. Each time I reopen the table the
order has been changed. All I can think is that perhaps there is something
going on behind the scenes having to do with the order of display, but I
don't know enough about this to figure it out.


"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?

Just checking.

You had the table open in DATASHEET view (not DESIGN view) when you moved
the columns around and you saved the changes in DATASHEET view.

I know that it works from me with Access 2000 SP3 installed with Windows XP
Professional
I didn't test it with Access 2003 or Access 97, but as I remember they both
work the same way for this "feature"

As several persons have noted, working directly in the table (or in a query)
is not the best solution. I understand you may be stuck with doing so, but
if you can convince the "authorities" that their are significant benefits to
using a form (even if it is a form in datasheet view).

"Novice2000" wrote in message
...
Thanks John,

But I did that three times and saved it. Each time I reopen the table the
order has been changed. All I can think is that perhaps there is something
going on behind the scenes having to do with the order of display, but I
don't know enough about this to figure it out.


"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?

Some times the Boss's wife can be of great benefit. Several years ago when I
was supporting SBT accounting software in FoxPro, I had a client who had
almost every package SBT offered, from inventory to payroll. The wife
decided she did not like the fact that all confirmation questions had a
default of No. She wanted them all to be Yes to save her clicks. I
explained why confirmation questions should default to No and how much it
would cost to change all the questions in all the modules. She did not care
and the Boss (sic) agreed to it. I made several thousand dollars making
changes to their software.

"John Spencer" wrote:

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?

Thanks John.

I have tried. This morning I was told that the boss's wife went into the
table and deleted the columns that I added because they weren't where she
wanted them to be. Then she tried adding them and the database is too large
LOL.

Now at noon I am to try again to add the columns and have them appear in the
right place. Yes I was in datasheet view when I added the columns the first
time. I don't think I would even know how to move them in design view.

"John Spencer" wrote:

Just checking.

You had the table open in DATASHEET view (not DESIGN view) when you moved
the columns around and you saved the changes in DATASHEET view.

I know that it works from me with Access 2000 SP3 installed with Windows XP
Professional
I didn't test it with Access 2003 or Access 97, but as I remember they both
work the same way for this "feature"

As several persons have noted, working directly in the table (or in a query)
is not the best solution. I understand you may be stuck with doing so, but
if you can convince the "authorities" that their are significant benefits to
using a form (even if it is a form in datasheet view).

"Novice2000" wrote in message
...
Thanks John,

But I did that three times and saved it. Each time I reopen the table the
order has been changed. All I can think is that perhaps there is something
going on behind the scenes having to do with the order of display, but I
don't know enough about this to figure it out.


"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?

It does work in 2003. I just tested it.
One other thing to consider. Is the OP making the change in the copy of the
mdb the boss's wife uses? Is the boss's wife moving them around and not
telling the truth about it?

"John Spencer" wrote:

Just checking.

You had the table open in DATASHEET view (not DESIGN view) when you moved
the columns around and you saved the changes in DATASHEET view.

I know that it works from me with Access 2000 SP3 installed with Windows XP
Professional
I didn't test it with Access 2003 or Access 97, but as I remember they both
work the same way for this "feature"

As several persons have noted, working directly in the table (or in a query)
is not the best solution. I understand you may be stuck with doing so, but
if you can convince the "authorities" that their are significant benefits to
using a form (even if it is a form in datasheet view).

"Novice2000" wrote in message
...
Thanks John,

But I did that three times and saved it. Each time I reopen the table the
order has been changed. All I can think is that perhaps there is something
going on behind the scenes having to do with the order of display, but I
don't know enough about this to figure it out.


"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?

What is OP?

"Klatuu" wrote:

It does work in 2003. I just tested it.
One other thing to consider. Is the OP making the change in the copy of the
mdb the boss's wife uses? Is the boss's wife moving them around and not
telling the truth about it?

"John Spencer" wrote:

Just checking.

You had the table open in DATASHEET view (not DESIGN view) when you moved
the columns around and you saved the changes in DATASHEET view.

I know that it works from me with Access 2000 SP3 installed with Windows XP
Professional
I didn't test it with Access 2003 or Access 97, but as I remember they both
work the same way for this "feature"

As several persons have noted, working directly in the table (or in a query)
is not the best solution. I understand you may be stuck with doing so, but
if you can convince the "authorities" that their are significant benefits to
using a form (even if it is a form in datasheet view).

"Novice2000" wrote in message
...
Thanks John,

But I did that three times and saved it. Each time I reopen the table the
order has been changed. All I can think is that perhaps there is something
going on behind the scenes having to do with the order of display, but I
don't know enough about this to figure it out.


"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?

You are the OP

(Original Poster)

I feel for you Novice2000. You absolute best way of handling this would be
to float your resume

"Novice2000" wrote:

What is OP?

"Klatuu" wrote:

It does work in 2003. I just tested it.
One other thing to consider. Is the OP making the change in the copy of the
mdb the boss's wife uses? Is the boss's wife moving them around and not
telling the truth about it?

"John Spencer" wrote:

Just checking.

You had the table open in DATASHEET view (not DESIGN view) when you moved
the columns around and you saved the changes in DATASHEET view.

I know that it works from me with Access 2000 SP3 installed with Windows XP
Professional
I didn't test it with Access 2003 or Access 97, but as I remember they both
work the same way for this "feature"

As several persons have noted, working directly in the table (or in a query)
is not the best solution. I understand you may be stuck with doing so, but
if you can convince the "authorities" that their are significant benefits to
using a form (even if it is a form in datasheet view).

"Novice2000" wrote in message
...
Thanks John,

But I did that three times and saved it. Each time I reopen the table the
order has been changed. All I can think is that perhaps there is something
going on behind the scenes having to do with the order of display, but I
don't know enough about this to figure it out.


"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?

By the way, there is an absolute limit of 255 fields in a table. AND if you
add a field, save it, and then delete it then one of the 255 field slots is
used. Also, you can lose a slot when you change the field type. So
eventually you will get an error message that the number of fields is too
large.

One way to recover the used slots is to compact the database. This will set
the number of used slots equal to the actual number of fields.

Another problem is the limit on the number of bytes (characters) that can be
entered in a row. If you try to enter more than 2000 characters in one
record then you won't be able to save the record.
Number of characters in a record (excluding Memo and OLE Object fields) --
2000

With 200 fields (or columns) that means you can have on average only 10
characters per field. You can define more than 2000 characters in the field
sizes, you just can't enter more than 2000 in total.


"Klatuu" wrote in message
...
You are the OP

(Original Poster)

I feel for you Novice2000. You absolute best way of handling this would
be
to float your resume

"Novice2000" wrote:

What is OP?

"Klatuu" wrote:

It does work in 2003. I just tested it.
One other thing to consider. Is the OP making the change in the copy
of the
mdb the boss's wife uses? Is the boss's wife moving them around and
not
telling the truth about it?

"John Spencer" wrote:

Just checking.

You had the table open in DATASHEET view (not DESIGN view) when you
moved
the columns around and you saved the changes in DATASHEET view.

I know that it works from me with Access 2000 SP3 installed with
Windows XP
Professional
I didn't test it with Access 2003 or Access 97, but as I remember
they both
work the same way for this "feature"

As several persons have noted, working directly in the table (or in a
query)
is not the best solution. I understand you may be stuck with doing
so, but
if you can convince the "authorities" that their are significant
benefits to
using a form (even if it is a form in datasheet view).

"Novice2000" wrote in message
...
Thanks John,

But I did that three times and saved it. Each time I reopen the
table the
order has been changed. All I can think is that perhaps there is
something
going on behind the scenes having to do with the order of display,
but I
don't know enough about this to figure it out.


"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?