jwcolby
jwcolby at colbyconsulting.com
Tue Mar 13 14:00:06 CDT 2012
Boy that says it all. The following discusses the caveats to binding to an ADO recordset. http://www.utteraccess.com/wiki/index.php/Using_ADO I am trying to learn this stuff but it is a pita for sure. Plus because I started back in Access 2000, my framework used DAO for everything, including the recordset clone everywhere. Obviously that is causing issues. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 3/13/2012 1:20 PM, Doug Steele wrote: > John: I came across this blog post today; it may be of interest to you > regarding ADO: > > http://accessexperts.net/blog/2012/03/13/why-using-unbound-forms-are-a-bad-idea > > > Doug > > On Mon, Mar 12, 2012 at 7:32 AM, Dan Waters<df.waters at comcast.net> wrote: > >> I haven't tried using a recordset as the source for a form. But, I think >> that you would need to assign the recordset to the form's Recordsource >> instead of the form's Recordset. >> >> I typically assign a table or query to a form's Recordsource. Then I can >> use the form's recordset to read, update, or delete. >> >> Dan >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby >> Sent: Monday, March 12, 2012 8:00 AM >> To: Access Developers discussion and problem solving >> Subject: [AccessD] Me.Requery doesn't work with ADO bound forms >> >> I am learning the ways of ADO recordset bound forms, IOW creating >> ADO.Recordset objects and assigning that to me.Recordset. It is common in >> DOA bound forms to just do a me.requery whenever you want to requery a >> form. >> AFAICT that no longer works, AFAICT it doesn't do anything. >> >> Me.recordset.requery does does in fact requery the form however it leaves >> it >> with a #Name in every control. So far I am having to rebuild the ADO >> recordset object from scratch and assigning the new ADO.Recordset object to >> me.Recordset to get this to work. >> >> -- >> John W. Colby >> Colby Consulting >> >> Reality is what refuses to go away >> when you do not believe in it >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >>