Command Button Error-Urgent!!!!

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

Guest

I am trying to create command buttons in a form and no matter what DoCmd. I
put in the on-click event of a button I receive the following error;
"... A problem occurred while Microsoft Access was communicating with the OLE server or Active X control"
Click to expand...


Any Suggestions on how to resolve this issue?

Thanks in advance,
Dave
 
Sounds like the VBA is corrupted.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

2. Compact the database to get rid of this stuff:
Tools | Database Utilities | Compact.

3. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.

Hopefully the corruption will be gone at this point. If not, follow the
steps for the first symptom in this article to get Access to rebuild it for
you:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Allen,

I created a new database and shut off the options you listed and that fixed
the problem.

Thanks for the help

Regards,
Dave Van Allen
 
Back
Top