Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Access Command
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Access Command
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Access Command
problem solved:
Dim AccApp As Object Dim AccPath As String AccPath = "c:\test.mdb" Set AccApp = CreateObject("Access.Application") AccApp.Visible = False AccApp.OpenCurrentDatabase AccPath AccApp.DoCmd.OpenForm "form1" AccApp.Forms("form1").Command0_Click "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Access Command
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! "Franky" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using SQL command to access Excel | Excel Programming | |||
Access command from Excel | Excel Programming | |||
Add Command to Quick Access Toolbar | Excel Discussion (Misc queries) | |||
vb xls command button access key | Excel Programming | |||
Access a built-In command? | Excel Programming |