Wrox Programmer Forums
|
BOOK: Access 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Access 2003 VBA Programmer's Reference by Patricia Cardoza, Teresa Hennig, Graham Seach, Armen Stein; ISBN: 9780764559037
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Access 2003 VBA Programmer's Reference 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 December 14th, 2004, 10:35 PM
Registered User
 
Join Date: Oct 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Tips/Tricks - Record Finder Code

This is just a great interface for file maintenance, but I am having a little trouble. NoMatch is DAO - so I used EOF instead - will this work? Also, no such think as FindNext or FindFirst. I had to switch all these methods to just .Find. Don't know if this will work yet because the whole process is hung up on an error message:

"You entered an expression that has an invalid reference to the RecordsetClone property."

The error message refers to "Set recClone = frmCallingForm.RecordsetClone" on pg. 861.

I don't see anything wrong with your code or mine. Do you know what gives. Sure would like to get these processes working 'cause they're such a great design.

Thanks.

Jeff

 
Old January 6th, 2005, 11:37 AM
Authorized User
 
Join Date: Jun 2003
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Please provide a copy of your code. I will check your code to see if there are any errors.

Jennifer D. Taylor
Wiley Technical Support
 
Old January 6th, 2005, 08:07 PM
Registered User
 
Join Date: Oct 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks. I fugured this one out. I did not have a reference established to DAO. After referencing DAO everything worked. Thanks again for the offer to review code.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a zip code radius finder and calculator. baburman ASP.NET 2.0 Professional 4 December 10th, 2007 10:14 AM
Day of week finder mrjaygreene Classic ASP Basics 6 May 13th, 2006 04:43 PM
Tricks with Constraints ebsutherla SQL Server 2000 3 June 6th, 2004 05:28 AM
ASP Speed Tricks humbads Classic ASP Databases 0 July 23rd, 2003 03:44 AM





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