saving report in runtime

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

at runtime, how would I close a report and save it as another name?

I need to open a report in design view, add a few text boxes, close it and
save as another name, then open the report.

I can open it without saving but when the user closes the report it will
prompt to save. Or is there a way to work around it?

Appreciate the help..

Many thanks in advance
Richard
 
On Thu, 12 Nov 2009 12:31:45 +0800, "Richard" <[email protected]>
wrote:

This is problematic in a Production environment, because you will
likely want to deploy a compiled version of your app (.mde or .accde).

One way around it is to have plenty of text boxes on the report, and
show or hide them in the Report_Open event depending on your needs.

-Tom.
Microsoft Access MVP
 
Normally I would just have additional controls on the report. You can set
their visible property to NO and when needed set the visible property to Yes
and assign a value to them for the duration of the report. You can temporarily
change the properties of the controls - such as position and size - as needed.

As long as you do this in VBA and in the Open event of the report you don't
need to switch to design view and you should not be prompted to save the
changes to the design

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top