Results 1 to 2 of 2
  1. #1
    pushpm is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2009
    Posts
    9

    New to Access programming

    What is Err.Description?


    ----------------------------------------------------------------------------
    Private Sub Command16_Click()
    On Error GoTo Err_Command16_Click
    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "Modify and Edit Store Profile"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    Exit_Command16_Click:


    Exit Sub
    Err_Command16_Click:
    MsgBox Err.Description
    Resume Exit_Command16_Click

    End Sub


    ----------------------------------------------------------------------------

  2. #2
    Join Date
    Feb 2009
    Posts
    14
    Your On Error GoTo Err_Command16_Click line tells the code to call MsgBox(Err.Description) when an error condition is caught. Many common runtime error conditions generate an error code and the Err.Description gets a pre-defined text based explanation for the error code.

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

Similar Threads

  1. Access 2000 programming startup options
    By nosaj_ccfc in forum Programming
    Replies: 2
    Last Post: 10-17-2008, 02:18 PM
  2. Programming Language like Access
    By cwf in forum Programming
    Replies: 2
    Last Post: 05-17-2008, 03:02 AM
  3. Access Programming and Access Data Page
    By frmdread67 in forum Programming
    Replies: 0
    Last Post: 03-19-2008, 03:11 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