Can access build a report by using check boxes in a custom form?

M

Mark

Hello...

Thanks for looking at this. I run a military medical clinic and I want to
build a patient health care hand out report application. What I would like
to do is have a custom screen, where my technicians click on check boxes
which are linked to a record in a table or maybe a word document and then
have Access build a custom tailored patient information handout. The report
I envision will be built in sections, so we do not kill trees or waste yours
and mine tax dollars by printing an individual pages for maybe a couple
lines of text. Will Access do this type of thing? I am familiar with Access
but not to the level that I think that this will take. Any help or examples
will be appreciated.

Mark
 
M

Mike Painter

Mark said:
Hello...

Thanks for looking at this. I run a military medical clinic and I
want to build a patient health care hand out report application.
What I would like to do is have a custom screen, where my technicians
click on check boxes which are linked to a record in a table or maybe
a word document and then have Access build a custom tailored patient
information handout. The report I envision will be built in
sections, so we do not kill trees or waste yours and mine tax dollars
by printing an individual pages for maybe a couple lines of text.
Will Access do this type of thing? I am familiar with Access but not
to the level that I think that this will take. Any help or examples
will be appreciated.

If you want to save paper it will be a bit of work but could be done.
Basically you build a query from the form and use that query to either
modify a form in code or run one of a bunch of reports.

The Access Developers Handbook for your version of Access has a lot of
information on this type of report.

Be sure to make available "templates" so a user can select standard sets of
checked boxes.
I.E. "Flu like signs and symptoms"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top