Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > BOOK: Beginning Access VBA
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning Access VBA
This is the forum to discuss the Wrox book Beginning Access 2002 VBA by Robert Smith, Dave Sussman, Ian Blackburn, John Colby, Mark Horner, Martin Reid, Paul Turley, Helmut Watson; ISBN: 9780764544026
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 11th, 2004, 07:40 PM
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ch7 False Value Return on BuildSQLString Function

For those who may miss his post, AlreadyDead has advised that since the tblSales entries are for 1998 and the Creating and Modifying QueryDef exercise in Chapter 7 instructs us to input 2002 dates in the criteria selection form, the MakeQueryDef function will return a value of false. When he/she synchronized the dates, the function worked as expected.

Less frustrating Learning to you!:)

  #2 (permalink)  
Old July 11th, 2004, 09:22 PM
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ooops,
Even though I synchronized the date by querying 01-Nov-98 through 30-Nov-98, both the MakeQueryDef and ChangeQueryDefs continue to return values of false.

Despite the return of false values, however, both queries were created and their designs look exactly like the examples shown on pages 284 and 285. Further, the MakeQueryDef correctly returns Jane's Diner while the ChangeQueryDef returns ll sales.

Does anyone know what might be occurring here?

Thanks.



Similar Threads
Thread Thread Starter Forum Replies Last Post
onclick="javascript: return false" on vista gabrieldcr2 Javascript 2 June 4th, 2008 09:40 AM
How ch. 11 examples return false for ctrlKey? horseatingweeds BOOK: Professional JavaScript for Web Developers ISBN: 978-0-7645-7908-0 1 March 18th, 2008 12:01 AM
Javascript return false won't stop post rstelma ASP.NET 1.0 and 1.1 Basics 9 March 16th, 2006 02:25 PM
return (false) crmpicco Javascript 1 October 24th, 2005 11:39 AM
How to return array value from a function nebpro BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 1 September 29th, 2004 12:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.