Results 1 to 3 of 3

Thread: Error Problems

  1. #1
    Join Date
    Jan 2004
    Location
    Houston, TX
    Posts
    29

    Unhappy Unanswered: Error Problems

    I keep getting this error box when I try to add a delete record button to my continuous form. However, this is the exact same code used for a similar form.

    Does anyone have any suggestions?

    This is the Access Cammand button wizard code generated for this purpose.

    Private Sub Command29_Click()
    On Error GoTo Err_Command29_Click


    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

    Exit_Command29_Click:
    Exit Sub

    Err_Command29_Click:
    MsgBox Err.Description
    Resume Exit_Command29_Click

    End Sub
    Attached Thumbnails Attached Thumbnails error.jpg  

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Re: Error Problems

    Originally posted by MrResearch
    I keep getting this error box when I try to add a delete record button to my continuous form. However, this is the exact same code used for a similar form.

    Does anyone have any suggestions?

    This is the Access Cammand button wizard code generated for this purpose.

    Private Sub Command29_Click()
    On Error GoTo Err_Command29_Click


    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

    Exit_Command29_Click:
    Exit Sub

    Err_Command29_Click:
    MsgBox Err.Description
    Resume Exit_Command29_Click

    End Sub
    In the continuous form for delete a record only select the record and press the delete key, that is all.
    Saludos
    Norberto

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    Delete both the

    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

    and insert this instead:

    DoCmd.RunCommand acCmdDeleteRecord

    Hope this does it.

Posting Permissions

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