Interactive report - insert comment (like Excel)?

[Mikael Lindqvist]

Hi,

I REALLY like and appreciate how much more flexible and faster it is to
create professional reports in Access 2007 compared with Excel, but (there's
always a "but") at the same time reports in Access are indeed static?? That
is to say, a part from basic sorting and filtering what else can the user do
to interact with the report?

(Here I'm thinking "click to drill down", input data / comments)

WHAT I NEED

I have created a profit and loss account (crosstab query) and since this
kind of report is work material I really need to input comments to some of
the numbers (data) that is presented in the report.

In fact, I would really like the comment to be "on top" of the field, just
like Excel, where it pops up when you hover the mouse over it.

Can it be done?

Also, if someone knows more about "report click and drill down" I would
really like to hear that as well (if it can't be done with 2007 maybe in next
version?).

Kindly,
Mikael
Sweden

(my temporary solution to this "comment input" in the report is to create a
seperate table where I write the comments and then connect this "comment
table" to the query and display the comments in a seperate column in the
report (that is, horizontally I have the "periods, jan-dec" and at the end
"comments". Vertically are the P&L accounts).

 

[Dale Fye]

Mikael,

Reports are not designed with the functionality you seek.

Your best bet is to add this functionality to the form where you enter your
data. Then, you could design your own popup menu and assign it to those
controls where you want the abilty to add a comment. Of course, you would
have to create a table that would keep track of the form, record (PK of the
record being edited), control or field you want the comment tied to, and the
comment. You would then have to design a method to display the comment flag
and display it next to those fields where a comment is attached.

Another method would be to create the popup menu for the report, which would
allow you to review the report, and popup a menu that would allow you to add
comments to the record being reviewed. You could then include those new
comments in a comments section of your report.

 

[Steve]

Look in the Help file for the Current event of a report in Access2007. This
functonality is new in this version and can be programmed to do just what
you want. You can click on a record in an Access2007 report and the current
event fires. You can put code in this event and it will execute.

Steve
(e-mail address removed)