Run Access Command

  • Thread starter Thread starter Franky
  • Start date Start date
F

Franky

Can anyone help me out, please?
I can't get this to work:

from in excel i need to run a command on some access form
after the command starts to run I need to wait 6 minutes

Thx
 
assuming you have the command button on that form in Access and that this is
the only way to get results

watch the linewrap on this. all text between the dashes is a single line
-----
getobject("C:\MyPath\MyDB.mdb").forms("frmMyForm").cmdMyCommandButton_Click
-----

it will wait until the procedure on that form completes
that should get you started

maybe if you gave more detail about what you are trying to do other options
could be given

hth
 
Hi, thx for the answer. I need to open that form and click on the command
button. Then a lot of code will be processed. I have to do it from in excel.

I tried your solution but it isn't working
 
Yes, my solution assumed the database and form was opened

I would suggest moving all the code to excel OR access. Why have 2 apps hung
while the procedure completes?

good luck!
 
Back
Top