If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
This issue apparently has nothing to do with Name AutoCorrect. It only
occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
#13
|
|||
|
|||
This issue apparently has nothing to do with Name AutoCorrect. It only
occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
#14
|
|||
|
|||
This issue apparently has nothing to do with Name AutoCorrect. It only
occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
#15
|
|||
|
|||
John, it is possible to get A2003 to set SubdatasheetName to [None] for
tables in an A2000 database. I have personally experienced the problem caused by Name AutoCorrect, as have others. Once the database is corrupted in this way, Tina's suggestion for rebuilding it is the way to go. If your database is split, turn off Name AutoCorrect and set the property in the back end as well. If it is split, and the back end in Access 97 format, post back for specific instructions on how to handle that. -- 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 ... This issue apparently has nothing to do with Name AutoCorrect. It only occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
#16
|
|||
|
|||
John, it is possible to get A2003 to set SubdatasheetName to [None] for
tables in an A2000 database. I have personally experienced the problem caused by Name AutoCorrect, as have others. Once the database is corrupted in this way, Tina's suggestion for rebuilding it is the way to go. If your database is split, turn off Name AutoCorrect and set the property in the back end as well. If it is split, and the back end in Access 97 format, post back for specific instructions on how to handle that. -- 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 ... This issue apparently has nothing to do with Name AutoCorrect. It only occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
#17
|
|||
|
|||
John, it is possible to get A2003 to set SubdatasheetName to [None] for
tables in an A2000 database. I have personally experienced the problem caused by Name AutoCorrect, as have others. Once the database is corrupted in this way, Tina's suggestion for rebuilding it is the way to go. If your database is split, turn off Name AutoCorrect and set the property in the back end as well. If it is split, and the back end in Access 97 format, post back for specific instructions on how to handle that. -- 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 ... This issue apparently has nothing to do with Name AutoCorrect. It only occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
#18
|
|||
|
|||
oh, sorry, i misunderstood.
i do normally use A2000 format in A2003 software, myself, and have had not had the problems you describe in setting the Subdatasheet Name to [None] in design view. so i'm still thinking it's probably not a bug in the A2003 user interface. at any rate, starting "fresh" as i outlined before may work. good luck! "John Avitt" wrote in message ... This issue apparently has nothing to do with Name AutoCorrect. It only occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
#19
|
|||
|
|||
oh, sorry, i misunderstood.
i do normally use A2000 format in A2003 software, myself, and have had not had the problems you describe in setting the Subdatasheet Name to [None] in design view. so i'm still thinking it's probably not a bug in the A2003 user interface. at any rate, starting "fresh" as i outlined before may work. good luck! "John Avitt" wrote in message ... This issue apparently has nothing to do with Name AutoCorrect. It only occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
#20
|
|||
|
|||
oh, sorry, i misunderstood.
i do normally use A2000 format in A2003 software, myself, and have had not had the problems you describe in setting the Subdatasheet Name to [None] in design view. so i'm still thinking it's probably not a bug in the A2003 user interface. at any rate, starting "fresh" as i outlined before may work. good luck! "John Avitt" wrote in message ... This issue apparently has nothing to do with Name AutoCorrect. It only occurs when I am using an Access 2000 format database in Access 2003, whether or not AutoCorrect is on. When I create an Access 2002-2003 database, it works okay. Unfortunately, I must use the Access 2000 format for now, since all my users are not yet upgraded. I have no control over that. Thank you. 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 |
|
Thread Tools | |
Display Modes | |
|
|