Automate "Show" Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access 2000 I want to develop an incredibly user friendly way of
creating reports. The table layout is as follows:

Year Quater Data 1 Data 2 Data 3....
1999 1 234 6436 677 ...
1999 2 656 7647 756 ...
2000 1 456 4565 564 ...

I want to be able to allow the user to create a report based on parameters
they enter (i.e., years they are interested in, quarters they are interested
in, and the fields the user selects to be reported on). Of course, I have
figured out how to handle the first two of these issues, but have not been
able to come up with a way to allow the user to indicate which fields they
want reported. My hope is that I could create a check box on a form beside
each of the data fields and if the user turns the check on and then hits a
button, a report will be created that will include only those fields that the
user checked.

Any thoughts on how to achieve this. My first thought was to find a way to
connect the query "show" button to a corresdponding check box, however this
does not seem to be possible.
 
It is an interesting problem. In every instance where I have observed Access
developers trying to provide "simplified reporting" such as you describe, it
has been too simple to be useful, and they ended up giving a half-day
session on "How to Create an Access Report" (tailored to the user's
envirnoment). You might want to consider saving the time and energy you are
putting in, not have to throw away the unsatisfactory, and go right to the
"How to Create..." sessions.

Larry Linson
Microsoft Access MVP
 
Back
Top