[AccessD] Prompt to save changes on form with multiple subforms

William Hindman wdhindman at bellsouth.net
Sun Aug 24 22:24:47 CDT 2003


...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
<http://www.freestateproject.org> - Do you want liberty in your lifetime?


----- 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
>
> > -----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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list