Gustav Brock
gustav at cactus.dk
Mon Aug 25 01:46:36 CDT 2003
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