Macro Will Not Rerun

[KrissyB]

I have built a switchboard that contains 4 buttons, each that runs a different query. I want one of the buttons to be rerun as many times as the user needs to utilize it. However, at the current time, I run the macro, it performs, then reverts to switchboard (perfect) but will not let me run it again. Any reasons why this happens or how to fix it would be appreciated.

The macro currently is very simple:

setwarnings
openquery
openquery
sendobject
close

Thanks

Christine

 

[pbrown2]

This may not be a fix but I have noticed that if SetWarnings (No) is used at beginning, usually it is required at the end SetWarnings (Yes). There have been a couple of reports/queries that acted as you described until the last SetWarnings was inserted.

As mentioned, I don't know if this will fix it off the bat, but it seemed to fix the difficulty in my report/query.



Thank you for any and all help,

PBrown