Setting Up A Macro to run VBA code

[Lou_Reed]

In the db that I have attached to this post, I am wondering how to setup the RunCode line in the
addMiisingRows-MAC.

The add missing rows function cannot just be called as:



RunCode addMissingRows()

That will not work.

If one looks at the VBA code that would call addMissingRows-MAC
and then the RunCode command within it then it should be obvious the function call
addMissingRows, now has argumenta. That is what I am unsure of.

How do I set this up with arguments in addMiisingRows-MAC.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

For starters, why would you run a macro that runs VBA? Why not just call the function instead of using RunMacro? On your other thread I thought we agreed that you were better off eliminating the macro from the middle.

Second, that function has no arguments:

Function addMissingRows()

[Lou_Reed]

That is exactly what I thought. but, I did not get the feeling that it was a good idea. I reverted to somethings that I knew works, even if it is clumsy. As I said if i use arguments, then how do I change the RunCode command? It cannot be the same as when the RunCode command that calls a function with no arguments. What is different?

Also,U I beleive thta is what I must d when I run the function by just calling it.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

If you look at the pdf files you will see that addMissingRows does have arguments. I included a pdf of the source code to show that to you.

Respectfully,

Lou Reed

[pbaldy]

I'd say it's not a good idea to have the macro in the middle, just for the sake of it. It's clumsy and inefficient. That said, you'd change the RunCode command by adding the appropriate argument(s) inside the parentheses, as I showed on the other thread.

[pbaldy]

The PDF showed the form open event, not the function.

[Lou_Reed]

I think I know the answer to m own question. Just tell me if I am correct. If I run addMissingRpws from a macro the syntax is'

addMissingRows()

and ii it has arguments the syntax is now changed to reflect those arguments.

addMissingRows(argument1,argument2)

Is that all that must be changed?

Any help appreciated. Thanks in advance.


Lou Reed

[Lou_Reed]

Here are two Snagit screenshots. They are pdf files.

One shows a RunMacro command in some VBA code. It is calling the macro that calls the function FormHeading with no arguments.
The second pdf file shows the original RunMacro command calling a macro that calls a FormHeading function that does have arguments.

How do I modify the first pdf file (the one that calls the macro FormHeading-MAC and reflects its arguments)?

Any help appreciated. Thanks in adavance.

Respectfully,

Lou Reed

[pbaldy]

I think I know the answer to m own question. Just tell me if I am correct. If I run addMissingRpws from a macro the syntax is'

addMissingRows()

and ii it has arguments the syntax is now changed to reflect those arguments.

addMissingRows(argument1,argument2)

Is that all that must be changed?

Any help appreciated. Thanks in advance.


Lou Reed

Yes, correct, though I wouldn't use the macro.

[pbaldy]

Here are two Snagit screenshots. They are pdf files.

One shows a RunMacro command in some VBA code. It is calling the macro that calls the function FormHeading with no arguments.
The second pdf file shows the original RunMacro command calling a macro that calls a FormHeading function that does have arguments.

How do I modify the first pdf file (the one that calls the macro FormHeading-MAC and reflects its arguments)?

Any help appreciated. Thanks in adavance.

Respectfully,

Lou Reed

The change wouldn't be in the code calling the macro, it would be in the macro calling the function. But again, why complicate matters with the macro? Just call the function instead of the macro.

[Lou_Reed]

Okay, that seems like a good idea as I said before. However, I wanted to get started on it so I started VBA code to call a macro, then the macro calls a VBA function. It just is a way that I know. Now based on what you say I must have two macros it comes to calling FormHeading function. By that I mean that call it with no arguments and one that calls it with arguments. One macro that call FormHeading cannot do all the work, it must be at least two for the two instances that I just described.

Is this correct?

Also, when I call the function directly in the VBA code it is obviously Call Macro() or Call Macro(arguments1,arguments2, ...) depending on whether the call to the function has no arguments or one or more arguments.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

Okay, that seems like a good idea as I said before. However, I wanted to get started on it so I started VBA code to call a macro, then the macro calls a VBA function. It just is a way that I know. Now based on what you say I must have two macros it comes to calling FormHeading function. By that I mean that call it with no arguments and one that calls it with arguments. One macro that call FormHeading cannot do all the work, it must be at least two for the two instances that I just described.

Is this correct?

Also, when I call the function directly in the VBA code it is obviously Call Macro() or Call Macro(arguments1,arguments2, ...) depending on whether the call to the function has no arguments or one or more arguments.

The function either has arguments or it doesn't, so having 2 macros doesn't make any sense. And again, why bother with the macro? In VBA simply

FormHeading

or

FormHeading 123, "abc"

You can use Call if you want, it then requires parentheses.

[Lou_Reed]

So something like

DoCmd.RunMacro "FormHeading", , ""

would be rewritten as:

FormHeading ", ,""

Any help appreciated. Thanks I advance.

Respectfully,

Lou Reed

Please note that there are three sets of double quotes.

[pbaldy]

Yes, though you only need the arguments if the function requires them.

[Lou_Reed]

Okay, but about those double quotes. What do I do with them? Consider the example that I showed to you.

Respectfully,

Lou Reed