Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Expert One-on-One Access Application Development
This is the forum to discuss the Wrox book Expert One-on-One Microsoft Access Application Development by Helen Feddema; ISBN: 9780764559044
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert One-on-One Access Application Development section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 13th, 2004, 09:03 PM
Registered User
 
Join Date: Jun 2004
Location: Chewelah, WA, USA.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default tblShippingAddresses

Noticed a discrepancy with the Shipping Addresses table
Page 59, fsubShippingAddresses. Refers to the field ShipAddress. This field is not shown on page 23, although there is a reference to it "… and a set of address fields. Although the address fields could have the same names as the corresponding fields in tblCustomers, I like to prefix their names with "Shipping" or "Ship" so that if the billing and shipping addresses are combined in a query, we won't need to use the table name prefix to distinguish between them." Table is shown in Figure 1.19. Image of the table in design view does not show ShipAddress.

In Toy Workshop (Forms Start) download, the field ShipAddress is not listed with the table. In Toy Workshop (Forms Finish)download it is. Not a big concern, just thought it should be mentioned.

Sue


Sue
Reply With Quote
  #2 (permalink)  
Old June 13th, 2004, 10:49 PM
Authorized User
 
Join Date: May 2004
Location: , NH, USA.
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You stated that "Refers to the field ShipAddress."

I don't see the error here that you are referring to . I don't see a specific reference to a field named ShippingAddress on page 59.

The information in figure 1.19, on page 23, does show the field ShippingAddressID which I am sure is the field to be used. And the field that is shown in figure 2.20 is clearly labeled as the Shipping Address Identifier. And the text in the 2nd last paragraph on page 59 does say "Drag the AddressIdentifier..."

Since this is a new publication, I am pretty certain that we both have the same edition. Can you be more specific about the location of this reference to the field ShipAddress?
Reply With Quote
  #3 (permalink)  
Old June 23rd, 2004, 08:04 PM
Authorized User
 
Join Date: Jun 2004
Location: Cumberland, MD, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sue, there is no doubt in my mind that you are exactly right.

The statement on page 59 "The third subform needed for frmCustomers is based on tblShippingAddresses." clearly implies that the form is bound. Therefore since Figure 2.20 displays "ShipAddress" in a textbox, that textbox is bound to a field named ShipAddress from tblShippingAddresses.

However, ShipAddress is NOT listed as a field in tblShippingAddresses in Figure 1.19. But ShipAddress is listed as a field in Relationships windows shown in Figure 2.1. And as you correctly pointed out. "In Toy Workshop (Forms Start).mdb the field ShipAddress does not exist as a field in tblShippingAddresses (and in fsubShippingAddress). In Toy Workshop (Forms Finish).mdb the field ShipAddress does exist as a field in tblShippingAddresses (and in fsubShippingAddress)."

So, tblShippingAddresses must have been changed (by adding the field ShipAddress), but that change was not mentioned in the text of the book.

Terry Waltz
Reply With Quote
  #4 (permalink)  
Old June 23rd, 2004, 09:59 PM
Authorized User
 
Join Date: May 2004
Location: , NH, USA.
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for pointing that out, tlwaltz.

I should have looked further down the Figure 2.20. I stopped looking at the first two fields.

I now see the field (4th) being referenced. And Figure 1.19 shows ShipDepartment vs. ShipAddress. Figure 2.1 also shows ShipAddress, as so some subsequent Figures of subForms.

So it would seem that Figure 1.19 is the one in error. Other than in Figure 1.19 there seems to be no reference to ShipDepartment. In Figure 1.19, ShipDepartment should be ShipAddress.

Guess this should be added to any errata document that follows, and corrected in next publishing. Good catch Sue!
Reply With Quote
  #5 (permalink)  
Old June 23rd, 2004, 10:45 PM
Registered User
 
Join Date: Jun 2004
Location: Chewelah, WA, USA.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Terry and Bob,
Glad you could confirm the minor problem with tblShippingAddresses. Since, I'm not a programmer by profession or nature, it is sometimes easier to spot something amiss because I'm struggling with it. It is exciting to finally get some areas of Access that have confused me cleared up.

Sue

Sue
Reply With Quote
  #6 (permalink)  
Old July 8th, 2004, 07:06 PM
Authorized User
 
Join Date: May 2004
Location: Kerhonkson, NY, USA.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think the basic problem here is that many of the tables in the sample Toy Workshop database go through changes as the chapters progress, and various techniques are illustrated, so they won't necessarily look the same in Chapter 4 as in Chapter 1 (for example). In Fig. 1.19 there is no ShipAddress field in tblShippingAddresses, but it is there in Fig. 2.20 later on.

Helen Feddema
Kerhonkson, NY
hfeddema@hvc.rr.com
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/
Reply With Quote
  #7 (permalink)  
Old July 8th, 2004, 08:13 PM
Registered User
 
Join Date: Jun 2004
Location: Chewelah, WA, USA.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'll keep the various permutations of the tables in mind. Right now, I'm overcommitted, so going through the book is progressing slowly. I do have some questions, but want to make sure I've really gone through the code and Access/VBA help before asking them. Just asking won't be as helpful.

Sue

Sue
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off




All times are GMT -4. The time now is 03:55 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.