Checkbox/Query/Form/Report Help

Nov 17, 2004

I need some serious help! I am an Access newbie and I think I am trying to do something more complicated than my skills. Any help will be extremely appreciated!

Here is the situation:

I have a table of volunteer records that record each volunteer's availability and areas of interest, which are checkboxes. The volunteer information area of the form basically looks like this:

Monday Tuesday Wednesday etc.
Morning O O O
Afternoon O O O
Evening O O O

O "Trails" O "Greenhouse" etc.

The "O" designates the checkboxes saying "yes" they are available at that time and "yes" they are interested in that area. I did it in checkbox form because it is the most visual and simplest way for my users to understand the record. My users' thought process is going to be this: I am having a greenhouse clean up this Tuesday evening. I need to run a report of all our volunteers that said they are available Tuesday evenings to work AND said that they want to work in the greenhouse. What I would like next to happen is they load the database I'm designing, click the switchboard to a search form that has the same checkbox layout as the volunteer record. They check Tuesday evening, check Greenhouse, then click run report. Report appears on screen that they can view, which they can choose to print so they can call the volunteers.

I have seen samples of listboxes and dropdown boxes as search criteria on a form, but the additional problem is that my end users are over the age of 65, scared of computers, nice ladies. They wouldn't understand the listbox of fields, and it would be a disaster trying to get them to understand AND/OR statements and the entering of yes/no on a list of search criteria, especially if they have more than one time availability and area of interest that they want to run in one report. Hence, sticking to the easy checkbox format for the never-used-a-computer-before ladies to run the reports they need, spitting out the information to the question they are asking, like "Who are all the volunteers that said they are available weekends to work special events? I need to call them to see if they would work the special event coming up in 3 weeks."

I am completely lost about how to go about doing a checkbox form to run a query of checkboxed data that spits out a report with the results :[ I would appreciate a simple sample or an explanation in layman's terms of the steps involved to achieving the results I would like. I am the type who would like to try to figure this out, so that I learn, but I am completely in over my head with this one :[

All patience and help with this will be greatly appreciated!

Thanks in advance,
Newbie Volunteer Coordinator

View Replies


ADVERTISEMENT

Using Checkbox On A Form For Query Criteria

May 15, 2006

Hey all this is my first post so thanks in advance for any help you can give me.

I am trying to use multiple checkboxes on a form to try and make a select query, when the box is checked the data is queried when unchecked it is not, sounds simple enough, here is my problem.

I set the query criteria with an expression like this:
[Forms]![frmMainLookup]![Check Box Alarm Number]="-1"
As long as the checkbos is checked everything seems to work fine.
If I uncheck the checkbox then none of the data is shows up.
I still get the columns to show up just no data.

I am sure there is something simple I am missing but the Force is not with me today.

Thanks again for any help.

View 5 Replies View Related

Queries :: How To Show / Hide Columns In A Query Using A Form Checkbox

Jul 16, 2015

Currently I have a query where the criteria is dependent on the combo boxes on my form. I would like to add checkboxes to my form which determines which fields are shown or hidden. For example if I had a checkbox for address, selecting it on my form will show the address column in my query results.

View 4 Replies View Related

Problem With Changing Report Based On Checkbox

Aug 8, 2006

I have a form with one checkbox on at the moment. Depending on whether it is checked or not I want to choose to display or not display a field on a form.

I have the following code below but whether the checkbox is ticked or not it doesn't affect the report.

If Check4 = True Then
[Report_Temp].Medium.Visible = False
DoCmd.OpenReport "Temp", acViewPreview, , MyFilter

What have I missed?

View 2 Replies View Related

Creating A Checkbox That Returns Text On A Report

Apr 12, 2005

Dear All:

I have created a form with students information, name, address, ID number, etc.

Is there a way to place a checkbox on this form that when it is checked, it displays text on a SPECIFIC AREA ON A REPORT?

I wish it to return this text on a report: "HONORS COLLEGE"

Many thanks in advance,

Dion

View 2 Replies View Related

Reports :: How To Hide Unchecked Checkbox From Report

Aug 12, 2015

I want to hide on my report unchecked checkbox ?

How can i do that ? If i shall write a code, in which event ?? Or can i use in Query Build option ?

I searched on internet and found some answers but they are not useful

(i found this code and updated for my report but still did not work)

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) (<- what is that ??)
If Me.Skyliner = 0 Then
Me.SkylinerCover.Visible = True
Else
Me.SkylinerCover.Visible = False
End If

quote : [URL]....

View 5 Replies View Related

Print Report Based On Checkbox Selection

Oct 19, 2015

I'm having difficulties with building a printing option for specific goods selected on the list.

I have a form which contains a subform. On the main form user is able to select supplier and based on the supplier can choose article that he's interested in. On the subform user gets the list of all the goods that are connected with that specific article.

I want be able now to select specific goods from subform list (using checkbox value) and based on the selection print a separate label for each goods.

View 4 Replies View Related

Report Fields Visible Based On Checkbox

Sep 20, 2011

I have an Access 07 report, and when viewing the report I'd like to have some checkboxes visible based on their value. In other words, I need the checkbox to be visible if it's checked and not visible if it's not. I have the following in the OnLoad event of the report;

Me.Checkbox.Visible = Me.Checkbox.Value

This works fine in print preview but makes no difference in normal view, the checkboxes are visible regardless of value. I'd like to keep normal view if possible.

View 2 Replies View Related

Reports :: Make Yes / No Checkbox Visible On Printed Report

Aug 28, 2014

I have a form with a Yes/No checkbox. Sometimes a data entry person will use this, sometimes an associated report is printed and a technician in the field will be required to fill check the box by hand and return the report for data entry. what I have tried to format the check box, if the box isn't already checked, I can't get it to show up clearly on the printed report. It's set to Visible, width 6pt, solid, black, always display, yet it still is barely visible. Ive tried increasing the grid line thicknesses, making it shadowed, nothing seems to work. Is there anything I can do?

View 9 Replies View Related

Reports :: VBA Checkbox Code Ticking All Records On Report

Nov 13, 2013

I have the following code in the On Load of a report which shows multiple records:-

Code:
If Me.PaymentType Like "Debit/Credit Card" Then
Me.Check94 = True
Else
Me.Check94 = False
End If

This ends up checking all check boxes in the report if any have "Debit/Credit Card" in the PaymentType field.What I wanted was to tick Checkboxes for those records where the statement was true, and not tick those where it is false.Do I need the code in the On Current event? Or do I need more sophisticated code?

View 3 Replies View Related

Forms :: Making Textbox Visible On A Form If Checkbox Is Checked On Same Form

Aug 30, 2013

I am having a problem with making a textbox visible on a form if a checkbox is checked on the same form. I have done research on this site and have written the code below, but I am getting a Syntax error, see yellow highlight.

- My checkbox is named: Case is a Readmission from WRCA IP to WRCA IP
- My textbox is named: Date of Current IP Admission (I have defaulted this textbox to not visible).

Here's the code I have written:

Private Sub Case_is_a_Readmission_from_WRCA_IP_to_WRCA_IP_Clic k()
If Case is a Readmission from WRCA IP to WRCA IP =true then
Date of Current IP Admission.visible=true
Else
Date of Current IP Admission.visible=false

[Code] .....

View 14 Replies View Related

Using A Checkbox In A Query

Sep 6, 2005

I have created a query which search all fields in my database from one text box. Is it possible to search only records which have checkboxes ticked by ticking a checkbox on the search form/in the query.

Thanks in advance

View 2 Replies View Related

Query By Checkbox Value

Mar 23, 2007

Hi, Im trying to build query that filters my recors by checkbox value in form.
I have field id_reason with numeric values, my idea is that when checkbox1 = 1, id_reason is filtred by value 11, when checkbox1 = 0, id_reason <> 11.

i tryed this formula as criteria in design grid:
IIf([forms]![form1]![check1]=1;[id_reason]=11;[id_reason]<>11)
but IIF is not operator, so it doesnt work...

Can anyone help with this one? :cool:

tnx

View 8 Replies View Related

Checkbox In Query

Apr 2, 2008

Greetings to everyone,

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?
I would thank any help on this.

View 14 Replies View Related

Checkbox Query

Mar 10, 2006

I have a Form that I am doing for my local sporting Club that keeps a check of the games played each week by individuals. On my form I have a Textbox (txtGames) and a number of checkboxes that are to be checked if the player plays a game that week i.e.

TotalGames....Wk1...Wk2...Wk3...Wk4 etc to Wk14

If the individual has played for the week, they are checked off under the appropriate Week.

My question is, how do I populate the TotalGames textbox to count the number of checks for each Player.
I have searched on this Forum and have not found anything that resembles my problem.
I am very grateful for any help I can get. Thank-you!

View 1 Replies View Related

Set A Checkbox In VB By Query

Mar 14, 2005

Hello,
Can someone tell me how I can set a checkbox by running a query.

Here is what i want to do... On click of a button, query a table and if the field being queried is a Y mark the checkbox, if it is an N, do not mark the checkbox.

I can do the query with no problem, but how would i make it put the result into the checkbox?

Thanks,
ovadoggvo.

View 1 Replies View Related

Control The CheckBox In Form

Mar 22, 2005

Hi

Here I want to know how can i control the checkBox

when i enter ID in form i got the related feilds too so when i want
to edit the record i wnat to check if the checkBox is TRUE i get
messege that i cant edit this record?

http://lonelymoon2442.jeeran.com/checkBox.JPG

View 5 Replies View Related

Checkbox Search Form?

Oct 9, 2006

Hi all, hoefully someone will be able to help me with this. My idea basically is that my form will have 3 check boxes on it a command button and a combo box for results. What i want to achieve is that when the user fills the relevent check boxes the hits the command button the combo box will fill in automaticaly with the results (names) dependent on which check boxes were filled in.

Any help on this matter would be great I havesearched the net and cant find and tuturials ect for this.

View 3 Replies View Related

Forms :: New Form Using Checkbox

Oct 10, 2013

I downloaded Checkbox open form.zip from this site. It uses option group for the checkboxes

It runs perfectly when I double click in access but i would like to use this in vba when called from another form. When i put the code in and try to run it I get the error:

Compile Error
Method or data member not found

It is referring to .Frame8

Here is the code I used:

DoCmd.OpenForm "Mainform", acNormal

Select Case Me.Frame8
Case 1
Open Form 1
Case 2
Open Form 2
Case 3
Open Form 3
Case Else
MsgBox "You did not make a selection"
End Select

View 5 Replies View Related

Checkbox Update Query

May 24, 2005

I have a Mainform with a subform linked to a table.
Within the subform i have a number of individual checkboxes and a field [Year].
One checkbox, [checkboxIssue] i have wanted to link two update queries in order
to update the field[Year] with the contents of a [textboxValue] on the Mainform,
depending on the state of [checkboxIssue].
I have run both queries manually, one after the other and the table was updated perfectly.

The problem is that when i link it to the click_Event of [checkboxIssue]
in the subform i get zero updates.

Linked to the Dirty_Event of the subform i get good results for all except the last ammended
record and zero results if ammending only one record.

I am a relative Newbie and have learned a great deal from this forums expertise.
Can anyone enlighten me to what i think will be my very basic error.

Basic or not i have driven myself mad trying to solve it..:-(

View 3 Replies View Related

Checkbox Filter Query

May 31, 2005

Hey i have this really annoying bug, theres several tick boxes that im using to filter records but if i tick more than one i get a syntax query error? any idea what this could be? i have had several people look at the code and tell me theres nothing wrong.

Option Compare Database
Option Explicit
Const strSQL = "SELECT * FROM issues"

Private Sub filter_Click()
'Variable to hold filtered SQL string
Dim strFilterSQL As String

If check_os98 = True Or check_osnt = True Or check_os2k = True Or check_osnt = True Or check_osxp = True Or check_fxpda = True Or check_fxpc = True Or check_fxas = True Or check_fxrs = True Then
strFilterSQL = strSQL & " WHERE "
End If

If (check_os98 = True) Then
strFilterSQL = strFilterSQL & "os98 = True"
If check_osnt = True Or check_os2k = True Or check_osnt = True Or check_osxp = True Or check_fxpda = True Or check_fxpc = True Or check_fxas = True Or check_fxrs = True Then
strFilterSQL = strFilterSQL & " AND "
End If
ElseIf (check_osnt = True) Then
strFilterSQL = strFilterSQL & "osnt = True"
If check_os2k = True Or check_osxp = True Or check_fxpda = True Or check_fxpc = True Or check_fxas = True Or check_fxrs = True Then
strFilterSQL = strFilterSQL & " AND "
End If
ElseIf (check_os2k = True) Then
strFilterSQL = strFilterSQL & "os2k = True"
If check_osxp = True Or check_fxpda = True Or check_fxpc = True Or check_fxas = True Or check_fxrs = True Then
strFilterSQL = strFilterSQL & " AND "
End If
ElseIf (check_osxp = True) Then
strFilterSQL = strFilterSQL & "osxp = True"
If check_fxpda = True Or check_fxpc = True Or check_fxas = True Or check_fxrs = True Then
strFilterSQL = strFilterSQL & " AND "
End If
ElseIf (check_fxpda = True) Then
strFilterSQL = strFilterSQL & "fxpda = True"
If check_fxpc = True Or check_fxas = True Or check_fxrs = True Then
strFilterSQL = strFilterSQL & " AND "
End If
ElseIf (check_fxpc = True) Then
strFilterSQL = strFilterSQL & "fxpc = True"
If check_fxas = True Or check_fxrs = True Then
strFilterSQL = strFilterSQL & " AND "
End If
ElseIf (check_fxas = True) Then
strFilterSQL = strFilterSQL & "fxas = True"
If check_fxrs = True Then
strFilterSQL = strFilterSQL & " AND "
End If
ElseIf (check_fxrs = True) Then
strFilterSQL = strFilterSQL & "fxrs = True"
End If

strFilterSQL = strFilterSQL & ";"
Me.RecordSource = strFilterSQL
Me.Requery
End Sub

View 14 Replies View Related

Link A Checkbox On My Form To Another Table

Oct 7, 2005

This form is bound to another table. Now i want to include a checkbox on this form that will be bound to an entirely different (small) table. How do i do this? :)

View 14 Replies View Related

Hide Form When Checkbox Ticked

Dec 20, 2005

Hi All.
What I would like to do, is have a form popup when the main form is opened in my db, which will detail all the changes I have made to it since the last version (this bit is OK) and also, I would like a checkbox on the popup form, that the user can tick once they have read the details so it will not show up everytime they open the main form. (Just like the "hidestartupform" property within the Northwind Database)

I create the form and all that, but do not know how to do the checkbox so once it is checked, the form will not appear.

Hope this makes sense and someone can enlighten me and point me in the right direction?

Many Thanks.

Frank.

View 4 Replies View Related

Tables :: How To Uncheck A Checkbox In Form

Nov 21, 2012

I have a table "LightDuty" with a field [Email Sent] that is a YES/NO field.

I do not have a checkbox on the main form for the [Email Sent]; instead this field is checked (in the table) when the user sends an email to the receipient. I use the [Email Sent] field as a criteria for my query.

I need to uncheck the checkbox when the user changes the date in a field called [Drs Excuse Exp].

This is what I have tried (in the AfterUpdate event of the Drs Excuse Exp control):

Code:
Dim db as DAO.Database
Dim rs as DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("LightDuty")

[Code] .....

I get the runtime error 3265 "Item not found in collection"

View 1 Replies View Related

Checkbox Filter On Continuous Form

May 27, 2015

On my continuous form, I have a field that is a checkbox. I would like to place an unbound checkbox/radiobutton in the form header so that when the it is checked, it will display only records that are checked, and when it is unchecked, it will only display records that are unchecked.

View 2 Replies View Related

Create Query With Checkbox In Result

Aug 21, 2005

I am trying to create a form using VBA which will be a list of people, in a particular group, with a checkbox next to each name. The point of the form is so that the user can check those individuals who shoud not be included in a particular process. The names are the result of a query and the list will be of different lengths each time. I have tried to create a query with the first field being the person's name and the second field a checkbox, which would default to No. Then I would be able to use each name with it's checkbox to accomplish this. What I really need help with is the query, so that one of the output fields is a checkbox.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved