By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,767 Members | 1,098 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,767 IT Pros & Developers. It's quick & easy.

Selecting Users from a list when running a report

P: n/a
Objective: Have a manager select a user's ID from a list and have a
report generated based on the user that is selected.

Current Progress: I have created a run-time prompted query and based
a report on that query, so when the manager runs the report they can
"type" in the user's ID (but there is no error checking, thus the
desire for a list).
I have a UserId table with each employee and UserId listed that I
would like to be able to use since there are 100+ userids.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
ma********@europasports.com (MarkPtacek) wrote in
news:60**************************@posting.google.c om:
Objective: Have a manager select a user's ID from a list and
have a report generated based on the user that is selected.

Current Progress: I have created a run-time prompted query
and based a report on that query, so when the manager runs the
report they can "type" in the user's ID (but there is no error
checking, thus the desire for a list).
I have a UserId table with each employee and UserId listed
that I would like to be able to use since there are 100+
userids.

Change your attack plan.

Build a query that selects distinct UserIDs.

Build a form with three controls: a combo box that uses the new
query as its row source, a print button, and a close form button.
Use the control wizard on the toolbar to build the buttons.

You can then just add to commands that the wizard to limit the
report to one user ID.

Remove the prompt from the query, it now duplicates info from the
form.

Bob Q
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.