rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Mon Aug 25 08:25:02 CDT 2003
I was just thankful for the suggestion. Who nows, when William tried it in A97 way back when, his particular situation just wouldn't lend itself well to those particular functions. Stuart acted like it worked fine for him so that gave me a light at the end of the tunnel. Also, since noone else has given any negative reviews thus far, the light seems a little brighter. If nothing else I'll learn something about somthing new (for me anyway) even if it doesn't work for me. Rusty -----Original Message----- From: William Hindman [mailto:wdhindman at bellsouth.net] Sent: Monday, August 25, 2003 7:15 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Prompt to save changes on form with multiple subforms ...could be both :) William Hindman <http://www.freestateproject.org> - Do you want liberty in your lifetime? ----- Original Message ----- From: "Gustav Brock" <gustav at cactus.dk> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, August 25, 2003 2:46 AM Subject: Re: [AccessD] Prompt to save changes on form with multiple subforms > Hi William > > Now that was new! No help here? > Or could it just happen that you succeeded in your second attempt? > > /gustav > > > > ...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 > > > ----- 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 > > >> > ...yeah ...but they actually work in XP :) > >> > > >> > William Hindman > > >> > > Note you can use begintrans/committrans on > >> > > access97/2000/2002, not just 2002. > >> > > > >> > > Stuart > > >> > > > ...if you're using Access 2002 take a look at BeginTrans, > >> > > > CommitTrans, and RollbackTrans in your VBA Help ...HTH :) > >> > > > > >> > > > William Hindman > > _______________________________________________ > 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