Could someone please give me a pointer to what I'm doing wrong? I cannot get the following code to work; p423 and p424. It seems that there should something after the "&" before Err.Description:

[codePrivate Sub cboActivityType_AfterUpdate()
On Error GoTo Error_Handler

    SelectRecords
    cboActivityType.Requery

Exit_Procedure:
    On Error Resume Next
    Exit Sub
Error_Handler:
    MsgBox "An error has occurred in this application. " _
    & "Please contact your technical support person " _
    & "and tell them this information:" _
    & vbCrLf & vbCrLf & "Error Number " & Err.Number & ", " &
Err.Description , _
    Buttons:=vbCritical, Title:="TestWorklog"
    Resume Exit_Procedure
    Resume

End Sub][/code]

Err.Description , _
    should be on the same line as the text above it, like so:

& vbCrLf & vbCrLf & "Error Number " & Err.Number & ", " & Err.Description , _

Also, remove "[code" from the first line, and "[/code]" from the last line.


Graham R Seach
Microsoft Access MVP

Has this been submitted as an errata?

Terry Waltz

Terry,

Chapter 14 isn't one of mine, but although I agree the offending line should perhaps have been split before Err.Description, I don't think it constitutes errata.

Kota possibly doesn't know what a line-continuation character is, or what it's for. Perhaps (s)he just missed it. That's OK, (s)he's now learned something useful. I'm afraid I don't know where came from; they aren't in the book.

Nevertheless, if you feel this is an error, then please feel free to submit it.

Graham R Seach
Microsoft Access MVP

Now that constitutes errata! I forgot that this is an HTML forum, so some text was omitted from my last post. What I meant to say was...

I'm afraid I don't know where {code} and {/code} came from; they aren't in the book.

Graham R Seach
Microsoft Access MVP

this is a test

this is another test