View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
franky franky is offline
external usenet poster
 
Posts: 8
Default Run Access Command

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


"HatesIT" wrote:

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

"Franky" wrote:

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