Printing Form Help

  • Thread starter Scott_66701 via AccessMonster.com
  • Start date
S

Scott_66701 via AccessMonster.com

I have set up a database that at the end prints out all reports. I am making
a table/form/report that is gonna have optional info on it, which will be
accessed from a optional button that can be clicked within the form. If a
person clicks this button to enter optional information how can i program
access to print that report along with the other reports I have.
 
S

Scott_66701 via AccessMonster.com

Continuing: I guess I could have access print all pages like it does now but
is there a way to get it to recognize that no information was entered for
that one report page and not print it?
 
P

PieterLinden via AccessMonster.com

Scott_66701 said:
I have set up a database that at the end prints out all reports. I am making
a table/form/report that is gonna have optional info on it, which will be
accessed from a optional button that can be clicked within the form. If a
person clicks this button to enter optional information how can i program
access to print that report along with the other reports I have.

I'm making a few guesses, because your description of the situation seems
incomplete...

If you have the list of reports in a Multi-select listbox, you can loop
through the ItemsSelected collection and print each report.

Assuming you have a table of reports you want to print, then you can use the
OnNoData event of each form to just close it and not print anything.

If you want to pass filters to the report(s), you can either build the filter
from controls on an open form or read the filters from a text field in a
table...
 
J

John W. Vinson

I have set up a database that at the end prints out all reports. I am making
a table/form/report that is gonna have optional info on it, which will be
accessed from a optional button that can be clicked within the form. If a
person clicks this button to enter optional information how can i program
access to print that report along with the other reports I have.

Base the report on an appropriate query, and launch it using appropriate code.

For a more detailed answer please post a more detailed question, indicating
something about the structure of your tables, what you want reported, and what
you expect the button to do. You can see your database... we cannot!
 

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