G
Guest
Good Morning.
I am creating a new form which has never worked. I open a form that has
several command buttons. One of the buttons has a OnClick[event procedure]
which causes an error when pressed. Another of the command buttons executes
a macro which opens a second form. Form2 also has command buttons. One of
the buttons on form2 has a OnClick[event procedure] which works as expected
sending me to my VB procedure.
I have tried several OnEvent buttons (OnClick, OnGotFocus, OnEnter, etc.) on
Form1 and all give the same error message. The procedures were only one line
of code to eliminate "bad code" causes.
The primary error message is: “The expression On Click you entered as the
event property setting produced the following error: A problem occurred while
Microsoft Office Access was communication with the OLE server or ActiveX
control.â€
I am using MS 2007 to create an .mdb database. I tested the DB on a copy of
MS 2003 and got the same result.
Any help would greatly be appreciated!
I am creating a new form which has never worked. I open a form that has
several command buttons. One of the buttons has a OnClick[event procedure]
which causes an error when pressed. Another of the command buttons executes
a macro which opens a second form. Form2 also has command buttons. One of
the buttons on form2 has a OnClick[event procedure] which works as expected
sending me to my VB procedure.
I have tried several OnEvent buttons (OnClick, OnGotFocus, OnEnter, etc.) on
Form1 and all give the same error message. The procedures were only one line
of code to eliminate "bad code" causes.
The primary error message is: “The expression On Click you entered as the
event property setting produced the following error: A problem occurred while
Microsoft Office Access was communication with the OLE server or ActiveX
control.â€
I am using MS 2007 to create an .mdb database. I tested the DB on a copy of
MS 2003 and got the same result.
Any help would greatly be appreciated!