?
Solved

MS Access 2007

Posted on 2010-11-17
8
Medium Priority
?
358 Views
Last Modified: 2014-06-16
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
0
Comment
Question by:lankapala
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 11

Accepted Solution

by:
rajvja earned 1000 total points
ID: 34153875

Hi,

   Define the field Paid which is compatable for checkbox I mean boolean
0
 
LVL 2

Author Comment

by:lankapala
ID: 34153975
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
 
LVL 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 1000 total points
ID: 34155262
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 2

Author Comment

by:lankapala
ID: 34256321
Not working
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34288558
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
 
LVL 2

Author Comment

by:lankapala
ID: 34329064
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

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question