Message boxes

[jonboy_t]

Hi all. I am really new to Access so this may sound like a stupid question
to you all!!

I am writing a Macro and when I press 'run', there are a series of about 9 or
10 text boxes pop up and I have to keep clicking 'YES' on all of them before
the Macro runs. I think they are related to the queries that the Macro
contains, but I really don't want everyone who uses the database to have to
press them every time they want to do something.

Is there a way that I can either a) get rid of them completely or b)
incorporate the button pushes into the Macro so Access always answers yes to
them every time?

As I said, probably a really stupid question, sorry if it is!!!

Thanks guys.

 

[KARL DEWEY]

Use macro action Set Message and set to no. If you do not see it then click
on Show All Macro.

 

[KARL DEWEY]

I meant to say set to no. Then add an action at end to turn on again - set
to Yes.

 

[Steve Schapel]

Jonboy,

The macro action that Karl is referring to, which you would put in your
macro before the first OpenQuery, is SetWarnings, not Set Message!

And in a macro, no need really to use SetWarnings/Yes again at the end, as
Warnings automatically reset anyway at the end of the macro.

 

[KARL DEWEY]

You correct.
--
Build a little, test a little.

Jonboy,

The macro action that Karl is referring to, which you would put in your
macro before the first OpenQuery, is SetWarnings, not Set Message!

And in a macro, no need really to use SetWarnings/Yes again at the end, as
Warnings automatically reset anyway at the end of the macro.

 

[jonboy_t via AccessMonster.com]

Cheers chaps!! All better now, I no longer have to click YES 150000 times
before I get anywhere!

Thanks a lot for your help.

You correct.

Jonboy,

[quoted text clipped - 29 lines]