Results 1 to 2 of 2
  1. #1
    DavidLP is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Tennessee
    Posts
    3

    Suppress delete record confirmation

    I am having this problem in an Access 2010 web database. I have a macro set to delete a record but when it does, a delete confirmation message comes up. Even worse, if the user selects yes to delete, an action failed error (#2950) pops up. I would like to suppress the message but in the new macro language I don't see where there is an option to do so. Since it is a web database I can't use VBA. Does anyone have a solution?
    Thanks,


    David

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,954
    According to this article SetWarnings is not compatible in 2010 macro http://office.microsoft.com/en-us/ac...010386888.aspx

    Unfortunately, I can't get to my Access2010 right now to see if there is alternate. It probably has something to do with the new Data Macros in Access 2010.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Trying to Delete record using delete query
    By MooseOTL in forum Access
    Replies: 13
    Last Post: 10-04-2011, 02:30 AM
  2. 2010 delete confirmation
    By mikeb in forum Forms
    Replies: 4
    Last Post: 03-30-2011, 08:53 AM
  3. Confirmation on what I am doing
    By newtoAccess in forum Access
    Replies: 5
    Last Post: 12-10-2010, 01:01 PM
  4. Suppress new record on continuous forms
    By ajetrumpet in forum Forms
    Replies: 0
    Last Post: 09-07-2010, 09:30 PM
  5. suppress subtotals when only 1 record
    By schristy in forum Reports
    Replies: 3
    Last Post: 02-15-2010, 10:00 AM

Tags for this Thread

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