Access Database Design & Programming
by Steven Roman


Unconfirmed error reports are from readers.  They have not yet been 
approved or disproved by the author or editor and represent solely the
opinion of the reader.

If you have technical questions or error reports, you can send them to 
booktech@oreilly.com. (Please specify the printing date of your copy.)


This page was updated December 28, 2000.


Here's a key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


UNCONFIRMED errors and comments from readers:


{136} The statement 'MsgBox UCase(Donna)' should read: 'MsgBox UCase("Donna")'.


[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."


[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.


(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.