C
Can Of Worms
What I am trying to do:
I want to enable the users of my front end interface to send the records
that they see in a SubForm to the printer for printing. Simple enough? Not
quite...
What I have:
Within my front end interface, Users are identified by their NT logon
automatically, and the FE then only retrieves records from the BE that is
assigned to them, or if they are a supervisor, assigned to users that they
supervise. This information is then looked at several different ways, one of
them being an interactive GroupBy query so they can look at summary
information of any type of information in the records that they wish, without
having to be experts in running queries.
I have a series of check boxes, each one corresponding to a potential column
to include in the GroupBy query. As the users check or uncheck the boxes, a
SubForm displays a GroupBy query of the information they are looking at.
Behind the scenes, I have a function set up that is run on each of the
check-box's AfterUpdate, which essential manupulates a series of string
variables, from which I programatically use to create a SQL string, which is
then set as the record source of the SubForm and then the form is re-queried.
There is alot of other code to make things look pretty, (including sorting
by columns Ascending and Descending, turning visibility of columns on and
off, adjusting the 'Left' property of colums and headers to clean it up,
etc... ) but the end result is that there are only 6 fields that I always
have, and 10 other fields that I may or may not have, and in literally any
number and combination, including none and all 10.
What I need help with:
This makes building a fluid report that can, and will, handle any of these
combinations a huge task. I know I CAN build the report similar to my
subform, (opening the report, and programatically rebuilding the entire
report, adjusting positioning, visibilities, etc...) but since all I am
looking for on printing is just a spreadsheet-looking table/list/etc..., it
would be far easier if I could send the SubForm records visible to the
printer. So far however, any attempts at printing information it always
prints the main form as well, which is not needed and a waste of paper.
Any help would be appreciated, even if it is an MVP telling me that the best
way is to re-build the report design each time the print button is pressed.
Thanks,
-CoW
I want to enable the users of my front end interface to send the records
that they see in a SubForm to the printer for printing. Simple enough? Not
quite...
What I have:
Within my front end interface, Users are identified by their NT logon
automatically, and the FE then only retrieves records from the BE that is
assigned to them, or if they are a supervisor, assigned to users that they
supervise. This information is then looked at several different ways, one of
them being an interactive GroupBy query so they can look at summary
information of any type of information in the records that they wish, without
having to be experts in running queries.
I have a series of check boxes, each one corresponding to a potential column
to include in the GroupBy query. As the users check or uncheck the boxes, a
SubForm displays a GroupBy query of the information they are looking at.
Behind the scenes, I have a function set up that is run on each of the
check-box's AfterUpdate, which essential manupulates a series of string
variables, from which I programatically use to create a SQL string, which is
then set as the record source of the SubForm and then the form is re-queried.
There is alot of other code to make things look pretty, (including sorting
by columns Ascending and Descending, turning visibility of columns on and
off, adjusting the 'Left' property of colums and headers to clean it up,
etc... ) but the end result is that there are only 6 fields that I always
have, and 10 other fields that I may or may not have, and in literally any
number and combination, including none and all 10.
What I need help with:
This makes building a fluid report that can, and will, handle any of these
combinations a huge task. I know I CAN build the report similar to my
subform, (opening the report, and programatically rebuilding the entire
report, adjusting positioning, visibilities, etc...) but since all I am
looking for on printing is just a spreadsheet-looking table/list/etc..., it
would be far easier if I could send the SubForm records visible to the
printer. So far however, any attempts at printing information it always
prints the main form as well, which is not needed and a waste of paper.
Any help would be appreciated, even if it is an MVP telling me that the best
way is to re-build the report design each time the print button is pressed.
Thanks,
-CoW