Topics Search

Checkbox in query

Checkbox in query
Views: 96
I've been looking through the forum for this, but I've only found how to add/count checkboxes in queries, and how to make a query based on checkboxes.what I need is to add a checkbox to every result on a query, I need this in order to add the ticked items to a record table, this is, the ticked items are accomplished tasks and therefore need to be registered (in the table) and the unticked tasks weren't accomplished and therefore shouldn't be added to the registry (table). Can anyone tell me just how to add the checkbox to the query
Sponsored Links:

More topics


Simple Query question

I try to make a query sorting out some records from selection of a combobox. This works fine. However I like to add that the criteria in query add a checkbox as well. So this is how it should work:
Select combobox if checkbox is checked.

How to do this?

This is my criteria without checkbox: [Forms]![GlobalPunchList Form]![Combo17] So I like to add checkbox as well to this criteria. Any tip?

Convert Checkbox to text

Can you assist me in converting a checkbox to text? I need to do it two ways: 1. Checkbox on = X; Checkbox off = (null)
2. Checkbox on = Yes; Checkbox off = No

How to make an active checkbox in a report?

I have a form that runs a query that automatically opens a report. My report includes a checkbox field that correlates to each entry. I want the checkbox to be active in the report. Is there a way to do this?

I want to be able to double check the document attached to every entry and then check the box when it has been checked. However, I want the checkbox to be usable on the report so the user doesn't have to go into the table to check it.

Right now, the checkbox is only an image and isn't interactive on the report.

Datestamp for Checkbox-Query

If anyone can help with VB code for Access 2007. I was asked to assign a datestamp when a user checks a checkbox called "OLIED. I added my fields/checkbox names:

Private Static Sub DateStamp()
If ChkBoxOLIED = True Then
Me.[OLIED DATE] = Date
Me.[OLIED DATE] = Null
End If
End Sub

That assigns a datestamp to a checkbox, but doesn't work because I think I am asking to assign a datestamp to a query field and not within a form with EVENTS to assign. Can this be done to my query "Keith Billing?

Help with checkbox!

Working on a program( ASP + SQL). I want to get the value of the checkbox to update the database. When you the checkbox is checked, the field in the database will be set to true. But if it is not checked, the value will be false or null. The problem is, everytime when I checked the checkbox and click update, upon reloading the form, the checked checkbox will be..

Make invisible with a checkbox

I have a simple form in which I have a checkbox that makes a text field visible when the checkbox is checked (The text field is not bound). My problem is that when I switch to the next record the checkbox gets updated along with the record but the text field does not change along with the checkbox; if the next record has the checkbox unchecked the text box will still stay visible.

select query based on multiple checkboxes

just wiondering if there is a way I can do the following. I have a table (table 1) with 10 fields in it. I have a form with 6 of these field names displaying on it. I have a checkbox next to each of these fields. When the checkbox is selected I want to use that field as criteria in a select query. This means that I want the query to select records based on what checkboxes are selected, whether that be 1 checkbox or any combinatiion of the 6 checkboxes.
Not completely great with the whole programming thing and would like to be able to do in in a query (design view) if possible.


I have a checkbox in a form for sales contacts.
What I want to do is: If you click the checkbox, it opens another form for products the customers have ordered before. If you don't click the checkbox, nothing happens. I have this so far:

Private Sub Have_They_Used_VS_Before__Click()
'Pull up prior sales form if checkbox is checked
If CheckBox.Value = True Then DoCmd.OpenForm "Prior Sales"
'If checkbox is not checked then do nothing
If CheckBox.Value = False Then ?
End Sub

I'm trying to teach myself this but got stuck.

Clearing Checkbox on New Record

Is there a way to clear a check box in a form if you add a new record?

I tried:

If Me.NewRecord = True Then
Me.checkbox = False

That doesn't seem to work when I have placed a check in the checkbox on the current record, and then create a new record, the checkbox stays.

Count of records where checkbox 1 is unchecked, checkbox 2 is chec

I have a table with several check boxes. I'd like to place in the report footer a count of the number of records where both conditions exist: checkbox 1 is checked
checkbox 2 is unchecked.