Report Edit

  • Thread starter Thread starter gd
  • Start date Start date
G

gd

Hi all,
I am having one report developed in access database(.mdb). In this report
the data is filled from Access database queries.
After filling the data from database and after checking the data in the
report, the user wants to write some comments in report and then Print the
report.

How can he write comments data after filling data from database?
Is it possible to update report in report view or before printing?

Please help me
thanks in advance
geetha
 
Hi all,
I am having one report developed in access database(.mdb). In this report
the data is filled from Access database queries.
After filling the data from database and after checking the data in the
report, the user wants to write some comments in report and then Print the
report.

How can he write comments data after filling data from database?
Is it possible to update report in report view or before printing?

Please help me
thanks in advance
geetha
Click to expand...

A Report has no independent existance, and it isn't editable in this way. It
doesn't actually "contain" any data in the sense you use ("filling the data
from database"); instead it's just a tool for arranging and printing the data
which already exists in your tables.

One trick you can use to display ad hoc user-entered data in the Report is to
use a Form. You can put an unbound textbox on it; let's say you have a form
named frmLaunchReport, with a textbox txtPrintThis. You can put a textbox on
the Report (perhaps in the Report Header or Report Footer) with a control
source

=Forms![frmLaunchReport]![txtPrintThis]

When the report is opened (in preview or print mode) it will incorporate
whatever text the user has typed into the form. It might be convenient to have
Preview and Print buttons on frmLaunchReport so the user can conveniently see
what they'll get - and then get it.
 
Back
Top