Data Entry allowed in a Report, Or a button?

[ordendelfai]

I have an access 97 report that runs from a button in a form. It shows the delinquent accounts that collection represenetatives are working on, and the notes they have entered so far to date for each account. I have been asked to add functionality into the report so that senior management has the their own text box called "Supvr Notes" that they can enter their own comments directly on the report.

I have looked all over and cannot find a way to do this. I added an extra field in the table called "Supvr Notes", but when the report is opened in print preview, the mouse is a zoom, and cannot click in the control box for the new field.

I tried adding a button in the detail section that would open a form if clicked and display that record with the supvrs notes section, but the "data" and "event" properties section of the button are empty so I cannot find a way to attach code to the button, much less a way to allow the user to click the button in print preview.

Thanks for any advise you may have!!!! =)

Joel

 

[VicM]

Joel:

Reports are just that, reports. There are no active controls to put in a report. All the textboxes used to print out the data in the report do not have Events associated with them.

My suggestion is to put another button on your Form which will open another form asking for the Supv Comments. And that form can have a 'Get Report' button which is coded to the report using a different recordset which then includes the Supv Comments.

If you don't need to keep a record of the historical Supv Comments for past reports, then it's not necessary to input their comments into a table. Just code the report's recordset to look for the opened form containing the comment and add it's textbox data to the recordset so that it appears on the report.

Be sure that you put the report's control for the comments in a header or footer, or any group's header or footer that will not be repeated on the form. If you put the control in the detail section, the comment will print out for every record on the report.

This can get tricky if you want to keep the historical Supv Comments for past reports. In that case you will have to come up with a way of assigning the comments to every record that is used for the report. That can take a bit more design and coding.

HTH,

Vic

 

[ordendelfai]

Hi Vic, thank you much . I had a feeling thats what I would get. I was hoping that the button in the reports menu called "code" would allow me to place a button in the detail section for each delinquent account (record). Actually, I can place a button in the report, but like you said, there is no way to assign it to an event (or so it seems).

I actually do need to store the supv comments, for each individual records, so the supv notes would go in the detail section of the report, similar to the regular notes. I know how to do all of this, and make a form that will look similar to the report. I was just hoping to have a way for the supervisor to directly add comments while looking at the report.

Thanks =)

Joel