Errata for Microsoft® Access® 2010 Inside Out
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. 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 |
|