Selecting reporting options

  • Thread starter Thread starter Very Basic User
  • Start date Start date
V

Very Basic User

Is there any way to make a tool consisting of all the catagories in my query
that I can have a user select each available item in the catagorie that they
choose to see in the resulting query?
 
John

If I'm understanding your description, one approach would be to create a
form and put a combobox on the form containing the category(ies). After the
user selects a category from that combobox, you'd use a command button to
run the query.

You'd also need to modify the query's selection criteria, for the category
field, so that it points to the form's combobox for the criterion, something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thank you Jeff!

This is a good start, I've created the form and query. I placed

Forms![Options for reporting form]![cboFocus area]

This does identify the query and opens it but with no change in the results
based off of the selection
--
Thank you for your time!
John


Jeff Boyce said:
John

If I'm understanding your description, one approach would be to create a
form and put a combobox on the form containing the category(ies). After the
user selects a category from that combobox, you'd use a command button to
run the query.

You'd also need to modify the query's selection criteria, for the category
field, so that it points to the form's combobox for the criterion, something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
PS: What if I want to have a selection box that I leave empty, will that
include all records from the query?
--
Thank you for your time!
John


Jeff Boyce said:
John

If I'm understanding your description, one approach would be to create a
form and put a combobox on the form containing the category(ies). After the
user selects a category from that combobox, you'd use a command button to
run the query.

You'd also need to modify the query's selection criteria, for the category
field, so that it points to the form's combobox for the criterion, something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Very Basic User said:
This is a good start, I've created the form and query. I placed

Forms![Options for reporting form]![cboFocus area]
Click to expand...

Where did you place it? It should go in the Criteria line under the
corresponding Field in the Query Grid. And, a reminder, for you to access
data from a Form, the Form must be Open.



Larry Linson
Microsoft Office Access MVP

This does identify the query and opens it but with no change in the
results
based off of the selection
--
Thank you for your time!
John


Jeff Boyce said:
John

If I'm understanding your description, one approach would be to create a
form and put a combobox on the form containing the category(ies). After
the
user selects a category from that combobox, you'd use a command button to
run the query.

You'd also need to modify the query's selection criteria, for the
category
field, so that it points to the form's combobox for the criterion,
something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


message
Is there any way to make a tool consisting of all the catagories in my
query
that I can have a user select each available item in the catagorie that
they
choose to see in the resulting query?
Click to expand...
Click to expand...
Click to expand...
 
Got it and it works great, I had to make one slight modification. The forst
part Forms! needed to be in []. I also read up on blank to select all and
came up with the following command line. Seems to be working great, thank you
both for all your help!

Like [Forms]![ReportOptions]![Focus Area] & "*"
--
Thank you for your time!
John


Jeff Boyce said:
John

If I'm understanding your description, one approach would be to create a
form and put a combobox on the form containing the category(ies). After the
user selects a category from that combobox, you'd use a command button to
run the query.

You'd also need to modify the query's selection criteria, for the category
field, so that it points to the form's combobox for the criterion, something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
One more question. If I want to have multiple options for a date selection on
the form. I.E. Select Between [Start Date] and [End Date] or Past 24 hours,
etc. is there a way to have the criteria in the form Determine what command
to have written on the query command line section. I started with this
command ...

Like [Forms]![ReportOptions]![Date Entered] & "*"

I then tried to have pre-selection options to choose from the form that
would put...

Between [Start Date] and [End Date]

Into the query with no luck.

--
Thank you for your time!
John


Very Basic User said:
Got it and it works great, I had to make one slight modification. The forst
part Forms! needed to be in []. I also read up on blank to select all and
came up with the following command line. Seems to be working great, thank you
both for all your help!

Like [Forms]![ReportOptions]![Focus Area] & "*"
--
Thank you for your time!
John


Jeff Boyce said:
John

If I'm understanding your description, one approach would be to create a
form and put a combobox on the form containing the category(ies). After the
user selects a category from that combobox, you'd use a command button to
run the query.

You'd also need to modify the query's selection criteria, for the category
field, so that it points to the form's combobox for the criterion, something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


Very Basic User said:
Is there any way to make a tool consisting of all the catagories in my
query
that I can have a user select each available item in the catagorie that
they
choose to see in the resulting query?
Click to expand...
Click to expand...
Click to expand...
 
If you are already referring to a form that holds selection criteria for one
of your query's fields, do the same thing for your date range parameters.
Add a couple more controls on the form for begin and end dates, and refer to
them the same way from your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Very Basic User said:
One more question. If I want to have multiple options for a date selection
on
the form. I.E. Select Between [Start Date] and [End Date] or Past 24
hours,
etc. is there a way to have the criteria in the form Determine what
command
to have written on the query command line section. I started with this
command ...

Like [Forms]![ReportOptions]![Date Entered] & "*"

I then tried to have pre-selection options to choose from the form that
would put...

Between [Start Date] and [End Date]

Into the query with no luck.

--
Thank you for your time!
John


Very Basic User said:
Got it and it works great, I had to make one slight modification. The
forst
part Forms! needed to be in []. I also read up on blank to select all and
came up with the following command line. Seems to be working great, thank
you
both for all your help!

Like [Forms]![ReportOptions]![Focus Area] & "*"
--
Thank you for your time!
John


Jeff Boyce said:
John

If I'm understanding your description, one approach would be to create
a
form and put a combobox on the form containing the category(ies).
After the
user selects a category from that combobox, you'd use a command button
to
run the query.

You'd also need to modify the query's selection criteria, for the
category
field, so that it points to the form's combobox for the criterion,
something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


message
Is there any way to make a tool consisting of all the catagories in
my
query
that I can have a user select each available item in the catagorie
that
they
choose to see in the resulting query?
Click to expand...
Click to expand...
Click to expand...
 
Okay, so here is what I tried...

Between [forms]![ReportOptions]![Start Date] And
[forms]![ReportOptions]![End Date]

It works well with one exception, I can't leave the text box controls blank
like I can with the rest of my fields. I tried & "*" at the end. It didn't
work with the dates as it does with other single selection options. I also
tried using default values of (Start Date 1/1/1800) and (End date of
1/1/3000) in the property of each control box, but that didn't work either.
Any thoughts?
--
Thank you for your time!
John


Jeff Boyce said:
If you are already referring to a form that holds selection criteria for one
of your query's fields, do the same thing for your date range parameters.
Add a couple more controls on the form for begin and end dates, and refer to
them the same way from your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Very Basic User said:
One more question. If I want to have multiple options for a date selection
on
the form. I.E. Select Between [Start Date] and [End Date] or Past 24
hours,
etc. is there a way to have the criteria in the form Determine what
command
to have written on the query command line section. I started with this
command ...

Like [Forms]![ReportOptions]![Date Entered] & "*"

I then tried to have pre-selection options to choose from the form that
would put...

Between [Start Date] and [End Date]

Into the query with no luck.

--
Thank you for your time!
John


Very Basic User said:
Got it and it works great, I had to make one slight modification. The
forst
part Forms! needed to be in []. I also read up on blank to select all and
came up with the following command line. Seems to be working great, thank
you
both for all your help!

Like [Forms]![ReportOptions]![Focus Area] & "*"
--
Thank you for your time!
John


:

John

If I'm understanding your description, one approach would be to create
a
form and put a combobox on the form containing the category(ies).
After the
user selects a category from that combobox, you'd use a command button
to
run the query.

You'd also need to modify the query's selection criteria, for the
category
field, so that it points to the form's combobox for the criterion,
something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


message
Is there any way to make a tool consisting of all the catagories in
my
query
that I can have a user select each available item in the catagorie
that
they
choose to see in the resulting query?
Click to expand...
Click to expand...
Click to expand...
 
Answered in another thread where you asked the same question ("Connecting
parameter in form to query for report display").

Please try to stick to a single thread.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Very Basic User said:
Okay, so here is what I tried...

Between [forms]![ReportOptions]![Start Date] And
[forms]![ReportOptions]![End Date]

It works well with one exception, I can't leave the text box controls
blank
like I can with the rest of my fields. I tried & "*" at the end. It didn't
work with the dates as it does with other single selection options. I also
tried using default values of (Start Date 1/1/1800) and (End date of
1/1/3000) in the property of each control box, but that didn't work
either.
Any thoughts?
--
Thank you for your time!
John


Jeff Boyce said:
If you are already referring to a form that holds selection criteria for
one
of your query's fields, do the same thing for your date range parameters.
Add a couple more controls on the form for begin and end dates, and refer
to
them the same way from your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP


message
One more question. If I want to have multiple options for a date
selection
on
the form. I.E. Select Between [Start Date] and [End Date] or Past 24
hours,
etc. is there a way to have the criteria in the form Determine what
command
to have written on the query command line section. I started with this
command ...

Like [Forms]![ReportOptions]![Date Entered] & "*"

I then tried to have pre-selection options to choose from the form that
would put...

Between [Start Date] and [End Date]

Into the query with no luck.

--
Thank you for your time!
John


:

Got it and it works great, I had to make one slight modification. The
forst
part Forms! needed to be in []. I also read up on blank to select all
and
came up with the following command line. Seems to be working great,
thank
you
both for all your help!

Like [Forms]![ReportOptions]![Focus Area] & "*"
--
Thank you for your time!
John


:

John

If I'm understanding your description, one approach would be to
create
a
form and put a combobox on the form containing the category(ies).
After the
user selects a category from that combobox, you'd use a command
button
to
run the query.

You'd also need to modify the query's selection criteria, for the
category
field, so that it points to the form's combobox for the criterion,
something
like (untest, not customized to your names):

Forms![YourFormName]![cboYourComboboxName]

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


message
Is there any way to make a tool consisting of all the catagories
in
my
query
that I can have a user select each available item in the catagorie
that
they
choose to see in the resulting query?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top