Thursday, 3 October 2013

What is the syntax to call parameterized ms-access function from java script?

What is the syntax to call parameterized ms-access function from java script?

I have a function called "test" in module of ms-access. I call this
respective function from javascript. Below is the sample code :
var App = new ActiveXObject("Access.Application")
var fullPath = "Path of accdb file";
App.OpenCurrentDatabase(fullPath);
App.Visible = false;
var sub = App.Run("test"); // i am calling test procedure,
which is public in module and dont require any input
parameter.
This works fine.
Now, I made changes to function test. Function test has a string as input
parameter(ie Public Function test(String as a) As Integer). How to make
call to test function from java script?