Switchboard to run code

[HVACMAN24]

I'm having problems getting my switchboard button to run a function I created. I'm guessing its something in the way my code is written, the name or something I'm leaving out, but I'm not seeing it. If you have any idea please help me.

I went through the switchboard manager and set the item I want to run code and copy and pasted the function name from the code to the manager so I dont think the problem is there. Now here is what my function looks like:

Public Function ClearContestants()

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryContestantClear"
DoCmd.OpenQuery "qryAirflowClear"
DoCmd.OpenQuery "qryBrazingClear"
DoCmd.OpenQuery "qryCoolingClear"
DoCmd.OpenQuery "qryHeatingClear"
DoCmd.OpenQuery "qryTestClear"
DoCmd.SetWarnings True

End Function

Side note, I would do this through a macro but I dont want the warnings popping up and I didnt know how, if possible, to turn them off in a macro.

Thanks

 

[boblarson]

I went through the switchboard manager and set the item I want to run code and copy and pasted the function name from the code to the manager

Did you put this function into a STANDARD Module, not a form, report, or class module? If not it needs to be so it can recognize it.

Side note, I would do this through a macro but I dont want the warnings popping up and I didnt know how, if possible, to turn them off in a macro.

The same way with SetWarnings but in a macro SetWarnings is the one you want (there is no DoCmd part with it) and if you aren't seeing it in the macro action list you probably are on 2007 or 2010 and need to click the SHOW ALL ACTIONS button on the Ribbon.

 

[HVACMAN24]

I did have the function as a seperate module but it wasnt working for whatever reason.

You were right on with me using 2007 which didnt list the SetWarnings action in the macro design. I thought I even tried typing it in but must not of. I ended up going this route. Thanks a bunch