By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Riunning A Macro from VBA

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
DoCmd.RunMacro

Mike Storr
www.veraccess.com
"John Baker" <Ba******@Verizon.net> wrote in message
news:l2********************************@4ax.com...
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.