jwcolby
jwcolby at colbyconsulting.com
Tue Mar 13 14:02:10 CDT 2012
> Darn it Doug! We're going to start another BvsU, aren't we? :) Oh ye unholy unbounder! ;) I am actually using DOA bound (to SQL Server) forms across the internet without any issues so far. Sweet stuff! John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 3/13/2012 1:35 PM, David McAfee wrote: > I'll stick with Unbound. :) > > I do use bound controls such as listboxes, but to me, bound causes more > issues. > > Darn it Doug! We're going to start another BvsU, aren't we? :) > > D > > On Tue, Mar 13, 2012 at 10:20 AM, Doug Steele<dbdoug at gmail.com> 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 >>> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >>