setwarnings not working

[Dgrazynski]

Hi All,

I am using Access 2013 (the newest access, just downloaded online) and can't seem to get this to work.
I have a series of SQL queries that when they run it gives me the pop-up of "pass=through query..."



I want to include these queries into a macro so that I don't have to continuously run each query. I have the current setup:

setwarnings No
Echo No
OpenQuery Query 1, View Datasheet, Data Mode Edit
.
.
.
Echo Yes
setwarnings Yes


I have tried everything and also went to the trusted settings and made sure to add all the locations on my computer. Does anyone have any solutions?

Thanks in advance.

[pbaldy]

What's the actual message? SetWarnings will stop the usual 2, which are something like "You're about to run an update..." and "The query will update x records" or something like that. Pass through is not something mentioned in the usual messages.

[Dgrazynski]

Sorry, forgot to mention that.

The macro stops running on the first openquery with the error code 2950

The dialog box that pops up before that is the "pass-through query with returnsrecords property set to True did not return any records" So I was hoping that the setwarning No will just bypass that dialog box.

[pbaldy]

I don't think so (well, I guess it won't since it's not). Is there a reason you don't change that property of the query?

[Dgrazynski]

How do I get rid of that property (pop-up box) in the query?

[pbaldy]

Presuming it's an actual pass through query, "Returns Records" is a property of the query. Try changing it to No.

[Dgrazynski]

Oh yeah...wow. Thank you so much! Can't believe I didn't do that an hour ago.

[pbaldy]

Happy to help and welcome to the site by the way!