Set Bit field to default checked

EFox

Registered User.
Local time
Today, 14:57
Joined
Jun 12, 2014
Messages
23
Hello,

I have a query that simply pulls back each tenant from a tenant table. Each row has a bit field that I use for check box's. This check box is true or false depending on the balance they owe. I currently use it to print off late reports and people that have this field set to true have a check box that auto populates on my datasheet.

I copied the query but I want to change it a little. I want to be able to show all tenants, but I want the bit field to show on my datasheet defaulted to checked for everyone (even if the table shows false) so that I can print all tenants without having to check the fields that are false in my table.

I tried to create an expression instead of using the bit field, but I no longer have the option to make that column into a "Check Box" under Lookup-Display Control.

Any ideas on a simple way to do this? Thanks in advance for any response.

EFox
 
Create a new field in your query and set the value as -1. Link this field to your report and print.
 
On my previous post I inadvertently said I was going to print them from a report(fingers were typing faster then I was thinking!). What I really meant to say is I have a form, that was created before I started working on this application, that displays the query in a "child" box(form) on the parent form. I really don't know much about a parent with a child box on its form. All I see the child doing is calling the query I have and populates it looks to just populate that area with the datasheet information from the query.

So I have no way of linking onto this child form like you had mentioned, unless I need to do it in VBA code in the background (in that case I have a larger mess then I knew I was going to have!).

The overall goal behind this is to click a button to run some pre existing update queries against those people that have the box's checked(these might always be fully checked, but the user wants to be able to deselect people at will before running the update queries).

I apologize for my first description being bad, I thought there might just be a simple expression I can use in the query to set a field to all -1 and make it a check box (this description might even be worse! hah).

EFox
 
You've lost me!

I don't understand what you mean by the child box(form). Unless you're talking about a subform? Perhaps you can show us a screenshot and on there point to (and describe) what you're trying to do.
 
Yes I am sorry for my bad lingo. I am only 4 weeks into upgrades/changes to this access application and I had no experience with access before this! I really apologize and thank you for sticking in there with me!

Attached are two pictures. One of the form in design view, and the other in form view with the data populated from the query. What I am trying to do is get all the check box's to default as checked. It currently pulls the "Print" column from the database, but when I try to create an expression like: "Expr1: -1", I have no option to make it a check box.

Like I said I appreciate you hanging with me and thanks for helping. I hope this may be a little clearer haha.
 

Attachments

  • formDesign.png
    formDesign.png
    16.7 KB · Views: 73
  • formFormView.png
    formFormView.png
    90.8 KB · Views: 67
One person at a time. It is an apartment manager application loaded only on 1 computer. The owner remote desktops into the computer when he wants to look at things. When I first started to take over the application I migrated the back end to SQL 2008 because he wants to eventually make a web app to get simple queries returned.
 
The reason why I ask is your Print checkbox is bound to a field and if user A a ticks the box and the record gets saved then a second later user B unticks the tickbox for the same record, it will affect user A.
 
I understand what you are saying, and I appreciate your concern. The owner has 1 apartment complex, and this is just one of his side businesses. There is 1 apartment manager on site, and everything (currently, even the new SQL db) is stored locally on that managers computer. So only one person can actually run this application/access the db at a time.

The way these fields are being used are not to update the record (on this form), but just pull all the records and decide which ones you want to use to run the update queries in the next steps of the process. I just want to be able to have them all defaulted to checked, so that if I want to uncheck 2 I can then run those 8 checked against a couple queries that will do some updating. So I am not trying to change values in my database, I am just trying to show display each tenant with a check box that is defaulted to checked.

I attached 2 more pictures to maybe help show what I am trying to do. The first is the query where I removed the "print" column and made a field "Expr1: True". I also show the property sheet which does not allow me to make the new field a check box, when it allows me to when I use the "print" field from the table. The second is just a picture of the form that is populated by the query.

Sorry if I am still not clear on my intentions.
 

Attachments

  • queryDesign.png
    queryDesign.png
    13.4 KB · Views: 73
  • formView.png
    formView.png
    85.6 KB · Views: 67

Users who are viewing this thread

Back
Top Bottom