William Hindman
wdhindman at bellsouth.net
Sun Aug 24 22:24:47 CDT 2003
...hhhmmm ...don't rightly remember Rusty ...sorry ...I know I experimented with them in '97 for a client but could never get the code to do what I expected and there was no help here or from MS ...so I cursed vividly, then dumped them ...but in XP they just work. William Hindman <http://www.freestateproject.org> - Do you want liberty in your lifetime? ----- Original Message ----- From: <rusty.hammond at cpiqpc.com> To: <accessd at databaseadvisors.com> Sent: Sunday, August 24, 2003 10:26 PM Subject: RE: [AccessD] Prompt to save changes on form with multiple subforms > Thanks for the input but would like to know what drawbacks you've come > across in Access 97. > > -----Original Message----- > From: Stuart Sanders [mailto:stuart at pacific.net.hk] > Sent: Saturday, August 23, 2003 12:44 AM > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] Prompt to save changes on form with multiple > subforms > > > In what way? Can't say I have researched this extensively, but I have used > them on the odd occasion as far back as Access 97 and > they worked as I expected. Or at least appeared to... > > Stuart > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > > William Hindman > > Sent: Saturday, 23 August, 2003 12:39 PM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Prompt to save changes on form with > > multiple subforms > > > > > > ...yeah ...but they actually work in XP :) > > > > William Hindman > > So, then, to every man his chance -- to every man, regardless > > of his birth, > > his shining golden opportunity -- to every man his right to > > live, to work, > > to be himself, to become whatever his manhood and his vision > > can combine to > > make him -- this, seeker, is the promise of America. > > -- Thomas Wolfe > > > > > > > > ----- Original Message ----- > > From: "Stuart Sanders" <stuart at pacific.net.hk> > > To: "'Access Developers discussion and problem solving'" > > <accessd at databaseadvisors.com> > > Sent: Saturday, August 23, 2003 12:02 AM > > Subject: RE: [AccessD] Prompt to save changes on form with > > multiple subforms > > > > > > > Note you can use begintrans/committrans on > > access97/2000/2002, not just > > 2002. > > > > > > Stuart > > > > > > > -----Original Message----- > > > > From: accessd-bounces at databaseadvisors.com > > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > > > > William Hindman > > > > Sent: Saturday, 23 August, 2003 7:06 AM > > > > To: Access Developers discussion and problem solving > > > > Subject: Re: [AccessD] Prompt to save changes on form with > > > > multiple subforms > > > > > > > > > > > > Rusty > > > > > > > > ...if you're using Access 2002 take a look at BeginTrans, > > > > CommitTrans, and > > > > RollbackTrans in your VBA Help ...HTH :) > > > > > > > > William Hindman > > > > So, then, to every man his chance -- to every man, regardless > > > > of his birth, > > > > his shining golden opportunity -- to every man his right to > > > > live, to work, > > > > to be himself, to become whatever his manhood and his vision > > > > can combine to > > > > make him -- this, seeker, is the promise of America. > > > > -- Thomas Wolfe > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > From: <rusty.hammond at cpiqpc.com> > > > > To: <accessd at databaseadvisors.com> > > > > Sent: Friday, August 22, 2003 3:28 PM > > > > Subject: [AccessD] Prompt to save changes on form with > > > > multiple subforms > > > > > > > > > > > > > I have a form that is used to setup billing parameters and > > > > fees. This > > > > form > > > > > has multiple subforms on a tab control with each > > subform handling > > > > different > > > > > fee types and how those fees are setup. The subforms are > > > > all showing in > > > > > datasheet view. > > > > > > > > > > I now have a request to prompt the user if they want to > > > > save their changes > > > > > (if they have made any) before they close the main form. > > > > They don't want > > > > to > > > > > be prompted after each record change, only after they have > > > > made their > > > > > changes in each subform and possibly multiple records in > > > > each subform. > > > > > > > > > > The only idea I have so far is to populate a tempory > > table with the > > > > > oldvalues of the fields they change, then when they go to > > > > close the main > > > > > form, if there are entries in the changes table, prompt > > > > them if they want > > > > to > > > > > keep the changes, if not, build a SQL statement based on > > > > the values in the > > > > > temporary table and run it to set the values back to the > > > > originals. Does > > > > > this sound feasible or is there a better way? > > > > > > > > > > TIA > > > > > > > > > > Rusty > > > > > rusty.hammond at cpiqpc.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 > > > > > > > > > _______________________________________________ > > 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 >