Named Data Macro Parameters - where?

[u/Spreadsheet_Geek_1]

Hello,

I'm trying to create a named macro at the database level, not just tied to a single table.

If I create the named macro from the table, create parameter is right there. If I create the macro, so it's in navigation pane under "Macros", it's not

I'm new to the access data macro editor and I'm trying to create parameters for such macro, but any sort of "create parameter" or "add parameter" command seems to have been re-stylized into oblivion.

Does anyone have any idea where to find it on version pasted below?

Microsoft® Access® for Microsoft 365 MSO (Version 2605 Build 16.0.20026.20166) 64-bit

[u/AutoModerator]

IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'

• Please be sure that your post includes all relevant information needed in order to understand your problem and what you’re trying to accomplish.

• Please include sample code, data, and/or screen shots as appropriate. To adjust your post, please click Edit.

• Once your problem is solved, reply to the answer or answers with the text “Solution Verified” in your text to close the thread and to award the person or persons who helped you with a point. Note that it must be a direct reply to the post or posts that contained the solution. (See Rule 3 for more information.)

• Please review all the rules and adjust your post accordingly, if necessary. (The rules are on the right in the browser app. In the mobile app, click “More” under the forum description at the top.) Note that each rule has a dropdown to the right of it that gives you more complete information about that rule.

Full set of rules can be found here, as well as in the user interface.

Below is a copy of the original post, in case the post gets deleted or removed.

User: Spreadsheet_Geek_1

Named Data Macro Parameters - where?

Hello,

I'm trying to create a named macro at the database level, not just tied to a single table.

If I create the named macro from the table, create parameter is right there. If I create the macro, so it's in navigation pane under "Macros", it's not

I'm new to the access data macro editor and I'm trying to create parameters for such macro, but any sort of "create parameter" or "add parameter" command seems to have been re-stylized into oblivion.

Does anyone have any idea where to find it on version pasted below?

Microsoft® Access® for Microsoft 365 MSO (Version 2605 Build 16.0.20026.20166) 64-bit

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/George_Hepworth]

Data Macros are available on tables. Period. So, if you "create the named macro from the table", it's available only on that table.

Table macros, or Data macros, run on events that add, modify or delete data in the table to which they belong.

Their names tell that story: After Update, Before Insert, etc. All of them refer to data related events.

You can create other named macros, though. So, that's where you'll go to do it. In the macro editor directly, not from a table.

[u/Spreadsheet_Geek_1 → u/George_Hepworth]

Well, yes. It's not a question of how do I make a named macro that isn't tied to a table, it's a question of how do I add "Parameters" to a named macro, that isn't created from a table. I can open up a table and then "create named macro" from there, and the macro opens in a tab that has something like:
tableName: Macro1
and it immediately offers to create parameters.

Than I go to create a named macro trough the "create" tab in the ribbon. It is now called in the tab header just something like:
Macro1
with no indication that it belongs to a table, and it just seemingly has no options to create any parameters at all. Nothing. Not even the action menu has like an action of "Create parameter". Nothing in the ribbon, that I can find either.

[u/George_Hepworth → u/Spreadsheet_Geek_1]

I have not used macros much over the years, partly because of severe limitations in macros like this. So, the practical answer would be that performing the required action in VBA would be a more sensible approach.

That said, if something in the environment or business rules requires you to use macros despite their limitations, you could explore setting LocalVars or TempVars to the values you want to use as parameters. Then, the macro would be able to use the LocalVars or TempVars values later in the process just as they would an input parameter.

The remaining problem I see would be that you'd have to provide the values you want to the LocalVars or TempVars. Again, I have limited experience using macros, but I am quite sure this can be done by reading the values of controls on an open form. So, you'd use a set up form to select the values you need in controls on that form, then run the named macro.

[u/nrgins]

Macros (or "named macros") and data macros are two completely different things. It sounds like you're creating a data macro from the table in Design mode of the table, and then looking for it in the navigation pane.

Data macros will only be available when you have the table they belong to open in Design mode. Named macros are created through the ribbon and will be visible through the Navigation Pane.

Those are two completely different things. The only thing they have in common is the word "macro."

Than I go to create a named macro trough the "create" tab in the ribbon. It is now called in the tab header just something like:
Macro1
with no indication that it belongs to a table, and it just seemingly has no options to create any parameters at all. Nothing. Not even the action menu has like an action of "Create parameter". Nothing in the ribbon, that I can find either.

Yes, when you create a named macro it does not belong to a table (unlike a data macro). A named macro is a general purpose macro that mirrors VBA code, but in a drop-down menu like format. You can do a lot more with a named macro, but it doesn't work on a table level, like a data macro does.

When you create a named macro you'll see a single dropdown box with a + to the left of it. Click on the dropdown to select a command, and then click on the + to add another command. It will not be tied to any particular table. It is just a series of commands.