IDE bug? deleted form object persists on object list

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

Guest

This has me tearing my hair out! Objects previously deleted from a form
persist in the VBA object list evn though they don't actually exist. I had
an object called Feasibilty which has been deleted. When I try to acces a
column called feasibility (in another table), the IDE changes it to
Feasibility and then won't run as it can't find the column in the table!

Chris

(I've sorted this instance by changing the column name to Feasibilty but
it's causing less easily rectified problems in other areas)
 
Chris,

Just guessing here, but you may be experiencing Access's bad habit of
leaving rubbish behind, after some serious amount of development in a
given copy of an .mdb - a known issue. Though not guaranteed to solve
your problem, it wouldn't hurt either to make a new, blank .mdb and
import all objects from the old one, thus obtaining a frech, clean copy.

HTH,
Nikos
 
Are you declaring
Option Explicit

Did you disable the name autocorrect feature in Access.
Check under Tools/Options then select the general tab to check and see if
the Track name Autocorrect feature is enabled.


I dont know if this is your problem or not, there is an article in the KB
discussing this issue.
I ended up creating a blank database and turning this option off,, then I
imported the old database into the new one.
 
This sounds as if you are having a problem with Name Autocorrect. Go to
Tools|Options|General tab and uncheck "Track name AutoCorrect info". When
AutoCorrect works, it can be nice, but it tends to cause more problems than
it solves.
 
Thanks for the quick responses,

'track name autocorrect info' isn't checked is it still worth recreating the
dB?

Cheers,
Chris
 
Back
Top