Error Message OLE server or ActiveX Control

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
 
C

Chad Cameron

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
 
C

Chad Cameron

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
 
C

Chad Cameron

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
 
C

Chad Cameron

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
 
G

Gina Whipp

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
 
C

Chad Cameron

The DB is 2000
Access Version is 2000 SP3
WIndows XP Pro Version 2000 SP 3 (from system properties)
 
G

Gina Whipp

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
 
C

Chad Cameron

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
OLE Server and ActiveX Error 0
OLE Server OR ActiveX Control 3
Error: "A problem communicating with OLE server or ActiveX Control 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Office Access the OLE server or ActiveX control" 2
get error trying to load Listview on Access form 1
problem while communicating with the OLE serer or ActiveX control 0

Top