[AccessD] Prompt to save changes on form with multiple subfor ms

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