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 January 26th, 2004, 08:14 PM
Authorized User
Join Date: Jun 2003
Posts: 54
Thanks: 2
Thanked 0 Times in 0 Posts
Default Problem with examples in Access 2002 VBA

I have been trying to bind forms to ADO recordsets the way the book "Beginning Access 2002 VBA" shows.

I have an application that potentially run much faster if I could figure out how to bind the ADO recordset to my forms. I was asked to port the application over to a new LAN running Windows XP on the desktop, NT on the server, and MS-Office 2000.

I tried the examples on page 930 (bombs at the "Set Me.Recordset = rs" line); page 921 (gets err nbr 7965 at the "Set Me.Recordset = rs" line; the example on 919 did retrieve the records into my (continuous) form , BUT, [u]the records cannot be edited</u> (status bar says record is "READ ONLY").

This same form bound to a saved Access query ran fine when the application was on my old LAN. I reference the "Microsoft ActiveX Data Objects 2.7" library in the VBE.

Could this be the problem? Any ideas what I might be doing wrong?

--- Tom
--- Tom

Similar Threads
Thread Thread Starter Forum Replies Last Post
Beginning Access 2002 VBA Chapter 3 Olivia54 BOOK: Beginning Access VBA 3 January 24th, 2006 12:11 PM
Beginning Access 2002 VBA Chapter 5 Olivia54 BOOK: Beginning Access VBA 2 August 16th, 2004 02:20 PM
Beginning Access 2002 VBA Code pajiyar BOOK: Beginning Access VBA 0 July 12th, 2004 08:04 AM
Access 2002 VBA with SQL using a variable cpopham Access VBA 8 December 4th, 2003 04:24 PM

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