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.
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:

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
    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)

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:

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.

All Courses

From novice to tech pro — start learning today.