Terence
A checkbox should still work when you migrate to SQL Server. You just have to use 1 instead of -1 in queries. What I do to avoid that is to use <>0. That way it works for Jet and SQL. Read my article "Working with SQL Server Linked Tables: The Hidden Gotchas" at http://www.thatlldoit.com/Pages/howtosarticles.aspx
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terence Lepczyk
Sent: Thursday, December 12, 2013 7:03 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] the checkbox - is it possible to build a checkbox with ctril wiz
This partucular db will eventually move to sql server. I realize the check box value is diff between server and desktop. I was attempting to make the desktop as compatable as possible "code wise". I realize that there are tricks like using "abs(x)" to obtain 0 and 1 values from the -1, I Really wanted to take as much pain of conversion away as possible.
On Thursday, December 12, 2013 8:33 AM, John Viescas <JohnV@msn.com> wrote:
Terence-
A normal check box control will have a value of 0 if unchecked and -1 if checked. Why are you using the Wizard?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of buffalome000@yahoo.com
Sent: Thursday, December 12, 2013 12:11 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] the checkbox - is it possible to build a checkbox with ctril wiz
Is it possible to build a check box with the control wizard which will act with a 0 for UNCHECK and 1 for Check ?
I have tried several tim,es but the ctrl wizard always wants to have 2 check boxs.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar