Access 2013 VBA - Setting New Click Event for Controls -

-

I searched everywhere for this, and it looks like a simple improvement, but I do not seem to find a solution Happen. I have many rectangles controls in my Access 2013 form, and I'm creating an OnClick event that manages them all. I've worked on a few different ways, and I think I found the simplest / clear way to do this. I put control in one collection and I change the OnClick event for each control. Here's my problem: Opens the access form and acknowledges that I have changed the event for control, but once I click on the control, it throws an error and will not execute this event.

Error:

"event property setting has generated the following error recorded went expression as the name of a function in the went expressions recorded by the Microsoft Can not get access. "

code: 

  Collection dim CTL as Access.CONTROL set m_colRectangle = new archive for each CTL in Me.Controls Private Sub Form_Load () dim m_colRectangle so ctl.ControlType = acRectangle then CTL .Name = "shpTest" then m_colRectangle.Add CTL, ctl.Name ctl.OnClick = "= TestClick ()" '& lt; --- finished error on this line end next CTL End Sub Private Sub TestClick () MsgBox "Test" End Sub

Alternatively, I have a simple shpTest.OnClick = "= TestClick ()" In the Form_Load e Vent, and does it have any idea that someone produced the same error?

The error message is telling you that access to function TestClick Your TestClick is a sub-method, not a function.

Here is a simple example, which has been tested in Access 2010 and 2013, which shows that the of any control. OnClick can use a function for the property ... but you function . : -) 

  Private Sub Form_Load () Set control as dim CTL CTL = ctl.OnClick Me.Controls ( "txtMathExpresson") = " = TestClick () "set CTL = nothing end sub Private function TestClick () MsgBox" test "end function

my access 2013 trial was a traditional desktop application Note If you access in 2013 Working with webpacks, I do not know what will happen.


Comments

Post a Comment

Popular posts from this blog

winforms - C# Form - Property Change -

-
I have a form that has a property named car A class with many properties. The Properties is being displayed on the current car on the basis of some user actions that are being displayed. So I have to know whether the property has been allocated or set to zero. I'm aware of INotifyPropertyChanged , but in my case I'm not sure that since this change I have changed my car properties car do not want to monitor the property. Any idea how to accomplish this? In advance thank you If you have created a true asset in your class then You should be a great and setter, you can add the code directly to the form property in order to take action on the basis of "form": Public partial category Form 1: form {public form 1 () {InitializeComponent (); } // define car square public class car {public string name = string. Empty; } // private car to keep the value of the current car private variable _car = null; // Property of public form which you can ru...
Read more

java - Messages from .properties file do not display UTF-8 characters -

-
Image
In the form of a title, I can only add that if I enter the html file manually, then it Okay. View Rolver: & lt; Bean id = "templorellolver" class = "org.thymeleaf.templateresolver.ServletContextTemplateResolver" & gt; & Lt; Property name = "prefix" value = "/ web-nf / templates" /> & Lt; Property name = "suffix" value = ". Html" /> & Lt; Property Name = "Template Mode" Value = "HTML5" /> & Lt; Asset name = "cacheable" value = "wrong" /> & Lt; Property Name = "characterEncoding" value = "UTF-8" /> & Lt; / Bean & gt; & Lt; Bean id = "Template Engine" class = "org.thymeleaf.spring3.SpringTemplateEngine" & gt; & Lt; Property Name = "Temploreolar" ref = "Templarolver" /> & Lt; / Bean & gt; & Lt; Bean square = "org.thymeleaf.spring3.view.Thymel...
Read more

javascript - amcharts makechart not working -

-
I am trying to create an amiratars serial chart on my Durandal single page application. This chart was working fine on Chrome browser but it is not working on IE. Can you please help me in this regard. Error while using Amcharts. The Macchart () method does not support the object in this object in IE.
Read more