Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    create macro group (Access2000/2003)

    I must be particularly obtuse this morning; I see newsgroup articles discussing "macro groups", but the Access 2000 & 2003 help files don't give much of a clue what they are.
    A search of this forum doesn't turn up much (but see "obtuse" above).

    I am familiar with VBA in general.

    1) Is a "group" of macros what the rest of call a "project module"?
    2) What, if any, are the advantages of specifying that a macro belongs to a group?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: create macro group (Access2000/2003)

    In Access, a macro means something different than in other Office applications.
    In Word, Excel etc., a macro is a procedure (Sub) without arguments in a standard module.
    In Access, a macro is a separate kind of database object. Macros have their own section in the database window. You can use a limited set of 'actions' in a macro.
    See About macros and macro groups for an explanation of what a macro group is.
    You can group macros in a single macro object for much the same reason you group VBA procedures and functions in a module.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: create macro group (Access2000/2003)

    > See About macros and macro groups for an explanation of what a macro group is.
    What's a supernym for Obtuse? Thanks Hans.

    In the time-honoured tradition of calling it "learning" I managed to get a group together.
    The group is called "Games" (It's lunchtime!)
    The group "Games" has four macros, based on the style of games.
    Some macros have more than one action.
    Whoop-de-do!
    I suppose it is typical of MSoft that "macros" doesn't mean what "macros" means elsewhere in Microsoft
    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •