jwcolby
jwcolby at colbyconsulting.com
Tue Jun 10 13:44:26 CDT 2008
> You want code that will work as if the thing was bound. Not gonna happen, roll your sleeves up. I never asked for that, nor do I expect that to happen, your code or mine. Unbound using no locks simply cannot function in the same manner as a bound form creating locks. John W. Colby www.ColbyConsulting.com Charlotte Foust wrote: > Hah! You want code, write your own!! LOL > > You want code that will work as if the thing was bound. Not gonna > happen, roll your sleeves up. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Tuesday, June 10, 2008 10:00 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] VBA Unbound data entry / update form > > LOL, OK. The devil is in the details after all. > > I am not really interested in locking. In my understanding of unbound > forms, you don't hold locks, and if you are, you might as well go bound. > > Which leads us squarely back to update strategies, and testing for > modifications by other users. All that good stuff that the "unbounders" > claim to handle but have never piped up with even general strategies, > never mind code. > > John W. Colby > www.ColbyConsulting.com > > > Rocky Smolin at Beach Access Software wrote: >> Not ignoring. It wasn't an exhaustive treatise on the subject. Just >> a 'how to get started'. Locking: you have to look up record and page > >> locking stuff for DAO. >> >> >> Rocky Smolin >> Beach Access Software >> 858-259-4334 >> www.e-z-mrp.com >> www.bchacc.com >> >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby >> Sent: Tuesday, June 10, 2008 9:07 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] VBA Unbound data entry / update form >> >> Rocky, >> >> I hate to jump all over your method because I want a method to use, >> but you are completely ignoring locking / update issues. What >> happened if another user updated the record between the time you >> loaded yours and the time you write it back? >> >> John W. Colby >> www.ColbyConsulting.com >> >> >> Rocky Smolin at Beach Access Software wrote: >>> I know how to make an unbound form but I haven't got enough nerve to >>> present such heresy - it runs counter to strongly held religious > beliefs. >>> OK - briefly - but you didn't hear it from me. >>> >>> 1. Design your form as you would a bound form but no Control Source >>> in the text boxes. >>> 2. Create a recordset in the Open event of the form (DAO or ADO - I >>> prefer >>> DAO) using pretty much the same SQL or query as you would for your >>> Record Source in a bound form. >>> 3. Add a module to put the fields from the current record of the >>> recordset into the text boxes which you can call whenever you want to > >>> display the data on your form. >>> 4. Add a module to put the values in the text boxes into the fields >>> of the current record (in DAO use .Edit or .Add and .Update) which >>> you can call whenever you want to write the textbox values back to > the table. >>> 5. I always put my own navigation buttons on the unbound for - First, > >>> Last, Next, Previous with Click events that move the recordset point >>> appropriately. >>> >>> HTH >>> >>> Rocky Smolin >>> Beach Access Software >>> 858-259-4334 >>> www.e-z-mrp.com >>> www.bchacc.com >>> >>> >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim >>> Lawrence >>> Sent: Monday, June 09, 2008 5:38 PM >>> To: 'Access Developers discussion and problem solving' >>> Subject: Re: [AccessD] VBA Unbound data entry / update form >>> >>> Hi Jennifer: >>> >>> I have no idea how to create bound Access forms. ;-) The last bound >>> database that I have worked with was back in '97. >>> >>> Jim >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer >>> Gross >>> Sent: Tuesday, May 27, 2008 5:12 PM >>> To: 'Access Developers discussion and problem solving' >>> Subject: Re: [AccessD] VBA Unbound data entry / update form >>> >>> 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 >