BUG: Subdatasheet=[None]

I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically). When I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in the
user interface. I am able to set the value programmatically, so the problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

I believe this bug is another of the long list associated with Name
AutoCorrect.

Try unchecking the boxes under:
Tools | Options | General | Name AutoCorrect
Then compact the database:
Tools | Database Utilites | Compact
If the table is attached, do that in the back end database as well.

Note that if it is an attached table, and the back end does not support
subdatasheets (e.g. an attached Access 97 database), the setting won't stick
because the property does not exist. With an A97 back end, you can
CreateProperty() on each TableDef so the property does exist, set it to
"[None]", and the front end will respect the setting.

For other problems caused by Name AutoCorrect:
http://members.iinet.net.au/~allenbrowne/bug-03.html
(There's more than a dozen in that list.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically). When I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to open a
module and run the code to change this property back to [None]. This is VERY
ANNOYING!

HELP!!!

John


"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically). When I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to open a
module and run the code to change this property back to [None]. This is VERY
ANNOYING!

HELP!!!

John


"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically). When I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to open a
module and run the code to change this property back to [None]. This is VERY
ANNOYING!

HELP!!!

John


"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically). When I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved and
closed. on re-open, the setting was still [None]. i compacted the db, closed
it, closed Access, then re-opened db and table - setting is still [None]. so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth


"John Avitt" wrote in message
...
Additional information.

Whenever I make *ANY* change to a table in design view, then save and
close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to open
a
module and run the code to change this property back to [None]. This is
VERY
ANNOYING!

HELP!!!

John


"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet
Name"
property on a table to [None] manually (i.e. not programmatically). When
I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of
the
appropriate person(s).

Thank you.

John

does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved and
closed. on re-open, the setting was still [None]. i compacted the db, closed
it, closed Access, then re-opened db and table - setting is still [None]. so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth


"John Avitt" wrote in message
...
Additional information.

Whenever I make *ANY* change to a table in design view, then save and
close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to open
a
module and run the code to change this property back to [None]. This is
VERY
ANNOYING!

HELP!!!

John


"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet
Name"
property on a table to [None] manually (i.e. not programmatically). When
I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of
the
appropriate person(s).

Thank you.

John

does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved and
closed. on re-open, the setting was still [None]. i compacted the db, closed
it, closed Access, then re-opened db and table - setting is still [None]. so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth


"John Avitt" wrote in message
...
Additional information.

Whenever I make *ANY* change to a table in design view, then save and
close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to open
a
module and run the code to change this property back to [None]. This is
VERY
ANNOYING!

HELP!!!

John


"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet
Name"
property on a table to [None] manually (i.e. not programmatically). When
I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of
the
appropriate person(s).

Thank you.

John

I am working exclusively with Access 2000 format databases. I don't have any
choice at this point. Not all my users have Access 2003 yet.

John

"tina" wrote in message
...
does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name
to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved
and
closed. on re-open, the setting was still [None]. i compacted the db,
closed
it, closed Access, then re-opened db and table - setting is still [None].
so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name
Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth


"John Avitt" wrote in message
...
Additional information.

Whenever I make *ANY* change to a table in design view, then save and
close
the table, the Subdatasheet Name property is changed to [Auto], although
I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to
open
a
module and run the code to change this property back to [None]. This is
VERY
ANNOYING!

HELP!!!

John


"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet
Name"
property on a table to [None] manually (i.e. not programmatically).
When
I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug
in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of
the
appropriate person(s).

Thank you.

John

I am working exclusively with Access 2000 format databases. I don't have any
choice at this point. Not all my users have Access 2003 yet.

John

"tina" wrote in message
...
does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name
to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved
and
closed. on re-open, the setting was still [None]. i compacted the db,
closed
it, closed Access, then re-opened db and table - setting is still [None].
so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name
Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth


"John Avitt" wrote in message
...
Additional information.

Whenever I make *ANY* change to a table in design view, then save and
close
the table, the Subdatasheet Name property is changed to [Auto], although
I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to
open
a
module and run the code to change this property back to [None]. This is
VERY
ANNOYING!

HELP!!!

John


"John Avitt" wrote in message
...
I have Microsoft Access 2003 and am trying to set the "Subdatasheet
Name"
property on a table to [None] manually (i.e. not programmatically).
When
I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug
in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of
the
appropriate person(s).

Thank you.

John