Riunning A Macro from VBA

Hi:

I am trying to work my way around a problem (refreshing a form and getting new totals). I
think I have the solution, but I need to run an Approcah Macro from V\BA, and am foxed in
doing it.
The name of he Macro is: confirmedTScommit

I Tried :

Run("confirmedTScommit")

and it didnt like that (couldnt find it).

I tried

RunMacro ("confirmedTScommit")

and it liked that even less!

Can anyone tell me the right syntax to run a macro in Access from VBA?


Regards

John Baker

Ladies and Gentleman:

The prior post was messed up in a number of ways, as a result of firing it off without
proper review. I apologize for that, and would like to restate it:

I am trying to work my way around a problem (refreshing a form and getting new totals). I
think I have the solution, but I need to run an Access Macro from VBA, and am foxed in
doing it.

The name of he Macro is: confirmedTScommit

I Tried :

Run("confirmedTScommit")

and it didn't like that (couldn't find it).

I tried

RunMacro ("confirmedTScommit")

and it liked that even less!

Can anyone tell me the right syntax to run a macro in Access from VBA?


Regards

John Baker

John Baker <Baker.JH@Verizon.net> wrote:
[color=blue]
>Hi:
>
>I am trying to work my way around a problem (refreshing a form and getting new totals). I
>think I have the solution, but I need to run an Approcah Macro from V\BA, and am foxed in
>doing it.
>The name of he Macro is: confirmedTScommit
>
>I Tried :
>
> Run("confirmedTScommit")
>
>and it didnt like that (couldnt find it).
>
>I tried
>
>RunMacro ("confirmedTScommit")
>
>and it liked that even less!
>
>Can anyone tell me the right syntax to run a macro in Access from VBA?
>
>
>Regards
>
>John Baker[/color]

DoCmd.RunMacro

Mike Storr
www.veraccess.com


"John Baker" <Baker.JH@Verizon.net> wrote in message
news:l2ki10dfleee86kq9fjhf0lcs9pt92284k@4ax.com...[color=blue]
> Hi:
>
> I am trying to work my way around a problem (refreshing a form and getting[/color]
new totals). I[color=blue]
> think I have the solution, but I need to run an Approcah Macro from V\BA,[/color]
and am foxed in[color=blue]
> doing it.
> The name of he Macro is: confirmedTScommit
>
> I Tried :
>
> Run("confirmedTScommit")
>
> and it didnt like that (couldnt find it).
>
> I tried
>
> RunMacro ("confirmedTScommit")
>
> and it liked that even less!
>
> Can anyone tell me the right syntax to run a macro in Access from VBA?
>
>
> Regards
>
> John Baker[/color]