• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2042
  • Last Modified:

Macros - Echo & Set Warnings in MS Access 2007?

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
CoCoCarrie
Asked:
CoCoCarrie
1 Solution
 
jmoss111Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now