How do I edit a report?

[Guest]

I have created a report in Access and need to be able to edit it. I've created this for a client who used Appleworks in the past. Apparently there was a way of highlighting a portion of the report and hiding that portion, or perhaps deleting it, so she could choose the entries that would print. The report I get with Access is totally static. There is no I-beam curser or way to select any of the information. I only get the zoom tool. How can I make the report so that she can edit it. (perhaps a report isn't the correct way to go - I'm relative new to Access)

 

[Van T. Dinh]

Reports are meant to be printed and not interactive.

You should create Forms for users to edit data before using the data for the
Reports.

--
HTH
Van T. Dinh
MVP (Access)

I have created a report in Access and need to be able to edit it. I've

created this for a client who used Appleworks in the past. Apparently there
was a way of highlighting a portion of the report and hiding that portion,
or perhaps deleting it, so she could choose the entries that would print.
The report I get with Access is totally static. There is no I-beam curser
or way to select any of the information. I only get the zoom tool. How can
I make the report so that she can edit it. (perhaps a report isn't the
correct way to go - I'm relative new to Access)

 

[Guest]

There is no way to highlight portions of a report to print only the selection. However your boat isn't sunk yet.

You can push all of that data to a form and let the user place a check in a checkbox to print that record. Of course, more than 1 record can be chosen and printed. I'd be a good idea to add a yes/no field to your table called "Print". When the user clicks the print button on the form (oh, you'll need to have a print button on the form. haha), a query will look at the table and choose only those records marked for printing, as marked by the user. In other words, the query will take all records whose "Print" value equals true. After the report has printed, an update query would then deselect those records.

I've used this method before, it works beautifully and it is a good solution. If you are quick with Access, it shouldn't take longer than 2 hours to set up, trouble shoot, and perfect.

If you have any Q's for me, my email is: (e-mail address removed)

Tyler

 

[Guest]

Thank you both for your prompt reply - I'll give it a try

 

[Albert D. Kallal]

You can certainly toggle things like the detail section.

Often, i have reports that have a total summary, and also shows all details.
You can simply toggle the display of the details section in the forms
on-load event.

So, you can hide/show details, and make the report show lots of details..or
ONLY the summary.

You then build a nice prompt form for the users.

Here is some screen shots of prompt screens. While none of them have the
show details, they at least give you an idea here.

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html

Here is also some screen shots where in fact you CAN see I used the "show
details" check box idea

http://www.attcanada.net/~kallal.msn/Articles/fog0000000005.html

 

[Steve Schapel]

Design by Sue,

As an alternative to Judy's suggestion, if you want to retain the
report's layout, formatting and graphics, then the approach you have to
take with Access is to control the data printed on the report via
manipulation of the criteria of the query that the report is based on,
rather than directly via the report itself. If the selection of records
is literally ideosyncratic, this may involve adding a Yes/No field to
the relavant table, so that the user can select the records in a form
prior to printing the report.

Access 2007 has more flexible dynamic report features.