Control Buttons don't work anymore!

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

Guest

I am building a database (named ProFiles) in Access 2003, and "thought" I was
about 95% done. As I'm going through testing everything I noticed that some
of the control buttons on some of my forms don't work anymore!!

The message I get is:
"The expression On Click you entered as the event property setting produced
the following error: A problem occurrred while ProFiles was communicating
with the OLE server or ActiveX Control."

I tried to drop in a new button and do something as simple as close the form
and open another, or just search for a record, and nothing works!! About 10%
of my buttons are behaving this way and all the others are fine!

Can someone please help me with where to look for the problem and how to
resolve it, please?!?!

Thanks!
Susan
 
Susan,

Try going into the code editor. Under "tools" in the toolbar go to
"references" and check to make sure that all the dlls and activeX controls
are being pointed to. If you
are developing and mdb, you'll have to have MS DAO.

You probably want OLE Automation off.

LOL,
-- Abe
 
Thanks! The ones I have checked are:
VB for applications
MS Access 11.0 Object library
OLE Automation (I'm turning this off)
MS DAO 3.6 Object library
MS ActiveX Data Objects 2.5 library
MS VB for applications Extensibility 5.3

Should there be any others?
Thanks again!
Susan
 
Click off MS VB for applications Extensibility 5.3 and recompile. If it
compiles without errors (it should) then your events should work fine.

LOL,
-Abe
 
Back
Top