Heenan, Lambert
Lambert.Heenan at AIG.com
Wed May 28 12:30:25 CDT 2008
Ahh.... Clear enough. Thanks. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, May 28, 2008 1:15 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] VBA Unbound data entry / update form You can't always use bound forms, Lambert. Actually, when I built this, you couldn't bind a form to an ADO recordset, and that's what you needed to persist the recordset to a file. QED. In the case of the demo though, no database has to be there, so it could be used on a remote machine and the data emailed somewhere to be updated to a main database. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Wednesday, May 28, 2008 8:26 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] VBA Unbound data entry / update form I for one have not looked at the demo. But my guess is that the unbound forms have lots of code that in essence in emulating bound forms. Wheels being reinvented? Lambert :-) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, May 28, 2008 11:02 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] VBA Unbound data entry / update form Did you take a look at that demo, John. It's all unbound. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, May 27, 2008 6:21 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] VBA Unbound data entry / update form > It's beginning to sound like nobody really does it. LOL. It does sound that way doesn't it. Access' bound forms are magical, and most developers who grew up in Access use them. OTOH, old hard core programmers from the bygone era didn't have magic solutions and grew up hard coding solutions. Back in the good old days of the great bound / unbound debate, the secret society of the UHU made all kinds of claims about how unbound was better because.... So I just assumed that now, when I actually needed to do it I could call on some of them to show some code... It is remotely possible that the UHU are all still sleeping off their memorial day celebrations. ;-) John W. Colby www.ColbyConsulting.com Jennifer Gross wrote: > I have no idea how to create an unbound form in Access. I always use > bound forms. Though I would be interested to know how it's done. > Unless I've got it wrong, that seems to be the basic question here - > For those of you who do it, how do you create an unbound form? How do > you populate the textboxes initially and then how do you save the information back to the tables? > > It's beginning to sound like nobody really does it. > > Jennifer -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com