Pulldown for Report Input Fields

[Joe-Al]

Typically when I create a standard query, I insert non-existant fields
(variables) for user input criteria at the time of running the query. For
example [Input Start Date mm/dd/yyyy]. This would allow the user to run the
query using a START DATE Criteria.

Every time a Report is run, It would prompt at the beginning for the INPUT
CRITERIA ([Input Start Date mm/dd/yyyy]) before running the report.

How can I give the users a PULL DOWN set of START DATE choices or choices
from an existing query field (lookup) at the time the report is first run.
Like a LOOKUP table to be inputed back to the report (query).

 

[Duane Hookom]

IMHO, parameter prompts have no place in any application
http://www.tek-tips.com/faqs.cfm?fid=6763. Use controls on forms for user
interaction.

 

[Joe-Al]

I agree. Without SQL programming knowledge, SIMPLE works.

I have solved this using the following ACCESS ONLINE HELP: 'Make your
queries interactive by using parameters'. Also note the section in this help
called; 'Create a form that collects parameters' (the SHOW ME video is handy
as well,
http://office.microsoft.com/home/vi...768&startindex=0&CTT=11&Origin=HA100963141033 )

I would like to know how to use multiple choice lists though in place of
single input fields! Thx
--
Regards,

Joe Fenninger, MCSA
MS Small Business Specialist

IMHO, parameter prompts have no place in any application
http://www.tek-tips.com/faqs.cfm?fid=6763. Use controls on forms for user
interaction.
--
Duane Hookom
Microsoft Access MVP

Typically when I create a standard query, I insert non-existant fields
(variables) for user input criteria at the time of running the query. For
example [Input Start Date mm/dd/yyyy]. This would allow the user to run the
query using a START DATE Criteria.

Every time a Report is run, It would prompt at the beginning for the INPUT
CRITERIA ([Input Start Date mm/dd/yyyy]) before running the report.

How can I give the users a PULL DOWN set of START DATE choices or choices
from an existing query field (lookup) at the time the report is first run.
Like a LOOKUP table to be inputed back to the report (query).

 

[Duane Hookom]

There are a number of resources on the web that describe how to use
multi-select list boxes to filter reports. You might want to check out the
generic function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
Microsoft Access MVP

I agree. Without SQL programming knowledge, SIMPLE works.

I have solved this using the following ACCESS ONLINE HELP: 'Make your
queries interactive by using parameters'. Also note the section in this help
called; 'Create a form that collects parameters' (the SHOW ME video is handy
as well,
http://office.microsoft.com/home/vi...768&startindex=0&CTT=11&Origin=HA100963141033 )

I would like to know how to use multiple choice lists though in place of
single input fields! Thx
--
Regards,

Joe Fenninger, MCSA
MS Small Business Specialist

IMHO, parameter prompts have no place in any application
http://www.tek-tips.com/faqs.cfm?fid=6763. Use controls on forms for user
interaction.
--
Duane Hookom
Microsoft Access MVP

Typically when I create a standard query, I insert non-existant fields
(variables) for user input criteria at the time of running the query. For
example [Input Start Date mm/dd/yyyy]. This would allow the user to run the
query using a START DATE Criteria.

Every time a Report is run, It would prompt at the beginning for the INPUT
CRITERIA ([Input Start Date mm/dd/yyyy]) before running the report.

How can I give the users a PULL DOWN set of START DATE choices or choices
from an existing query field (lookup) at the time the report is first run.
Like a LOOKUP table to be inputed back to the report (query).

 

[Joe-Al]

I notice this example is Access 2000. Does this work with Access 2007 (what I
am using)?
--
Regards,

Joe Fenninger, MCSA
MS Small Business Specialist

There are a number of resources on the web that describe how to use
multi-select list boxes to filter reports. You might want to check out the
generic function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
Microsoft Access MVP

I agree. Without SQL programming knowledge, SIMPLE works.

I have solved this using the following ACCESS ONLINE HELP: 'Make your
queries interactive by using parameters'. Also note the section in this help
called; 'Create a form that collects parameters' (the SHOW ME video is handy
as well,
http://office.microsoft.com/home/vi...768&startindex=0&CTT=11&Origin=HA100963141033 )

I would like to know how to use multiple choice lists though in place of
single input fields! Thx
--
Regards,

Joe Fenninger, MCSA
MS Small Business Specialist

IMHO, parameter prompts have no place in any application
http://www.tek-tips.com/faqs.cfm?fid=6763. Use controls on forms for user
interaction.
--
Duane Hookom
Microsoft Access MVP


:

Typically when I create a standard query, I insert non-existant fields
(variables) for user input criteria at the time of running the query. For
example [Input Start Date mm/dd/yyyy]. This would allow the user to run the
query using a START DATE Criteria.

Every time a Report is run, It would prompt at the beginning for the INPUT
CRITERIA ([Input Start Date mm/dd/yyyy]) before running the report.

How can I give the users a PULL DOWN set of START DATE choices or choices
from an existing query field (lookup) at the time the report is first run.
Like a LOOKUP table to be inputed back to the report (query).

 

[Duane Hookom]

I'm not sure if it will work in 2007. You don't need my permission to try it
and report back ;-)
--
Duane Hookom
Microsoft Access MVP

I notice this example is Access 2000. Does this work with Access 2007 (what I
am using)?
--
Regards,

Joe Fenninger, MCSA
MS Small Business Specialist

There are a number of resources on the web that describe how to use
multi-select list boxes to filter reports. You might want to check out the
generic function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
Microsoft Access MVP

I agree. Without SQL programming knowledge, SIMPLE works.

I have solved this using the following ACCESS ONLINE HELP: 'Make your
queries interactive by using parameters'. Also note the section in this help
called; 'Create a form that collects parameters' (the SHOW ME video is handy
as well,
http://office.microsoft.com/home/vi...768&startindex=0&CTT=11&Origin=HA100963141033 )

I would like to know how to use multiple choice lists though in place of
single input fields! Thx
--
Regards,

Joe Fenninger, MCSA
MS Small Business Specialist


:

IMHO, parameter prompts have no place in any application
http://www.tek-tips.com/faqs.cfm?fid=6763. Use controls on forms for user
interaction.
--
Duane Hookom
Microsoft Access MVP


:

Typically when I create a standard query, I insert non-existant fields
(variables) for user input criteria at the time of running the query. For
example [Input Start Date mm/dd/yyyy]. This would allow the user to run the
query using a START DATE Criteria.

Every time a Report is run, It would prompt at the beginning for the INPUT
CRITERIA ([Input Start Date mm/dd/yyyy]) before running the report.

How can I give the users a PULL DOWN set of START DATE choices or choices
from an existing query field (lookup) at the time the report is first run.
Like a LOOKUP table to be inputed back to the report (query).