Making it more user friendly

[Herman_KLF]

Hi All

I created a query in my database based on the values in a (Yes/No)field. In
order to display the records I need, I inserted in the 'Criteria' line the
following [For Condition1 insert '-1', for Condition2 insert '0']. How can I
make these '0' and '-1' a little more user friendly. Say for example a
checkbox or Option buttons with 'Yes' and 'No', 'Blue' and 'Red', or 'True'
and 'False'.

Thanks
Herman

 

[John Spencer]

To make this more friendly you will need to create a form and use that form to
get user input.

Check out this article for a detailed discussion.
http://www.fontstuff.com/access/acctut08.htm

Or check out this from MS
http://office.microsoft.com/en-us/access/HA011730581033.aspx

Or for another example
http://allenbrowne.com/ser-62.html

A brief quote from a John Vinson (Access MVP) posting.

You'll need to create a small unbound Form (let's call it frmCriteria) with a
Combo Box control (cboCrit) on it. Use the combo box wizard to select the
table for the selections, and be
sure that the bound field of the combo is the value you want to use as a
criterion. Save this form.

Now use

=[Forms]![frmCriteria]![cboCrit]

as the criterion in your Query.

It's convenient to base a second Form or Report on the resulting query to
display the results; if you put a button on frmCriteria to launch that form or
report, the user can enter the criterion and view the results in one simple
operation!

End quote
Obviously you can use a combobox or you can use checkbox or option buttons in
place of the combobox.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Herman_KLF]

Thanks John.

To make this more friendly you will need to create a form and use that form to
get user input.

Check out this article for a detailed discussion.
http://www.fontstuff.com/access/acctut08.htm

Or check out this from MS
http://office.microsoft.com/en-us/access/HA011730581033.aspx

Or for another example
http://allenbrowne.com/ser-62.html

A brief quote from a John Vinson (Access MVP) posting.

You'll need to create a small unbound Form (let's call it frmCriteria) with a
Combo Box control (cboCrit) on it. Use the combo box wizard to select the
table for the selections, and be
sure that the bound field of the combo is the value you want to use as a
criterion. Save this form.

Now use

=[Forms]![frmCriteria]![cboCrit]

as the criterion in your Query.

It's convenient to base a second Form or Report on the resulting query to
display the results; if you put a button on frmCriteria to launch that form or
report, the user can enter the criterion and view the results in one simple
operation!

End quote
Obviously you can use a combobox or you can use checkbox or option buttons in
place of the combobox.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hi All

I created a query in my database based on the values in a (Yes/No)field. In
order to display the records I need, I inserted in the 'Criteria' line the
following [For Condition1 insert '-1', for Condition2 insert '0']. How can I
make these '0' and '-1' a little more user friendly. Say for example a
checkbox or Option buttons with 'Yes' and 'No', 'Blue' and 'Red', or 'True'
and 'False'.

Thanks
Herman