a button to run a macro

[gzimmer@linerlaw.com]

My MSAccess wizard is not working properly. I am trying to create a
button to run a macro. Can anyone tell me the SQL code that I can put
into the event procedure to make it happen?

Thanks!

PS: I am also trying to get a button to open a form and to run a report.

[pietlinden@hotmail.com]

Re: a button to run a macro


gzim...@linerla w.com wrote:[color=blue]
> My MSAccess wizard is not working properly. I am trying to create a
> button to run a macro. Can anyone tell me the SQL code that I can[/color]
put[color=blue]
> into the event procedure to make it happen?
>
> Thanks!
>[/color]
Public Sub RunMyMacro()
DoCmd.RunMacro "MacroName"
End Sub


SQL code? That's for data/table manipulation...

[gzimmer@linerlaw.com]

Re: a button to run a macro

Thanks, my novice nature show's through. But your thing worked.