Microsoft® Access® 2010 Inside Out

Errata for Microsoft® Access® 2010 Inside Out




The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page 25
1st paragraph

The third sentence refers the reader to the beginning of the book for instructions on how to install the sample files from the CD. Those instructions are on page1387 in the Appendix.

Note from the Author or Editor:
Hi Jim, Yes, the instructions for installing the CD sample files are on page 1387 in the Appendix. This was one of the first chapters written and I believe at the time we had this information in the front matter but then changed it to the Appendix. Thanks for catching this.

jim erviti  Aug 03, 2012  Dec 21, 2012
Printed
Page 184
"Name" section at bottom of page

The book says: Clicking this option creates the following fields—Last Name, First Name, Contact Name, and File As. But this only creates the Last Name and First Name fields for me.

Note from the Author or Editor:
The Access product changed what fields were created by this specific Data Type Part apparently late in the product cycle before release. As shown in the screenshot at the bottom of Page 185, at the time of writing for that chapter, that command did in fact create four fields. As it stands now, selecting the Name Data Type Part now only creates two fields - Last Name and First Name.

Anonymous  Jan 14, 2011  Dec 21, 2012
Printed
Page 372
1st paragraph

Instead of "Click on the word Comments" I think it should be "Click on the word Comment" [Singular seems better to me.]

Note from the Author or Editor:
Yes, small typo. This should have said Comment.

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 382
Inside Out

Instead of "backslashes" I think it should say "forward slashes"

Note from the Author or Editor:
Yes, this is indeed a typo. In the Inside Out tip on page 382, it should say: "...type two forward slashes (//) when..."

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 394
3rd paragraph

Instead of [tb]VendorDeliveryDates].[VendorID] I think it should say [tblVendorDeliveryDates].[VendorID] IOW, instead of the bracket, I think it should be the letter l.

Note from the Author or Editor:
This is indeed a typo and occurred during post production. My original manuscript has the text correct. There should be no extra bracket there. The argument in the third paragraph should be: [VendorID]=[tblVendorDeliveryDates].[VendorID]

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 395
5th bullet

Instead of tblVendorDelieveryDays I think it should be tblVendorDeliveryDates.

Note from the Author or Editor:
Yes, this indeed a typo. I think this came during post production. The fifth bullet on page 395 should be titled: tblVendorDeliveryDates

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 395
6th bullet

Instead of tblVendoOrderDays I think it should be tblVendorOrderDates.

Note from the Author or Editor:
Yes, this indeed a typo. The sixth bullet on page 395 should be titled: tblVendorOrderDates

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 398
1st paragraph

Instead of saying "In the After Delete event" I think it should say "In the Before Delete event".

Note from the Author or Editor:
Yes, this indeed a typo. In the Note at the top of page 398, the first sentence should read: "In the Before Delete event...."

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 404
1st sentence

Instead of saying "whenever After Update Access" I think it should say "whenever Access".

Note from the Author or Editor:
Yes, this indeed a typo, but an error during post production phases. My original manuscript for the first sentence on page 404 is correct. The printed book, however, includes two additional words which should not be there. The first sentence on page 404 should read: "The After Update event fires whenever Access completes....."

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 407
2nd paragraph. Penultimate sentence.

I think it should say "as shown in Figure 7-39."

Note from the Author or Editor:
Yes, this indeed a typo. In the second paragraph, the current text is referring to Figure 7-36, but it should be referring to Figure 7-39.

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 435
Last statement on the bottom

It says [ReturnVars]![RVSendEmailOnError] but should it not say [ReturnVars]![RVSendEmailForError]? Both expressions refer to the same thing so I'm not really sure this is an error. However, you probably do want to be consistent with the code in the upper portion of the page which states: If [ReturnVars]![RVSendEmailForError]=True

Note from the Author or Editor:
Yes, this indeed a typo. The very last thing on page 435 should read: [ReturnVars]![RVSendEmailForError]

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 437
1st row

Under Table Name it is blank but I think it should say tblSchedule.

Note from the Author or Editor:
Yes, this appears to be a mistake during copy editing phase. In my manuscript, I have the correct text. This table spans two pages so in the first row of this table on page 437, the word tblSchedule should be listed under the Table Name column, not the second row as it appears in the printed text.

Anonymous  Feb 13, 2011  Feb 17, 2012
Printed
Page 437
Penultimate row in the table

Should it not be Table Name Macro Name tblSettings AdjustSampleData ? Sorry to bombard you with submissions. I know you're busy. I have really learned alot from the Access Inside Out books. Thank you very much.

Note from the Author or Editor:
Yes, there are some missing entries in the table. Instead of the last current item listed in the table, there should be the following two listed: tblSettings AdjustSampleData Dynamically changes some of the sample data dates in the tables. tblSettings GetCurrentValue Gets application settings data from the tblSettings table.

Anonymous  Feb 13, 2011  Feb 17, 2012
Other Digital Version
1046
Part III Chapter 9 Sorting and Searching for Date, Filtering by Selection First Paragraph

I am unable to filter on contiguous columns as described. After selecting the two fields, the option to click "Selection" in the Sort and Filter group on the ribbon is greyed out and I am unable to apply the filter. I tried this choosing the City and State field. I using Access 2010. I am able to sort on one field. Does this method work for two fields?

Note from the Author or Editor:
Hi Alcinda, Thanks for pointing this out. This definitely seems like a change of behavior from when the text was first written. I'm not sure when the product might have changed and/or if this is a product bug. I will do some checking at work to see if this is a known product bug. In the meantime, you can sort on each column one at a time instead of multiple selections.

Anonymous  Jul 22, 2012  Dec 21, 2012
PDF, Other Digital Version
Page 1205
1st paragraph

"block—that you can reference from an event property or a RunMacro maccaction by using only the name of the macro object" Is "maccaction" a new word or should it be "action" or "submacro" or ... what, exactly?

Note from the Author or Editor:
This is indeed a typo that needs to be corrected. This typo is not in the final text manuscript that I have before sending to the publisher. This error occurred somtime during the production phase because my document has the correct wording. The text on page 1205 should read: "--that you can reference from an event property or a RunMacro action by using only the name of the macro object."

Mary Roach  Feb 21, 2012  Dec 21, 2012
Printed
Page 1425
second column, line 28

Index, page 1425, second column, line 28: Raw should be Row.

Anonymous  Oct 12, 2010  Feb 17, 2012
Printed
Page 1425
second column, line 29

Index, page 1425, second column, line 29: Raw should be Row.

Anonymous  Oct 12, 2010  Feb 17, 2012