Solved

Macros - Echo & Set Warnings in MS Access 2007?

Posted on 2008-09-29
2
1,942 Views
Last Modified: 2013-11-27
Super-novice here attempting to create a multi-user db in Access 2007 for small office use.  I want to create a macro with Echo & Set Warnings set to No/off.  Why isn't Echo & Set Warnings an option anymore?  Is there an alternative?  Must I change some type of setting in Access Options?  Do I need a digital signature?  Help please.
0
Comment
Question by:CoCoCarrie
2 Comments
 
LVL 18

Expert Comment

by:jmoss111
Comment Utility
You might want to read this before changing SetWarnings. You'll get your answer but you'll also get the downside of of using SetWarnings:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23757151.html

Jim
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 150 total points
Comment Utility
CoCoCarrie,

Well "Super-novice", it appears you are going to have to upgrade your skillset to include VBA.
;-)

The corresponding commands are:

    DoCmd.SetWarnings False
    DoCmd.SetWarnings True
and...
    DoCmd.Echo True
    DoCmd.Echo False

I am presumming you need to toggle these options on the fly, as when you are running an Action Query, because you stated that you used to use macros.
(as opposed to turning the SQL warnings off for the entire database)

JeffCoachman
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now