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 <Ba******@Verizon.net> wrote:
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