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