A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Running a Macro Group



 
 
Thread Tools Display Modes
  #1  
Old September 1st, 2004, 01:34 AM
Michelle
external usenet poster
 
Posts: n/a
Default Running a Macro Group

Help! I have a deadline!

I thought that if you designed a macro group and you have
the group name (say "UpdateInfo") and several macros in
that group (say "Contact", "Client" "Home") with no spaces
in between them, you could run the group macro on an event
(say on the event "On Click" you entered "UpdateInfo") it
would run all three macros because there are no spaces. It
appears that this isn't true, because mine is clearly only
running the first macro in the group. Any advice on how to
run all three? Once again, I thought with no spaces it
would all the macros in a group.

Thank you in advance for your help!



  #2  
Old September 1st, 2004, 02:20 AM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default

MacroGroup names are simply for logical grouping of Macros so that you can
find the Macro (I look after a database with 3000+ Macros written by someone
else and it is a nightmare). When you use the MacroGroup name, only the
first Macro is executed.

Create a Macro "Run3Macros" that uses 3 RunMacro action to run the other 3
Macros and use "Run3Macros" in your OnClick Property.

--
HTH
Van T. Dinh
MVP (Access)




"Michelle" wrote in message
...
Help! I have a deadline!

I thought that if you designed a macro group and you have
the group name (say "UpdateInfo") and several macros in
that group (say "Contact", "Client" "Home") with no spaces
in between them, you could run the group macro on an event
(say on the event "On Click" you entered "UpdateInfo") it
would run all three macros because there are no spaces. It
appears that this isn't true, because mine is clearly only
running the first macro in the group. Any advice on how to
run all three? Once again, I thought with no spaces it
would all the macros in a group.

Thank you in advance for your help!





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending Email To A Group Ron Sommer Outlook Express 4 August 28th, 2004 03:33 AM
Group Naming Group Me Outlook Express 1 August 9th, 2004 05:52 AM
Need Entry Point 18 Help On Access Executable File Jeff Conrad General Discussion 26 July 14th, 2004 06:00 AM


All times are GMT +1. The time now is 12:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.