Switchboard

[bigbadbess24]

I have two queries. I have a delete query and an append query. Is there anyway that I have these two queries run on a switchboard.

 

[The_Doc_Man]

Yes. Make sure the queries work correctly when run "on their own."

Then use the "Button Wizard" to plotz down a couple of buttons that will run action queries for you. The button wizard has a preset for this function. Note that you must assure that your wizards are enabled in order for this to work. But if they ARE enabled, this is a trivial matter to implement.

 

[Pat Hartman]

You can create a function that runs the two queries and run that function from the switchboard. If you want to run the two queries separately, use two functions. You can turn off warnings in the function to eliminate the messages from the queries but don't forget to turn them back on.

 

[bigbadbess24]

When I try to run a wizard in any selection I can never find the two queries that I created (the delete query and append query) I only see Select queries

 

[bigbadbess24]

I figured it out. I ran a macro to open them both. Thanks for your help