[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
>