macro executed in control panel

Question

Hello!!! I am trying to create a control panel with different options. In one of the options or items I want to associate a macro to be executed when selecting it. However, although I have them defined when I try to select one of them, it does not appear in the list the “control panel” offers/shows. In fact, none appears.

A hint: the macros are listed as modules together with the forms, tables, etc

What could it be the issue?

Thanks for the answer.

Answer 1

Maybe there is a difference in the language version you are using. But in every version of Access I have used macros and modules are different. Modules contain functions and procedures of VBA coding. When addressing a function or proc you use the name of the function or proc. Macros tend to contain a single functionality. And are called by the name of the macro.

ok Thanks.

Answer 2

This doesn't really help. By "control panel" I believe you are referring to either a menu form or switchboard. If you want to run a macro upon clicking on a button on a form, you can use the RunMacro method (DoCmd.Runmacro "macroname") Or you can put the macroname in the On Click property.

If you are referring to the Nav Pane, I do not recommend exposing the Nav Pane to users. While its fine if you are the only user, it gives other users too much access into your application.

many thanks scott!!!!

Answer 3

This doesn't really help. By "control panel" I believe you are referring to either a menu form or switchboard. If you want to run a macro upon clicking on a button on a form, you can use the RunMacro method (DoCmd.Runmacro "macroname") Or you can put the macroname in the On Click property.

If you are referring to the Nav Pane, I do not recommend exposing the Nav Pane to users. While its fine if you are the only user, it gives other users too much access into your application.

Answer 4

Can you post a screenshot please.

Yes Daniel. Here it is:

Answer 5

Can you post a screenshot please.