ID-10-T question

[The Rev]

Can I run a delete query from the switchboard? I get "there was an error executing the command"

 

[llkhoutx]

On the event of your choice:

docmd.hourglass true
docmd.setwarnings false
docmd.openquery "YouQuery'sName"
docmd.setwarnings true
docmd.hourglass false

The query must be an action query.

 

[pdx_man]

Yes, you can run a delete query from just about anywhere. Try running it from the database window. It should give you a better description of the error.

 

[The Rev]

My macro runs fine from the macro screen, but that rascal switchboard won't run it. What command number should I be using in the switchboard items table. I tried 1,2,3,and 4.

 

[Rich]

I believe 7 is the default value to run a macro, if you look at the code behind the Switchboard the item should be listed

 

[pdx_man]

Oh yeah, not directly, you must run the query from code or a macro. Did you get your other issue resolved? I didn't see any follow-up on that.

 

[The Rev]

I wrote a macro and ran it from my switchboard. Thanks all!!!