Re: Filter by form problem with Yes/No Data and SQL Server

On Mar 28, 10:40 am, Jim Mandala <mand...@xxxxxxxxxxxxxxx> wrote:
Using Access 2003 front end; SQL Server 2005 Back end:

I have a complex form that has lots of data fields including about
thirty or so checkboxes storing Yes/No data that I would like my users
to be able to use the Filter by Form functionality with to create a
"Custom" query.

This works perfectly fine when I filter on a text field. Also, this
works perfectly fine for all data with an Access Back end. When I use
boolean data and my SQL server back end, however, the filter stops
working. I understand that the SQL server stores the Yes as "1" while
Access, and my "Filter Form" uses "-1" for Yes.

Clicking on a box in the Filter by Form creates a Me.Filter string
which looks like "CheckBox7 = -1". I don't really understand this,
since the checkbox on the actual Form stores a value of 1 in the SQL
table.

Is there a way I can get the "Filter By Form" to work with Boolean
Data?

Thanks!

SQL Server Bit fields are 0 or 1. (I suppose anything bit is 0 or 1
for that matter.) Is that extended to your checkbox on your form?
Don't know but you might try it.
.

Relevant Pages

  • Filter by form problem with Yes/No Data and SQL Server
    ... SQL Server 2005 Back end: ... I have a complex form that has lots of data fields including about ... thirty or so checkboxes storing Yes/No data that I would like my users ... This works perfectly fine when I filter on a text field. ...
    (comp.databases.ms-access)
  • Re: Creating a temporary table/query for subform
    ... What this table will do is summarize the data they've filtered and then ... "Percent") change depending on what the users want to filter. ... I also need to label each checkbox field to something usable for the ... and I believe that requires a table or a query. ...
    (microsoft.public.access.queries)
  • Re: Dealing with Tables in VBA
    ... n-1 paragraphs in any cell in the second column of any table after the ... "No Filter Required" ... Anytime the checkbox next to "No FIlter Required" is checked, ... Find a occurance of a text string "Data Filter Requirements" ...
    (microsoft.public.word.vba.general)
  • Re: modifying Kallals Multiselect database example
    ... Private Function SelectAll() ... Set colCheckBox = Nothing ... The problem is that if you apply a filter using the user interface (the ... collection when the checkbox is unclicked. ...
    (microsoft.public.access.formscoding)
  • Re: IIf problem with <>
    ... I assume that your checkbox is in the header, and basically, what you want ... is to either turn off the filter or turn it on. ... selecting a tick box that indicates show completed jobs ... You are trying to construct a criteria cell for the query ...
    (microsoft.public.access.queries)