+ Reply to Thread
Results 1 to 2 of 2

Set Warnings off in Access macro

  1. #1
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Set Warnings off in Access macro

    I have an access database that contains many update queries. In one instance I run 10 update queries to update one table field. I have created a macro with the macro developer that contains the 10 update queries. Long ago when I worked with '97 access and recall a command set warnings that I put in the macro. Now with 2007 I don't see it. I DO NOT WRITE CODE OR DO VB. I checked help and it appears that set warnings is still an option but i cannot find it anywhere under the Action column. Help alludes to it and notes... "click yes (to turn system messages) or no (to turn off system messages) in the warnings on box in the action arguments section of the macro builder pane, the default is no.
    Under design view I've gone through every selection under action in the dropdown but cannot find it that gives me any selection under "action arguments" that gives me an option for warnings on or off.
    Any help?

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Set Warnings off in Access macro

    FOUND it, had to click on show all actions under the design tab and set warnings appeared in my dropdown list.
    so solved it myself.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1