You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Now that the hyperlink on Toast and Dialog Box notifications can now be used to open forms and run user defined functions within Access, can this functionality be expanded from accepting only one parameter like this: <a href="ExecuteMe('ThisIsAStringParameter')">Execute me</a> to accepting multiple parameters (taking into considerations their data type) like any of the following:
I played with it and it was able to accept more than one parameters. However, I noticed that it only works for Public Functions and not Public Subs. So for anyone trying to use this, you must change your Public Subs to Functions.
This will work:
Public Function OpenSettings(Parameter1 As String, Parameter2 As Integer, Parameter3 As Double)
'your codes
End Function
This will not work:
Public Sub OpenSettings (Parameter1 As String, Parameter2 As Integer, Parameter3 As Double)
'your codes
End Sub
Now that the hyperlink on Toast and Dialog Box notifications can now be used to open forms and run user defined functions within Access, can this functionality be expanded from accepting only one parameter like this:
<a href="ExecuteMe('ThisIsAStringParameter')">Execute me</a>
to accepting multiple parameters (taking into considerations their data type) like any of the following:<a href="ExecuteMe('ThisIsAStringParameter', 'ThisAnIntegerParameter','etcParameter')">Execute me</a>
<a href="ExecuteMe('frm', 'ProjectID', 'TaskID')">Execute me</a>
<a href="ShowHelpNote('1, 1')">help</a>
Functions like this can be used to call a record with recordID =1 and sub record with record ID = 1 too.The text was updated successfully, but these errors were encountered: