Add query-buttons to a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sverre - 25 Mar 2008 10:34 GMT

Hi

I have created a report with drag and drop of 20 queries.

If there is a need to see more details that should be possible for the user
by running other and more detailed queries than the ones used in my report.
Therefore I would like to add "buttons" to this report to make it possible
for the user
to run a more detailed query. Is that possible or should i use another
solution? As there are around 200 queries totally in my database I cannot
require the user to find the appropriate query to run. Easiast would be the
add the button beside the query result in the report or to add the detailed
query-buttons on page 2 of the report.

Many thanks in advance and I hope I have expressed myself clear!
Sverre

Reply to this Message

Allen Browne - 25 Mar 2008 13:14 GMT

You can add clickable command buttons to reports only in Access 2007, and
then only in Report View (i.e. they don't work in Print Preview.)

You are probably better of using a form.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi
>
[quoted text clipped - 16 lines]
> Many thanks in advance and I hope I have expressed myself clear!
> Sverre

Reply to this Message