Results 1 to 9 of 9
  1. #1
    Brian Gregg is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    6

    Access Editing


    I have a number of Make Table queries that are in a macro. Although I have "unchecked" the confirm button in Access Options>Advanced> Editing section. It still asks to confirm the operation when the macro is run. Can anyone assist please.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Look at the SetWarnings action (make sure to turn them back on).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Brian Gregg is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    6
    Quote Originally Posted by pbaldy View Post
    Look at the SetWarnings action (make sure to turn them back on).
    As I am a complete novice, could you tell me where to find SetWarnings.

    Thanks for the swift reply

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It's a macro action; should be in the dropdown list.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Brian Gregg is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    6
    Many thanks for that, saved me a lot of time

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, and welcome to the site!

    Don't forget what I said about turning the warnings back on after executing the query. It turns off all warnings, like when you make changes to an object.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    Brian Gregg is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    6
    Quote Originally Posted by pbaldy View Post
    It's a macro action; should be in the dropdown list.
    Can't seem to find it in Macro dropdown list. Am I looking in the wrong place.

  8. #8
    Lorlai is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    107
    In the macro screen, you will need to select "Show All Actions" from the Show/Hide category on the Design Ribbon.

    Took me a while to find it!

  9. #9
    Brian Gregg is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    6
    Brilliant, thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. access will not allow editing
    By wthoffman in forum Access
    Replies: 3
    Last Post: 12-18-2010, 02:13 PM
  2. Locked for editing
    By Ted C in forum Security
    Replies: 19
    Last Post: 10-12-2010, 08:32 PM
  3. Editing equations with VBA
    By Alexandre Cote in forum Programming
    Replies: 0
    Last Post: 07-15-2010, 11:13 AM
  4. Replies: 1
    Last Post: 03-13-2010, 12:32 PM
  5. Form for Editing Only
    By Schwagr in forum Forms
    Replies: 4
    Last Post: 03-24-2006, 05:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums