Is there an ongoing problem with VBA and MS Access?

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

I have created numerous Access databases complete with
forms and reports. On occasion while developing forms I
will come across the following error: Method or data member
not found. When this happens all of the event procedures
in the form will cause the same error. Removing the code
from the event procedures doesn't fix anything. I have
actually re-created forms from scratch to fix the problem
but this can be very time consuming. Does anyone have any
insights to this on going problem?
 
Could be caused by many things....you change the name of a control but don't
change the code that references it.....you change the underlying
recordsource and don't change the code that references a field that no
longer is there....you are using "reserved" words as control or field names
(such as Date, Name) and ACCESS has become confused and doesn't know what
you mean any more...your form is corrupt and needs to be rebuilt (can do
this usually by importing it into a new database, then importing it back to
your original database after deleting the original form; or by using massive
copy/paste of controls from one form into a new one, and then copying and
reestablishing links to the code)....or other possible reasons.
 
Occasionally, I get Form corruptions during design time and Methods /
Properties I knew for sure became "not found" (mainly in A2K2).

Generally a Compact & Repair should fix the corruptions. Only on one
occasion, I had to create a new database and imported all objects from the
existing database to the new database.
 
Back
Top