The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version |
Location |
Description |
Submitted by |
Date submitted |
Printed |
Page 136
The statement 'MsgBox UCase(Donna)' should read: 'MsgBox UCase("Donna")'. |
|
Anonymous |
|
Printed |
Page 245
Example 14-12; A Parameter Query Example |
The code reads:
' Create an SQL statement with parameters
strSQL = "SELECT * FROM BOOKS WHERE_
Price > [Enter minimum price]"
Running the example with this snippet of code in causes an error because, as
is stated on page 154, "It is important to note that a line continuation
character cannot be inserted in the middle of a literal string constant,
which is enclosed in quotation marks."
|
Anonymous |
|
Printed |
Page 247
Example 14-13; A CurrentDb Function Example |
The code reads:
Dim db, dbExtra, dbOriginal As DATABASE
This contradicts the statement on page 158, "We must specify the type for each
variable explicitly" to avoid having db and dbExtra be declared as type
Variant which "generally wastes memory and often results in poorer
performance" (page 159). This code does not actually result in an error
message, but it does seem to be contradict the message that the book is
trying to convey.
|
Anonymous |
|
Printed |
Page 277
|
The last line on the page now reads:
Format(rs!price, Currency) & ")?", vbYesNo) = _
Should read:
Format(rs!price, "Currency") & ")?", vbYesNo) = _
The downloaded code is correct.
|
Anonymous |
|