Error Message OLE server or ActiveX Control

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

Chad Cameron

Hi All,

I am getting this error.

The expression On Click you entered as the event property setting produced
the following error: A problem occurred while Access was communicating with
the OLE server or ActiveX Control.

Everything was fine. I just created a new button to open another form. It
worked a couple of times, but now none of my buttons work. If I create a
new button it also fails.

I didn't change anything.

Any ideas?
Chad
 
Still haven't figured out the problem.
I created a new button and let the wizard attach the form to open and it
failed.

I delete the code and remove the event procedure and create a macro and it
works fine. So, if you have an idea what is causing it, great, if not, that
is my work-around

Chad
 
Thanks Gina

I probably should have mentioned that I tried a bunch of those already. Our
systems at work are quite locked down, so I could only try a the items are
really had no impact on the system settings.

Chad
 
I don't think it is the code. Just because it use to work. Then it just
quit. I cannot remember exactly what I did, but I know it was some form
manipulation. I don't know too much about access yet, so all my changes
were very simple.
Chad

Private Sub Command8_Click()
On Error GoTo Err_Command8_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmAddCompany"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command8_Click:
Exit Sub

Err_Command8_Click:
MsgBox Err.Description
Resume Exit_Command8_Click

End Sub
 
Visual Basic for applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
 
Chad you said this was a 2003 database... sounds like it has been converted
up... OR is Access 2003 but the database is 2000? If the database is 2003
then follow the instructions below...

MAKE A BACK-UP MAKE A BACK-UP

Uncheck Microsoft ActiveX Data Objects 2.1 Library and check Microsoft
ActiveX Data Objects 2.5 Library and...
Uncheck Microsoft Access 9.0 Object Library and check Microsoft Access 11.0
Object Library

If the database is 2000 change nothing but let know what version of Windows.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
The DB is 2000
Access Version is 2000 SP3
WIndows XP Pro Version 2000 SP 3 (from system properties)
 
Chad,

Try MAKE A BACK-UP first...

Make sure Track Name AutoCorrect is off first... uncheck the ActiveX
reference then Compact & Repair. If not go... make a new database and
import all the object into it.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Sorry Gina for the long delay. I have a workaround and I don't want to
fight with trying to fix it.

Thanks for your efforts
Chad
 
Back
Top