MS Access 2007

i'm using MS Access 2007 front end and back end SQL server 2008. in the MS Access Project (ADP) i need to Tbale called
Employee, there is field called Paid. i need to make it Check Box. But its showing error,Can any one show me how to enable check box in the MS Access Project.thx
LVL 2
lankapalaAsked:
Who is Participating?
 
rajvjaCommented:

Hi,

   Define the field Paid which is compatable for checkbox I mean boolean
0
 
lankapalaAuthor Commented:
yes i did , in the SQL server 2008 i used data type called Bit, i need it use MS Access (ADP) Check box, need to click, only using Datasheet.thx
0
 
Patrick MatthewsCommented:
In Access, a checkbox is either boolean True or False.  The numeric equivalents these are -1 (True) and 0 (False).

In SQL Server, the bit data type is either 1 (conventionally taken to be "true", but not actually a boolean value) or 0 (again, conventionally "false", but not a boolean value).
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
lankapalaAuthor Commented:
Not working
0
 
Anthony PerkinsCommented:
lankapala,

>>Not working<<
And again, if you honestly want to get a solution to your question consider providing more feedback.

Supposing your took your car to be repaired and told your mechanic that it was "Not working".  What do you think would be his/her response?
0
 
lankapalaAuthor Commented:
sorry for put Not working.
In Access, a checkbox is either boolean True or False.  The numeric equivalents these are -1 (True) and 0 (False).
iknow that, i need to know any possible to show check boxex in MS Access 2007 ADP Project.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.