The "prudential rule of housekeeping" applies: "If you change the
setting of a global attribute within a procedure for use just within
that procedure then change it back to the prior state before leaving
that procedure". It isn't always clear when something is global.
Assume everything is global unless you know different.
In every procedure in which you Set Warnings Off, be sure to Set
Warnings On before leaving the procedure. That will leave the Options
you selected in force all the rest of the time.
Your Set Warnings On should be in the code after the MyProcedure_Exit:
label. Make sure that every exit from the procedure is via that
label, Even your Error path should exit via the MyProcedure_Exit:
label.
HTH
--
-Larry-
--
"AccessHelp" <(E-Mail Removed)> wrote in message
news:A937B2A4-F055-4AF2-9909-(E-Mail Removed)...
> Hi Cheese_whiz,
>
> Thanks for the response. I checked the Confirm section of
Edit/Find, and
> "Record Changes", "Document Deletions" and "Action Queries" boxes
are
> checked. Is there anywhere in Access to turn it back on? Now, even
when I
> close the forms, it does not prompt me to save them.
>
> Thanks.
>
> "Cheese_whiz" wrote:
>
> > Hi AH,
> >
> > In 2003 (at least), you can go to Tools>Options>Edit/Find and look
under
> > 'confirm' and there is a place for 'action queries'. Check that
to confirm
> > before running action queries.
> >
> > Hope that helps,
> > CW
> >
> > "AccessHelp" wrote:
> >
> > > Hello all,
> > >
> > > For some reason, my Access database database does not prompt me
any messages
> > > when I run my Append or Update query.
> > >
> > > Has anyone had this kind of experience? How can I make it to
prompt me again?
> > >
> > > Thanks.
|
Similar Threads
