Drop changes done to report

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hi,

I have a report that I do changes to through some code.
After the changes have been done in the code, the report
is previewed.

What I don't want is when the user closes the report,
he/she gets prompted to "Save Changes." I want to be able
to set the "saving" flag automatically to false, so when
the user closes the report, that dialog never shows. How
can I do this?

I know it's possible to do it in a MS Word VBA macro, so
I'm fairly certain it can be done with Access. Just
haven't found that function yet.

So please.... someone help a crazy guy in distress.

TIA,
Eric
 
Eric said:
Hi,

I have a report that I do changes to through some code.
After the changes have been done in the code, the report
is previewed.

What I don't want is when the user closes the report,
he/she gets prompted to "Save Changes." I want to be able
to set the "saving" flag automatically to false, so when
the user closes the report, that dialog never shows. How
can I do this?

I know it's possible to do it in a MS Word VBA macro, so
I'm fairly certain it can be done with Access. Just
haven't found that function yet.
Click to expand...

Are you actually opening the report in design view and applying design
changes on-the-fly? I have never encountered a situation that called for
that. Just what properties are you changing? Many properties of a report
can be changed without being in design view and that automatically makes
them "for this one time only" type of changes.
 
Yeah see the situation is quite strange. I'm using an ADP,
so I have a Strd Proc for my record source. My strd proc.
requires parameters, which I define using a form. The only
problem is, when I change the input parameters or the
report using code in the OnOpen event, the input
parameters don't operate properly. The input paparameters
keep whatever value was set in design mode of the report.
So that's why I open the report in design view, change the
input params., then open the report in preview mode. So
when the user closes the report, I want the report to just
close, not save the changes, and not prompt the user to
save changes.

Does that make any sense??
 
Back
Top