Re: Access 2000 Make Table Query Warning Box -- macro to set Echo, SetWarnings

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Jen,

sorry -- thought you wqere running code -- you are just opening action queries I guess...

there are 2 things that affect the messages when you run queries -- they can both be changed with a macro

try this:

click on the macros list in the database window

click the NEW button to make a new macro

'~~~~~~~~~~~~~~~~~~~~~

Save Macro As --> TurnOff

action --> Echo
Echo On --> No

Action --> SetWarnings
Warning On --> No

Action --> MsgBox
Message --> Warnings and Echo are OFF

'~~~~~~~~~~~~~~~~~~~~~
Save Macro As --> TurnOn

action --> Echo
Echo On --> Yes

Action --> SetWarnings
Warning On -->Yes

Action --> MsgBox
Message --> Warnings and Echo are ON

'~~~~~~~~~~~~~~~~~~~~~

before you run action queries, run the TurnOff macro
after you are done, run TurnOn


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

ProCad Jen wrote:
Thanks Crystal. Sorry - definitely non-programmer at the other end of this email discussion..... Where should I put this? and how?

Am I putting it at the beginning of the query code? or somewhere else so that it effects the entire database? I have managed to build without using SQL so far and messing around in the code makes me squeamish to say the least.

Thanks again.

Jennifer

"strive4peace" <"strive4peace2006 at yaho" wrote:


Hi Jennifer

instead of using DoCmd, use this form

currentdb.execute "SQL or action queryname"

this operates as
docmd.echo false
docmd.setwarnings false
docmd.openquery qname
docmd.echo whatever it was
docmd.setwarnings whatever it was


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

ProCad Jen wrote:

I am using Access 2000. I love this program, except.....

I have create a couple of make table queries which ask for input from the user. When this query is run, and before it asks the user for the input, I get a warning message that says that the query is about to replace the table with new data, and is the user ok with that?, yes or no. As the database designer, I know to answer yes, and it goes through the function with no issues.

I don't WANT the warnings to show up, so I went into the Tools>Options>Edit/Find and cleared the "Action Queries" box under the confirm section. I have applied it. I have ok'd it. I have done this on every possible table, query, form etc. that is involved with these two queries. (not that it is a different menu with each one, but I was grasping at straws.) I have restarted the program multiple times. I have rebooted the computer multiple times.

The check boxes are EMPTY, but the warnings keep coming up. Is this a problem with Access? or am I missing something. I will be authorizing non-Access users to enter data into this database; I have been working on this massive user-friendly, smooth-flowing database for almost two months, and I don't want to have to say "just answer "yes" to the warning - I can't make them go away."

If anyone knows of a fix, or SOMETHING to make these things go away, please share!!!

Jennifer


.

Quantcast