Errata

Access Database Design & Programming

Errata for Access Database Design & Programming

Submit your own errata for this product.

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