Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    48

    Unanswered: Deleting a record with RunCommand

    Hi,
    I am deleting a record using Application.RunCommand acCmdDeleteRecord
    It brings up the default Access message box with a YesNoHelp. Is there a way that I can use my own message box?

    Thanks

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Rough outline would be:

    DoCmd.SetWarnings False ' shuts down Access' warnings

    'Your Custom Message Box here; Yes/No, whatever

    If Yes

    Application.RunCommand acCmdDeleteRecord

    Else

    ' Do whatever

    End If

    DoCmd.SetWarnings True 'Turns Access' warnings back on! A must do!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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