event dont fire.....then kerplunk!

[mission2java_78]

As usual...access...and my problems with it...

Simple delete button...

behind the button

DoCmd.RunSQL("DELETE * FROM tblAttendes WHERE AttendeID= " & Me.AttendeID.Value)

I click the button...and IMMEDIATELY without even going into the code I get...

The expression on click as the event property setting produced the following error : A problem occurred while MS11 was communicating with the OLE Server or ActiveX Control

The expression m,ay result in the name of a macro, name of a user defined function or [Event Procedure]
There may have been an error evaluting the function, macro, etc...

So my question what the hell is this?

 

[dcx693]

You don't need to enclose the parameters within ():
DoCmd.RunSQL "DELETE * FROM tblAttendes WHERE AttendeID= " & Me.AttendeID.Value

EDIT: Actually, just tested out the syntax with the (), and it actually does work.

Sorry, don't know what's up with that weird error message.

 

[mission2java_78]

You don't need to enclose the parameters within ():
DoCmd.RunSQL "DELETE * FROM tblAttendes WHERE AttendeID= " & Me.AttendeID.Value

So What?

Doing so isn't the problem...

The problem is not even with a specific piece of code...its the entire subform...it keeps coming up with that error message.

Even if I did take the '(' ')' that is not a solution to my problem.

Again...access has HIDEOUS ANNOYING errors..which don't make much sense...

HELLO MS!

Jon

 

[dcx693]

This might help: Access Error. There are a bunch of other posts about a similar error message.

 

[mission2java_78]

This might help: Access Error. There are a bunch of other posts about a similar error message.

My code is all compiled...and im not getting network errors.

WHAT THE HELL ACCESS...SERIOUSLY WHAT GARBAGE!!!!!!!!

Anyone else have any thoughts? Let me guess I have to recreate the form?

HOW PATHETIC!

 

[mission2java_78]

Had to recreate the entire form

JUNK JUNK JUNK ACCESS IS TOTAL JUNK

 

[spacepro]

Jon,
You don't happen to have Norton Anitvirus installed on your pc.

If you have script blocking enabled this can affect the process in access, which is why you are getting an error message.

If not then have you deleted any macros recently or deleted vb code?

Don't be so frustrated with Access, when you know how it's done it's an easy and very adaptable application.

Hope this helps

Andy

 

[Kevin_S]

Andy -

Jon is a "returned from the land of the lost" Access veteran...

He has a strong grasp on programming... he just hates Access

Although I think from the tone of his last few emails hes starting to come around again....

Kev

 

[mission2java_78]

Andy -

Jon is a "returned from the land of the lost" Access veteran...

He has a strong grasp on programming... he just hates Access

Although I think from the tone of his last few emails hes starting to come around again....

Kev

Haha...
yes back to never never land..
where you can never never get good results :|

Hehe

 

[Rich]

He loves me, he loves me not, he loves me, he loves me not........................