My Buttons will NOT work

[klr397]

I am not completly access challenged i have programmed myself many a successful button. Please someone tell me why i would get this message:

The Expression On click you enteresd as the event property setting produced the following problem occured while Microsoft office access was communicationg with the ole server or active X control.


This is my code. for command0

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim stDocName As String
Dim stLinkCriteria As String

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

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub

___________________________________________________________

What am I doing wrong?

 

[klr397]

Anyone? PLEASE help

 

[Bat17]

The code looks ok to me, have you tried a compact and repair on the DB in case there is some sort of corruption?

Peter

 

[klr397]

nope...nothing. I'm going CRAZY

 

[boblarson]

can you zip and post your database? It has to be 393Kb or less after zipping to post here. Otherwise we can PM you with my email address to send it to me.

 

[RuralGuy]

KT,
I've seen this error but can't remember what it takes to correct it. Take Bob up on his offer to look at the db. He knows his stuff! If you can post it here, I'll look at it too.

 

[Oldsoftboss]

The database has been corrupted. Create a new, empty database and import all the objects.

Dave

PS:And backup regularly!

 

[Oldsoftboss]

The Expression On click you enteresd as the event property setting produced the following problem occured while Microsoft office access was communicationg with the ole server or active X control.

communicationg... there's the problem