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

Thanks for the reply. I forgot to mention that I am using ODBC to
connect to the SQL server.

The Checkboxes on the normal Form map to 0's and 1's in the data
table. I.e. True = 1. However, when I use the Access' "Filter By
Form" function, it seems to open a 'copy' of the form. The Checkboxes
on this form automatically create a filter, but every checked Checkbox
creates a True = -1; which is the Access standard for True/False data.

Two different data standards... Same Microsoft... Does Bill Gates have
too much money?

.

Relevant Pages

  • Re: how to add table and all its index for replication
    ... select teh elipsis button in EM and on the article ... properties, snapshot tab, you'll see the corresponding ... checkboxes. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • 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: Going into an infinite loop
    ... > Now, when I check All Object Types, all the other checkboxes take on the ... What I want to happen is when one of the> other check boxes are checked, I want the chkAllObjectTypes checkbox to change> state to ... > Looking for a SQL Server replication book? ...
    (microsoft.public.dotnet.languages.csharp)
  • Form error????
    ... I just added two checkboxes on my main form and on the MS SQL server I also ... added two fields as “bit” format. ... "The record has been changed by another user since you started editing it. ... When I delete those two checkboxes it works fine?????? ...
    (microsoft.public.access.forms)
  • Re: default value after replication
    ... AFAIR if you select the checkboxes on the article properties, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)