Controls on Forms..........Advice Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button - 1 Click Runs Code 3 Times 1
Access Reference Subform's Control 0
User Sets Control Default Value 1
Adding control boxes 2
Access Create option group without using wizard? 2
From a form control, open another form relating to that record 4
Image control on form - not displaying the image stored in a file 8
Access Automatically Send a notification email once a record is added 0

Back
Top