J
Jay in PA
Hi,
I have a report that represents a checklist for a given user. My
challenge is that I would like to have a single form in which all user
checklists are available (e.g., the same checklist/report format
iterated across all users). For each user, there would be command
buttons that allow the user to view, print, or e-mail the report. The
difficulty is that the users will vary--users will be added to, and
dropped from the list every day, so I can't hard-code the reports to
the command buttons.
My questions are:
1. How can I display the list of current users with appropriate
controls to view, print, or e-mail their checklist reports? My first
thought was to use a continuous form as a subform, but I'm open to
ideas.
2. How do I dynamically generate the report before printing or e-
mailing it? For example, I know I could use DoCmd.SendObject to e-mail
the form, but how do I dynamically generate it based on the selected
user before e-mailing it?
Thanks to anyone who can make sense of my rambling questions and offer
a solution!
Jay
I have a report that represents a checklist for a given user. My
challenge is that I would like to have a single form in which all user
checklists are available (e.g., the same checklist/report format
iterated across all users). For each user, there would be command
buttons that allow the user to view, print, or e-mail the report. The
difficulty is that the users will vary--users will be added to, and
dropped from the list every day, so I can't hard-code the reports to
the command buttons.
My questions are:
1. How can I display the list of current users with appropriate
controls to view, print, or e-mail their checklist reports? My first
thought was to use a continuous form as a subform, but I'm open to
ideas.
2. How do I dynamically generate the report before printing or e-
mailing it? For example, I know I could use DoCmd.SendObject to e-mail
the form, but how do I dynamically generate it based on the selected
user before e-mailing it?
Thanks to anyone who can make sense of my rambling questions and offer
a solution!
Jay