Wrox Programmer Forums
|
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
 
Old June 7th, 2005, 03:45 PM
Registered User
 
Join Date: Jun 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 8 Building a SQL String

I'm trying to build a SQL String based on frmCriteria just like the book. As the book suggested, I wrote the following code for cmdApply_Click. But, nothing happens.
Can anyone help?

Private Sub cmdApply_Click()
Dim strSQL As String

If Not EntriesValid Then Exit Sub

 If Not BuildSQLString(strSQL) Then
   MsgBox "There was a problem building the SQL string"
   Exit Sub
End If

 MsgBox strSQL
 CurrentDb.QueryDefs("qryExample").SQL = strSQL
End Sub







Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 4 building error LanceWang BOOK: Professional Java Development with the Spring Framework 0 March 7th, 2008 06:53 PM
Chapter 10 - building objects kscase BOOK: Beginning Visual Basic 2005 ISBN: 978-0-7645-7401-6 5 April 23rd, 2007 04:55 AM
Urgent: Building a java object from XML String,XSD neetukk XML 1 January 5th, 2007 02:19 PM
Chapter 8: Results Table not building Steve Rosenthal BOOK: Beginning Access VBA 1 September 7th, 2004 06:11 AM





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