Asked By
jengreat
10 points
N/A
Posted on - 08/11/2011
My warm greetings to all readers in techyv.
I have some issues here to consult. This is about my problem regarding ActiveX function. Whenever I am working on my Microsoft Access task that involves an ActiveX, I receive an error message. Please see below the error message for your reference on the problem.
Microsoft Access
The expression Mouse Move you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.
* The expression may not result in the name of a macro, the name if a user-defined functions, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.
This problem I've encountered does not just happen on mouse activity, but to all scenario that requires the aid of ActiveX. I already re-installed the ActiveX component in my computer, but same problem persists.
Please write some comments.
Thanks.
Problem occurred on ActiveX Control
Hi,
The main verb of ActiveX control is to ask that Microsoft Access activates in its place. Though MS Access supports activation objects in Form view, it will not allow an activation of objects in Design View.
Two methods you can do to view the sheet property of ActiveX control.
-
First is to click the ActiveX control, the selected control. Now in the edit menu, point your cursor to ActiveX control then Control Object then click ActiveX control, control properties.
-
The second is: First is to click the ActiveX control, the selected control. Click the mouse button into the ActiveX control then open the short cut menu. Point ActiveX Control into control object then click ActiveX control, control properties.
Problem occurred on ActiveX Control
In order to solve that problem, you will need to remove any accented characters or special characters that are in the VBA code or in database objects. Some of these include the form sections and report sections which were created in localized versions of Access and they may be containing accented characters or special characters.
For to be able to rename an Access object which contains accented characters or special characters you will need to follow the guidelines below:
-
You will need to start Ms Access, and then you will need to open the database that you want.
-
Then you will right-click on the form or report that you want, and then choose Design view.
-
You will then right-click on the object that you want, followed by Properties.
-
Then navigate to the All tab which is found in the Name box, and there you will need to type a name that does not contain any accented characters or special characters.
-
Once you have done that, and renamed the objects, you will be required to open the Visual Basic Editor to check if the changes you have made appear in the VBA code. You will need to note that some objects may retain the original names, and if it occurs that way you will need to manually rename the objects in the VBA code.
Clair Charles
