Combo query

[Budd]

I have a form with 2 combo boxes and an ActiveX text box. In the first combo
box, the drop down lists the catagories, the second combo box lists operands
like < or > ,<=, etc. The third box is for user input. ie 90, 80, etc. The
end desire is to have the user select a category from box1, select an operand
from box2, fill in criteria on box3 and have the results sent to a report.
For example, choose all males weighing > 200lbs., the user types in the 200.
Since I'm a novice at this, am I going about this the easy way, and/or how do
I make this work?
Thanks,

 

[Jeff Boyce]

For your own use, or for use by untrained, unsophisticated users (i.e.,
folks who will NOT want to have to learn Access to use it).

If for your use, queries seem to do much of what you've described.

If for users, you could come up with your form and dynamically create the
SQL statement that returns the rows. Making a report customized to the
dynamic query is a whole other can of worms!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Budd]

This will be for untrained Access users who just want to punch buttons and
get results

For your own use, or for use by untrained, unsophisticated users (i.e.,
folks who will NOT want to have to learn Access to use it).

If for your use, queries seem to do much of what you've described.

If for users, you could come up with your form and dynamically create the
SQL statement that returns the rows. Making a report customized to the
dynamic query is a whole other can of worms!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a form with 2 combo boxes and an ActiveX text box. In the first
combo

[quoted text clipped - 10 lines]

I make this work?
Thanks,

 

[Jeff Boyce]

In my experience, making an Access application EASY to use is HARD!

How much experience do you have building in Access? How long do you have to
get this done?

Regards

Jeff Boyce
Microsoft Office/Access MVP

This will be for untrained Access users who just want to punch buttons and
get results

For your own use, or for use by untrained, unsophisticated users (i.e.,
folks who will NOT want to have to learn Access to use it).

If for your use, queries seem to do much of what you've described.

If for users, you could come up with your form and dynamically create the
SQL statement that returns the rows. Making a report customized to the
dynamic query is a whole other can of worms!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a form with 2 combo boxes and an ActiveX text box. In the first
combo

[quoted text clipped - 10 lines]

I make this work?
Thanks,

 

[Budd via AccessMonster.com]

Everything I've learned in Access is self-taught. At best I'm a novice
although I understand most concepts of a database. I need to get this done by
the first of next week. Thanks for your help!

In my experience, making an Access application EASY to use is HARD!

How much experience do you have building in Access? How long do you have to
get this done?

Regards

Jeff Boyce
Microsoft Office/Access MVP

This will be for untrained Access users who just want to punch buttons and
get results

[quoted text clipped - 20 lines]

 

[Jeff Boyce]

Best of luck on this! Perhaps one of the many other newsgroup readers has
already built something like this. Have you tried searching on-line using
something like "MS Access customize query"?

If you only had to get something (proof of concept) running by next week,
and if you didn't need to make it user-friendly (?user-proof), and if you
are comfortable creating dynamic SQL statements based on selections on a
form, and if ...

Untested psuedo-code might look something like:

1. get category from user in cboCategory (I still don't know what YOU
mean by "category" ... is this "male", or ...?)
2. get operand from user in cboOperand
3. get comparison value from user in txtValue (why do you consider this
an ActiveX control and not a simple text box?)
4. build a SQL statement that uses the values from these controls
5. create a query from the SQL
6. modify a report definition to use the query from #5 as a source
7. <TOUGH ONE> figure out how you'll have to modify the report layout
for each/every possible combination that users could select.
8. run the report

You might want to consider stopping at step 4 and running the SQL/query and
using THAT as a (very crude) report.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Everything I've learned in Access is self-taught. At best I'm a novice
although I understand most concepts of a database. I need to get this done
by
the first of next week. Thanks for your help!

In my experience, making an Access application EASY to use is HARD!

How much experience do you have building in Access? How long do you have
to
get this done?

Regards

Jeff Boyce
Microsoft Office/Access MVP

This will be for untrained Access users who just want to punch buttons
and
get results

[quoted text clipped - 20 lines]

I make this work?
Thanks,

 

[Budd via AccessMonster.com]

Thanks, Jeff.
Given my level of expertise, I might be over my head here. I probably need a
crash course of SQL

Best of luck on this! Perhaps one of the many other newsgroup readers has
already built something like this. Have you tried searching on-line using
something like "MS Access customize query"?

If you only had to get something (proof of concept) running by next week,
and if you didn't need to make it user-friendly (?user-proof), and if you
are comfortable creating dynamic SQL statements based on selections on a
form, and if ...

Untested psuedo-code might look something like:

1. get category from user in cboCategory (I still don't know what YOU
mean by "category" ... is this "male", or ...?)
2. get operand from user in cboOperand
3. get comparison value from user in txtValue (why do you consider this
an ActiveX control and not a simple text box?)
4. build a SQL statement that uses the values from these controls
5. create a query from the SQL
6. modify a report definition to use the query from #5 as a source
7. <TOUGH ONE> figure out how you'll have to modify the report layout
for each/every possible combination that users could select.
8. run the report

You might want to consider stopping at step 4 and running the SQL/query and
using THAT as a (very crude) report.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Everything I've learned in Access is self-taught. At best I'm a novice
although I understand most concepts of a database. I need to get this done

[quoted text clipped - 18 lines]

 

[Jeff Boyce]

Budd

Afraid it might be more than just a SQL crash course...

The SQL statement will be how Access "asks" for data (i.e., a query). But
you will also need to know how/when/where to use which VBA (Visual Basic for
Applications) commands to get the SQL together, and get it to run.

And then there's the learning curve on creating forms that are
user-friendly/user-proof...

This may be bigger than a breadbox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks, Jeff.
Given my level of expertise, I might be over my head here. I probably need
a
crash course of SQL

Best of luck on this! Perhaps one of the many other newsgroup readers has
already built something like this. Have you tried searching on-line using
something like "MS Access customize query"?

If you only had to get something (proof of concept) running by next week,
and if you didn't need to make it user-friendly (?user-proof), and if you
are comfortable creating dynamic SQL statements based on selections on a
form, and if ...

Untested psuedo-code might look something like:

1. get category from user in cboCategory (I still don't know what YOU
mean by "category" ... is this "male", or ...?)
2. get operand from user in cboOperand
3. get comparison value from user in txtValue (why do you consider
this
an ActiveX control and not a simple text box?)
4. build a SQL statement that uses the values from these controls
5. create a query from the SQL
6. modify a report definition to use the query from #5 as a source
7. <TOUGH ONE> figure out how you'll have to modify the report layout
for each/every possible combination that users could select.
8. run the report

You might want to consider stopping at step 4 and running the SQL/query
and
using THAT as a (very crude) report.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Everything I've learned in Access is self-taught. At best I'm a novice
although I understand most concepts of a database. I need to get this
done

[quoted text clipped - 18 lines]

I make this work?
Thanks,