 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007Controls on Forms..........Advice Please
When A control say...command button is placed on a form and named say cmdTest.... If I then delete the control and place another and name it cmdTest.......a message appears sayin the control already exists.....although it has been deleted. Question1 I assume the Name of the control must be stored and this is the reason for the message...where is the data relevant for the control stored? Question 2 How can the control data be deleted also if a command button is dleted. Thanks Dermot To avoid the problem: 1. Make sure the Name AutoCorrect boxes are unchecked under: Tools | Options | General | Name AutoCorrect In Access 2007, it's: Office Button | Access Options | Current Database | Name AutoCorrect Explanation of why: http://allenbrowne.com/bug-03.html 2. Compact the database after deleting the control: Tools | Database Utilities | Compact/Repair or in Access 2007: Office Button | Manage | Compact/Repair  SignatureAllen 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. > When A control say...command button is placed on a form and named say > cmdTest.... [quoted text clipped - 11 lines] > Thanks > Dermot Allen Thanks for the thourough reply Kind regads Dermot > To avoid the problem: > [quoted text clipped - 25 lines] > > Thanks > > Dermot |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.