External script to call Command Button Click event handler

[Sean Nakasone]

Hi, I'm trying to use an external script (like powershell, vbscript, jscript) to call the event handler for the click event of a Command button. Using ms-access 2010 on Windows 7 (64-bit). Or to send the click event itself. Can't figure it out. suggestions?

That's the gist of it, but here's more information which might help...

I am able to create a VBA standard module in Access and create a simple wrapper function that calls the event handler, i.e.

Public Function MyWrapperFunction()
Call MyForm.MyPushButton_Click
End Function

I am able to call this wrapper function from an external powershell script, i.e.
$accApp = New-Object -ComObject Access.Application
$accApp.OpenCurrentDatabase("c:\folder\myAccessDat abase.mdb")
$accApp.Visible = $True


$accApp.run("MyWrapperFunction")

But I would prefer to just call the event handler, MyForm.MyPushButton_Click, directly from the external script.

The main reason is because I'm not the developer of the access database, I'm just the developer of the external script.

[June7]

Review https://www.accessforums.net/program...ing-14221.html

[Dal Jeanis]

Hmmm. You need to establish addressability to the form, which is in the Forms collection of the App. The syntax of your script is going to look the same until the last line, which is going to be something like... blagh, I can't find my reference right this second. You'll run down the objects enumerating each step something like this -

App -> Forms -> the one form -> the control -> the method

I'll see if I can find it for you in the morning. Hopefully, someone who's carrying around this stuff in their head (June, RuralGuy?) will have already typed in the right syntax for you by then.

[Dal Jeanis]

See, you can't get quicker than that. June gave it to you before I hit "post quick reply".

[June7]

Just did a quick search in the forum because I remembered dealing with the same topic.

[Sean Nakasone]

Thanks Dal and June7, I was able to drilldown to the Form's COM object and call it's method using JScript.