Over 1 million tech questions and answers.

Google sheets: reset several checkboxes

Q: Google sheets: reset several checkboxes

As mentioned in the heading, is it in any way possible to reset several checkboxes all at once?

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Google sheets: reset several checkboxes

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 75.6

Hi, I have one questions. I wanna ask if is possible to insert multiple checkboxes in all sheets at the same time? I already done many search on internet about this but I gain nothing. It is possible to solve this using excel vba? or there any other way? just wonder. Thanks you for any helps.
 

Read other answers
RELEVANCY SCORE 54

Hi All,
I am a secretary of a football club and I am looking to make a membership database using Google sheets which I can sync to Google drive and allow me to update while in the club office or while I am on my home PC.
As well as a database of members names and addresses, I would have column's for member type, DOB, email and a photo which I would like to open up in another page when I click on it


I was wondering if someone out there would have any ideas of how I could make this as I'm a bit of a novice.
Thanks in advance
Brianljnr
 

A:Google Sheets Question

Brian, you can probably find instructions at Google Docs \ Sheets Help.
 

Read other 1 answers
RELEVANCY SCORE 54

I'm trying to sort columns A, B and C alphabetically so that the correct # in Column A corresponds with columns A and B.
Thank You,
Gary
 

A:Google Sheets alpha

Well Column A are numbers in numerical order. The sort will not change because it's in order already.

What column are you looking to be in alphanumeric order?
 

Read other 1 answers
RELEVANCY SCORE 53.2

Hi all, lurker and infrequent poster here with a few questions about scripting buttons in google spreadsheets.
(Please be patient with me - my only relevant-ish experience here is with MatLab)
 
 
I am setting up a google sheet for people to suggest items for the office and for others to vote on them. For each item, I want there to be a "yes" tally and a "no" tally, rather than a single tally that takes the difference. In order to stop people from cheating and just filling in a cell with whatever value they want, I am using buttons scripted with Google's apps scripts. (If you haven't used it, this youtube video gives a simple explanation, and is similar to what I'm doing: ).
 
So far, I have my rows (items) with two buttons each (yes/no). I was hoping there was a way to automate the creation of these buttons, so more are added as people add more suggestions to the bottom of the list. I'm guessing the easiest way would be some master button that "refreshes" and adds the buttons to a row only when the item-name column has been filled in. The problem is, I can't figure out how to create a new button from within a script.
 
My other concern is how to stop someone from voting on an item more than once, as this spreadsheet will be accessible to them as many times as they'd like. I will be sharing it to our email list, so only someone logged into their email can access this. I'm sure I can track it this way, but I don't know how to get that informat... Read more

Read other answers
RELEVANCY SCORE 53.2

Hi all, lurker and infrequent poster here with a few questions about scripting buttons in google spreadsheets.
(Please be patient with me - my only relevant-ish experience here is with MatLab)
 
 
I am setting up a google sheet for people to suggest items for the office and for others to vote on them. For each item, I want there to be a "yes" tally and a "no" tally, rather than a single tally that takes the difference. In order to stop people from cheating and just filling in a cell with whatever value they want, I am using buttons scripted with Google's apps scripts. (If you haven't used it, this youtube video gives a simple explanation, and is similar to what I'm doing: ).
 
So far, I have my rows (items) with two buttons each (yes/no). I was hoping there was a way to automate the creation of these buttons, so more are added as people add more suggestions to the bottom of the list. I'm guessing the easiest way would be some master button that "refreshes" and adds the buttons to a row only when the item-name column has been filled in. The problem is, I can't figure out how to create a new button from within a script.
 
My other concern is how to stop someone from voting on an item more than once, as this spreadsheet will be accessible to them as many times as they'd like. I will be sharing it to our email list, so only someone logged into their email can access this. I'm sure I can track it this way, but I don't know how to get that informat... Read more

Read other answers
RELEVANCY SCORE 52

I am using conditional formatting with a custom formula in Google Sheets to fill color the minimum and maximum values in a column.

The minimum works just fine:

Code:
=$AG:$AG=min(AG:AG)
But if I change min to max nothing in the column gets highlighted.

Code:
=$AG:$AG=max(AG:AG)
The range is set to AG2:AG25
 

Read other answers
RELEVANCY SCORE 52

Hi!

I'd like to get a few cells in a list from a Google Sheets.
I have the following data:
First list horizontally: 1 in C2, 2 in D2, 3 in E2
Second list vertically: 1 in C5, 2 in C6, 3 in C7
Here is the test sheet: https://goo.gl/UDooqL

I use the following script:

function onEdit(){
var tabla = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var aktivcella = tabla.getActiveCell();
if(aktivcella.getColumn() == 1 && aktivcella.getRow() > 1){
var vizszinteslista = tabla.getRange(2, 3, 1, tabla.getLastColumn()).getValues();
var fuggolegeslista = tabla.getRange(5, 3, tabla.getLastRow(), 1).getValues();
Logger.log(aktivcella.getValue());
Logger.log(vizszinteslista);
Logger.log(fuggolegeslista);
tabla.getRange("E8").setValue("a script lefutott");
}
}

This results in the log:

[<<timestamp>>] Igen
[<<timestamp>>]] [[1.0, 2.0, 3.0, , ]]
[<<timestamp>>] [[1.0], [2.0], [3.0], [], [], [], []]

Why the two list differs?

Thanks.
 

Read other answers
RELEVANCY SCORE 46.8

Using Google Sheets. Why am I getting this error msg? "Cannot sort a range containing merges." I DON'T have any merged columns, or merged anything. No hidden columns, or at least they weren't hidden when I tried to do the sort.

I tried to attach the file as a XLSX, and CSV, and both formats gave me an error.

A:Error Msg "Cannot sort a range containing merges." in Google Sheets

Quote:
try selecting all cells, then click Format > Merge cells > Unmerge


https://productforums.google.com/for...cs/b1B5ZswXytE

A Guy

Read other 3 answers
RELEVANCY SCORE 46.8

So, I've been looking up the topic for quite a while and it's suddenly become critical to what I am doing. Everywhere I have looked, I see lots of ways to copy multiple sheets into one sheet. This doen't do me the least bit of good. I have two 70+ tab spreadsheets. One for actuals, one for forecast. I need to copy the actuals for the first 5 fiscal periods of the year into the Forecast file. As there are 70+ sheets, I would prefer not to do this one at a time. In know in the previous versions of Excel, I could simply highlight all the sheets, highlight the data I needed, hit copy, and paste the data in the new sheet. So long as the sheets were laid out the same, it was never a problem.

Do you have any idea how to do this now?

Thank you.
 

A:Excel 2010 copying multiple sheets into multiple sheets

Read other 7 answers
RELEVANCY SCORE 42

Hello,

I'm trying to write a code on VBA on excel to make a spreadsheet with checkboxes that output sentences in cells next to them when the user ticks the relevant checkboxes.

Here's the catch, I need several checkboxes on the same sheet, and each checkbox needs to output a different value.

So for example, if i check one box, it will output "hello", and if I check the other box, it will output "how are you".

Can anyone suggest how to approach this?

Thanks!
 

A:VBA checkboxes

Is your goal to only allow the user to select one checkbox value? If so you will need to use Option Buttons instead since you can limit the user to one selection per group of controls.
 

Read other 1 answers
RELEVANCY SCORE 42

Hi, Just bought a new MSI AE2220 all in one with Win7 installed, and I noticed that whenever I click into Documents, a small checkbox appears against all listed items.
This doesnt happen on my other Win 7 PC`s, so I wondered if anyone can give me some info on this. thanks, fred

A:Checkboxes

That is happening because the option "Use checkboxes to select items" is enabled in the "View" tab of "Folder Options". If you dont like this feature, click on Start and and type "Folder Options" into the search box and hit Enter. Then in "View" tab, in "advanced settings", scroll down and uncheck the option "Use checkboxes to select items", then click Apply, OK.

Read other 1 answers
RELEVANCY SCORE 41.6

on a worksheet i have numerous activex checkboxes, is it possible to automatically check or uncheck them based on two cell values, see example below

cell c4 = 52 (input by user)

cell c5 = 39 (input by user)

if cell c5's value is less than c4's then checkbox1 = true
if c5's value is higher than c4's then checkbox1 = false

also could you add a third argument, i.e

if cell c5's value is less than c4's and checkbox1 = true then checkbox2 = true or if
c5's value is higher than c4's and checkbox1 = true then checkbox 2 = false

i know i could just check or uncheck them manually, but there will be about 30 checkboxes on the sheet when it is finished (nb not all checkboxes will relate to cells c4 and c5)

many thanks
 

Read other answers
RELEVANCY SCORE 41.6

I have several checkboxes on a worksheet; ~50. I would like to set up a Command Button to reset all the checkboxes = to False. I'm looking for a better way to set all the checkboxes to false without having to type each one....CheckBox1.Object.Value = False.

Any ideas??
 

A:Active X Checkboxes-VBA

But I have seen others write code that iterates through all the objects on a form, checks the type of the object, and based on that type, performs some function. Something like:

Private Sub ClearAll ()
Dim ctl As Control

For Each ctl In Me.Controls
If ctl.ControlType = acCheckbox Then
ctl.Enabled = FALSE
End If
Next ctl
End Sub

Like I said, I haven't done this and this code probably has a lot of errors, but it should put you on the right track...
 

Read other 2 answers
RELEVANCY SCORE 41.6

Hi,

i have a checkbox on a form, when the checkbox is ticked how do i get it to display a "Y" in the table and a "N" when not ticked?

Thanks
 

A:Access Checkboxes

Read other 10 answers
RELEVANCY SCORE 41.6

I have 2 tables one with employee information, and one with contract information. Only certain employees are trained at certain contracts. What I would like is when I pull up contract information there is a list of employees who are trained at that contract, and when I pull up the employee information there is a list of the contracts that they are trained at. I want these to be checkboxes and to only display the contracts they are trained at, not all contracts.

What's the best way to go about this?
 

A:Access checkboxes

Read other 10 answers
RELEVANCY SCORE 41.6

Hi,

I'd lie a little help please regarding Excel 2007 checkboxes. I have 3 of them but I only need one to be checked at a time. Can it be done with VBA automatically?

Thank you in advance.
 

A:Excel checkboxes

Read other 6 answers
RELEVANCY SCORE 41.6

Hi,

Please see the attached file.

In my Output Tab, I want to check mark a checkbox depending on the Data Tab.
I want to write the code in VBA,

Here is my VBA code:
Sub Autpen()
Dim wk As Excel.Workbook
Set wk = Application.ActiveWorkbook
'Not sure how to execute the checkboxes. Please advice, Thank you.
Set wk = Nothing
End Sub

Thank you
 

A:Excel: Checkboxes

Read other 6 answers
RELEVANCY SCORE 41.6

hello...

There is a website I work on that have pages of checkboxes but no 'select all checkboxes' option. Is there a hot key or an add-on I could download that would select all of the check boxes on a webpage without manually clicking on each and every one of them?

Thank you!

- joshua -

Read other answers
RELEVANCY SCORE 41.6

hi all

rather than have a number of buttons or commandbuttons cluttering up a sheet, i have set up a userform that can be called where option buttons give the user a choice of what they want to do, my problem is on the main sheet are a mix of form check boxes and activex checkboxes, from the userform using 1 option button when it is checked i would like all the checkboxes on the sheet to be set to false,
i have tried code that works on the sheet module but can't figure out how to get it to work throu' the userform
any help appreciated

scouse13
 

A:checkboxes clear

Some like for all checkbox on sheet if xxx is true set all to false, but then in vba code form
 

Read other 1 answers
RELEVANCY SCORE 41.2

Hi,

I want to create a MS Word doc with checkboxes which others can check and uncheck. I have found out that I can add checkboxes by using Control Toolbox. I believe I need to write some VB code in the click event of each checkbox. I have added coding like this:
if checkbox1.value then
checkbox1.value = false
else
checkbox1.value = true
end if

After I saved the doc, when I open the doc, it will ask me whether to enable or disable macro. After the doc is opened, clicking on a checkbox sometimes will bring up the code editor or sometimes simply does nothing.

My expectation is that when I send this doc to others, others can click on those checkboxes to check or uncheck but they won't able to see the VB coding.

Thank you for any help.
 

A:How to add checkboxes to MS Word 2000?

Read other 9 answers
RELEVANCY SCORE 41.2

Hello all

I created an mfc application which uses List Control. I want to use checkboxes in this List, I set the property like

listctrl.SetExtendedStyle(LVS_EX_CHECKBOXES);

Now I'm able to list checkboxes in list control. But the problem is when I'm clicking on checkbox the entire row is not being highlighted. I used LVS_EX_FULLROWSELECT flag but of no use.
I'm using LIST view style for this list control.

How to code so that the checkbox is checked/unchecked if I click on checkbox as well as the label associated with checkbox. Similarly background should be highlighted if the checkbox state is checked. It seems in this case both checkbox and label are acting independent of each other.

Pls help me with an example , Thanks in advance.
 

Read other answers
RELEVANCY SCORE 41.2

Hello

I'm trying to get a checkbox to apply to two rectangles so that when checked, they will be green, and unchecked will be red.

I've got the code for that sorted, the only issue is this:

eg.

* Rectangle 1 is in Cell A2; Rectangle 2 is in Cell A3.
CheckBox 1 applies to BOTH of these rectangles to change their colour depending on its status.

However, if I select the whole row to reorder them, (eg, row two is moved down to become row 10), the whole process goes out of kilter and CheckBox 1 no longer changes the colours of Rectangles 1 & 2.

Sorry it's so long winded. Look forward to some help!

Thanks.
M
 

A:Solved: Excel Checkboxes

"Rectangle 1 is in Cell A2; Rectangle 2 is in Cell A3."

No, they only look like they are. Shapes can't be in cells, they can only hover over -- since they exist in a "separate ?layer? of the object model" (or something like that ).

Anyway, I positioned 2 Drawing toolbar rectangles over A2 & A3 respectively. I added a Forms toolbar checkbox to the sheet. I named G1 "Link", then set the checkbox cell link to "Link".

Then I assigned this code to the checkbox:

Sub test()
If Range("Link") = True Then
ActiveSheet.Shapes("Rectangle 1").Fill.ForeColor.SchemeColor = 11
ActiveSheet.Shapes("Rectangle 2").Fill.ForeColor.SchemeColor = 11
Else
ActiveSheet.Shapes("Rectangle 1").Fill.ForeColor.SchemeColor = 10
ActiveSheet.Shapes("Rectangle 2").Fill.ForeColor.SchemeColor = 10
End If
End Sub

It worked. And still worked after adding some rows at the top. HTH
 

Read other 3 answers
RELEVANCY SCORE 41.2

ok here it goes
i was wondering what i ma doing wrong i keep getting this in my debugger.

document.all has no properties....

do i need to change the way i reference my checkboxs?

heres the code any help would be greatly appreciated
var chk0 = false;
var chk1 = false;
var chk2 = false;
var chk3 = false;
var chk4 = false;
var chk5 = false;
var chk6 = false;
var chk7 = false;
var chk8 = false;
var chk9 = false;
var chk10 = false;
var storedVals;

function GetCookie(sName)
{
// cookies are separated by semicolons
var aCookie = document.cookie.split("; ");
for (var i=0; i < aCookie.length; i++)
{
// a name/value pair (a crumb) is separated by an equal sign
var aCrumb = aCookie.split("=");
if (sName == aCrumb[0])
return unescape(aCrumb[1]);
}

// a cookie with the requested name does not exist
return null;
}

function setCookie(cookieName, item, exMin)
{
var expdate = new Date ();
expdate.setTime (expdate.getTime() + (exMin * 60 * 1000));
document.cookie = cookieName + " = " + item + ";path=/;expires = " + expdate.toGMTString();
alert(item);
}

function setChecks()
{
if(storedVals != null)
{
var chkVals = storedVals.split(',');
chk0 = chkVals[0];
chk1 = chkVals[1];
chk2 = chkVals[2];
chk3 = chkVals[3];
chk4 = chkVals[4];
chk5 = chkVals[5];
chk6 = chkVals[6];
chk7 = chkVals[7];
chk8 = chkVals[8];
chk9 = chkVals[9];
chk10 = chkVals[10];
}

document.for[0].checked = chk0;
document.all['w... Read more

Read other answers
RELEVANCY SCORE 41.2

thanks for the reply zack

regarding the previous thread

what i have done is set up a few darts games to play on the laptop, a different game on different worksheets, what i would like to use the checkboxes for is when selected and the command button pressed that activates the worksheet chosen

i have 8 checkboxes the first 4 are for players 1 - 4
the last 4 are for the four different games that can be played, what i would like to happen is if the first checkbox is selected( 1 player )
and the first of the games checkboxes is chosen then when the command button is pressed that worksheet is activated
obviously the code needs to be set for all possibilities

i.e 1 player game 1
2 players game 1
3 players game 1
1 player game 2 etc etc

hopefully this explains what i am trying to achieve

many thanks
scouse13
 

Read other answers
RELEVANCY SCORE 41.2

I would like to use Gmer to get help with a very tough infection I have, but 80% of its check boxes are disabled. I only have Services, Registry, Files, ADS & Show All enabled.

Is this a known issue? is it even an issue?

A:Gmer - Disabled checkboxes

Welcome aboard GMER is just a scanner. It doesn't cure anything.What are your computer issues?

Read other 1 answers
RELEVANCY SCORE 41.2

Hello, I am making an Access database and I have a problem that I'm not sure how to solve.

I have a main form, which looks at records from a main table. All other tables in the database contain records, and each of those records pertains to one particular record in the main table. That is to say, all other tables exist in many-to-one relationships with the main table.

The main form has a subform which displays one record at a time from one of those other tables, specifically, records that correspond to whichever record the main form is displaying. Let's call the record that this subform is looking at 'Record A'. All fairly simple so far.

Now, on the subform, I have two checkboxes. They aren't for the user, these are automatic. One is for "Before an event" and one is "After an event". I want them to be automatically checked on or off, depending on whether records exist in a table (a list of events that correspond to records in the main table) that suit some requirements. Consider Record X, in this third table of events. Record X suits the requirements if:

Record X corresponds to the same item on the main table as Record A
The 'date' field of Record X is before (or after, depending on the checkbox) the date of Record A
So if there exists at least one event such that Record A is before it, then the "Before an event" box is checked on, and if there exists at least one event such that Record A is after it, then ... Read more

A:Access: Automatic checkboxes

Read other 10 answers
RELEVANCY SCORE 41.2

How can I ask coworkers a question in Outlook 2007 (using checkboxes probably) so they can choose multiple answers? The question is: How many Canadian Capital Cities have you visited? Then I would have the cities listed in the email. Therefore, I can't use the Voting buttons because that only gives the person one choice to choose.
 

A:Checkboxes in Outlook 2007

Read other 12 answers
RELEVANCY SCORE 41.2

In most of the tables I create in Access 2000 that contain a "yes/no" field, the field displays as a checkbox when you open the table. But in some other tables, it displays not as a checkbox, but as "Yes" or "No". The format property in both tables is the same: Yes/No.

What am I doing in some tables that makes it display as "Yes" or "No" and in others as a checkbox? How can I change the field to a checkbox in tables where it displays as "Yes" or "No"?
 

A:Solved: Checkboxes in Access

Read other 7 answers
RELEVANCY SCORE 41.2

I have a forum called FrmAgent that i created in access 2007. It id pulling information from a table called "Agent". in my forum i have 5 checkboxes with names next to them. The names are also found in the table in a column called Agent Name. What i want is if the check box is checked next to that persons name it crabs the data and runs the query when a button is clicked. Example if one or more boxes are clicked it would run the data. Does this make sense? If anyone could help me that would be great. I am very new to vba and access so any help would be great. examples too. Thank you again
 

A:How to return data using checkboxes

Read other 6 answers
RELEVANCY SCORE 41.2

I want to be able to share various folders includiing My Documents and the folders within My Documents. When I right click on the folder to open the properties box and then open the sharing tab so I can go ahead and select the options to share, the checkboxes and the text next them appear as shown here in this screenshot, grayed out like this and not allowing me to place a checkmark in any of them. (The grayed out checkmark appears as shown also, where it says "make this folder private.") So I can't check or uncheck any of these boxes in order to share these folders.
Its Windows XP. I'm logged in with an administrator user account.
What's the deal, how come these checkboxes are like this which doesn't allow me to put checkmarks in them to share the folder(s)?
 

A:file sharing checkboxes

XP Home and XP Pro with Simple File Sharing prevents network sharing of several folders; My Documents is one such folder.

If you have XP Pro you can use Advanced File Sharing and share whatever you like.
 

Read other 2 answers
RELEVANCY SCORE 41.2

hello...

There is a website I work on that have pages of checkboxes but no 'select all checkboxes' option. Is there a hot key or software out there that would select all of the check boxes on a webpage without manually clicking on them?

Thank you!

- joshua -

Read other answers
RELEVANCY SCORE 40.8

Hi forum,
 
My browser google chrome was hijacked whenever I added a new tab, a page "Internet Search" was shown.  Does anyone know where in the chrome I can reset this add new tab function to be a blank page or google's front page ?  I cannot get rid of this "Internet Search" pre-set page.
 
Thank you forum.

A:How to reset google chrome new tab page ?

Hi cuhkwan,

This link contains instructions on resetting the homepage and a new tab page in google chrome,http://karathecomputertutor.com/2013/05/how-to-change-the-homepage-and-new-tab-page-in-google-chrome/
 
If you continue to get this problem i suggest you post about it in the following forum,http://www.bleepingcomputer.com/forums/f/103/am-i-infected-what-do-i-do/
Thanks,
Xen

Read other 3 answers
RELEVANCY SCORE 40.8

Hi,

I am working on an Excel worksheet with over 200 checkboxes (CheckBox1, CheckBox2, etc.). I use VB6 to open the Excel worksheet but accessing the value of the cell where the checkbox is, is very challenging. I have used the following in VB6 code to no avail:

'the cell contains a checkbox, and i want to see the logical value (checked or unchecked) so i can assign a 'corresponding numerical value but the content it's showing is 'Empty'. It's a protected worksheet btw.

xlsWB1.WorkSheets(strWorkSheetName).Select
xlsWB1.WorkSheets(strWorkSheetName).Range("H8").Value 'this shows me an 'Empty' value

Also tried this one but gave me this runtime error: 'Unable to get the CheckBoxes Property of the WorkSheet class'

xlsWB1.WorkSheets(strWorkSheetName).Select
xlsWB1.Activesheet.CheckBoxes("CheckBox5").Value

Also this without success:

xlsWB1.WorkSheets(strWorkSheetName).Select
xlsWB1.Activesheet.CheckBox5.Value 'Error says: Object doesn't support this property or method

I am not sure how to proceed with this and suggestions would be most welcome.

-Andy7472007
 

A:Referencing CheckBoxes in an Excel WorkSheet

Hi,

I do not think the check boxes are linked to the cells.
The follow code will loop thru the
"Forms" checkbox and the "ActiveX" checkboes.
You will not that they use a integer. If you have 200 of them then change the sample to 200.
Code:
Sub test()
'' For ActiveX ''
Dim i As Integer
For i = 1 To 4
With ActiveSheet
If .OLEObjects("CheckBox" & i).Object.Value = True Then
MsgBox ""
End If
End With
Next i
End Sub

Code:

Sub test1()
'' For "Forms checkboxes"'''
For i = 1 To 36
With ActiveSheet
If .CheckBoxes("Check Box " & i).Value = 1 Then
''Do something ''
End If
End With
Next
End Sub
 

Read other 2 answers
RELEVANCY SCORE 40.8

I have an excel sheet that i would like to add a checkbox to.
The checkbox should be cleared every time a condition in cell A1 is met (i.e. FALSE) so that the user is then forced to check it again.
There will be multiple sheets to the workbook with this scenario.

Please help, I cannot figure out the vba code required to control the checkbox in this way. I do not mind whether i use a form field or the control toolbox.
 

A:Excel - cell control of checkboxes

Ok,
I have figured out this much now. It works but only if I manually enter the value "TRUE" into cell S6.
If this cell is returning a "TRUE" value by performin an IF function it wont work.
I would very much appreciate any assistance in solving this problem.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "S6" Then
Application.EnableEvents = False
If Target.Value = "TRUE" Then
ActiveSheet.CheckBoxes("Check Box A") = False
End If
Application.EnableEvents = True
End If
End Sub
 

Read other 2 answers
RELEVANCY SCORE 40.8

Hi. Lets say that i have a table that contains check boxes. My report lists all the checkboxes, and down in the page footer, I want to have a text box that counts the number of checked boxes. My checkbox name is called checkbox and i've tried many variations of =Sum and =Count and can't seem to get it to work. My textbox always ends up showing =Error when I run the report. Any suggestions?

Thanks.
 

A:Counting Checkboxes in Access Report

Have you tried this variation?

=Sum(Iif([checkbox]=True;1;0))

The problem with this is that you probably want a total just for the page in question. Access doesn't do this without a little more complexity than you might expect, but it does do it. This article from MS shows you how it works:

ACC2000: How to Create Page Totals on a Report
 

Read other 3 answers
RELEVANCY SCORE 40.8

Hey everyone. Here's my info:
Windows Vista Home Premium
Service Pack 2
Dell Inspiron 1525

Right now I'm operating in Safe Mode with Networking because Normal Mode wouldn't let me run Microsoft Security Essentials to fix a virus. The virus is one of those fake security system ones that won't let me run any programs. Anyway, the virus is not my main problem I think.

I want to turn on System Restore. Windows Help & Support leads a walkthrough that opens System for me. Once there, the tutorial says to open System Protection. Once that is does, it says "To turn on System Protection, select the check box next to the disc, then click OK."

In my version, there is no check box. I'm very confused. Thanks in advance everyone!

A:no checkboxes in my Vista system restore

Do you know what fake security programs it is?

Read other 3 answers
RELEVANCY SCORE 40.8

With the LCARSTrek theme in Firefox 15, the checkboxes in the clear history window from the Tools menu are nonfunctional. What would cause that? I changed the images and the checkbox.css file to use code and images from another theme, and the boxes in that window did not change, but they did everywhere else. How does one bind checkboxes to a particular window to make them functional?

A:Dead checkboxes in a theme in Firefox 15

There is probably an incompatibilty with that theme and FF15. The coding for that particular area might have a glitch that it didn't have in FF14 etc.

Read other 4 answers
RELEVANCY SCORE 40.8

Dear All,

I am developing an application in which I require a "tree control with checkboxes".
The structure of tree control is as:

Main_Root
Child_1
Child_2
Child_3
Child_4
Child_5
Child_6

ie. simple tree having one main root and having many child items.

I have two problems related to it.

1)
All child items should be checked to TRUE whenever we click 'root' checkbox and vice-versa. How to proceed for it ???????

I mean to say that which event should I capture for this.( ie. TVN_SELCHANGING )

(I am sending my function along with this query. This function is used to check all the items present under one root )
2)
Is there any way to disable a particular check-box in tree control.

Thanks in advance.
 

Read other answers
RELEVANCY SCORE 40.8

I want to be able to share various folders includiing My Documents and the folders within My Documents. When I right click on the folder to open the properties box and then open the sharing tab so I can go ahead and select the options to share, the checkboxes and the text next them appear as shown here in this screenshot, grayed out like this and not allowing me to place a checkmark in any of them. (The grayed out checkmark appears as shown also, where it says "make this folder private.") So I can't check or uncheck any of these boxes in order to share these folders.
Its Windows XP. I'm logged in with an administrator user account.
What's the deal, how come these checkboxes are like this which doesn't allow me to put checkmarks in them to share the folder(s)?
 

A:Solved: file sharing checkboxes

Here's what I was talking about in my post in this thread.
 

Read other 3 answers
RELEVANCY SCORE 40.4

hi m new to all this.i have a weird problem the target box in my gogle chrome  keeps reseting itself to yeabd.cc. plz help. i dont know what to do.i tried removing virus i tried running adwcleaner also but it was not responding on cleaning stage..hel plz.i dnt know much abt technology plz be simle with ur language and dnt use technical language...plzz plzzz help. its getting on my nerves now as i have resently purchased new system..its been 15 days and all this problem is making me going nuts

Read other answers
RELEVANCY SCORE 40.4

hi m new to all this.i have a weird problem the target box in my gogle chrome  keeps reseting itself to yeabd.cc. plz help. i dont know what to do.i tried removing virus i tried running adwcleaner also but it was not responding on cleaning stage..hel plz.i dnt know much abt technology plz be simle with ur language and dnt use technical language...plzz plzzz help. its getting on my nerves now as i have resently purchased new system..its been 15 days and all this problem is making me going nuts

Read other answers
RELEVANCY SCORE 40.4

I have XP vista and IE7. I didn't have this problem earlier but recently popped up but not sure of the reason. All my IE screens display in grey and I can't see checkboxes proprely on any webpages.When I click a checkbox I can't see the whether it is checked or not. Please see the attached screen capture. I have highlighted the problem area in red. Please help me it's so annoying to work with that way. Please do let me know if any more information is required to understand the problem.

A:Vista XP & IE7 - Display in grey color and checkboxes

Vista XP? What is that?

Reinstall IE. Does this happen in another browser?

Read other 5 answers
RELEVANCY SCORE 40.4

I have a form with a datasheet subform. The Subform has a field "SA" that is a checkbox. I have put a command button on the main form that will check the checkbox of all the records that appear on the datasheet subform. I have the following code which works for all the records in the subform for the first record in the main form but will not work on any other records. I also would like to be able to deselect all as well if needed. Here is my code.

Code:

Private Sub CheckSA_Click()
Dim rs As DAO.Recordset
Set rs = Forms![Chronics Edit]![Data Subform Simple].Form.RecordsetClone
Do While Not rs.EOF
rs.Edit
rs!SA = True
rs.Update
rs.MoveNext
Loop
Set rs = Nothing
End Sub
 

A:Solved: MS Access Select All Checkboxes in Subform

I figured it out by adding

Forms![Chronics Edit]![DATA Subform Simple].Form.Requery
 

Read other 1 answers
RELEVANCY SCORE 40.4

I have XP vista and IE7. I didn't have this problem earlier but recently popped up but not sure of the reason. All my IE screens display in grey and I can't see checkboxes proprely on any webpages.When I click a checkbox I can't see the checked values. Please see the attached screen capture. I have highlighted the problem area in red. Please help me it's so annoying to work with that way.
 

A:Vista XP & IE7 - Display in grey color and checkboxes

Any help on this question ?
 

Read other 2 answers
RELEVANCY SCORE 40.4

I searched the forum, but did not quite find what I need.

I created a database in Access 2007 that had an "Active" checkbox. I thought I knew what it meant. As it turns out, I was wrong. Now, I found that there are three categories to that one checkbox (Active, Retention, and Inactive). I created one more checkbox for Retention, and I thought my problem was fixed. However, upon further reflection, I realized that, as it is currently set up, both Retention and Active can be selected, and that will not work. So, my thought was to use an option group.

Problem: Database is already in use by staff, and I'm not sure how best to proceed without over-complicating things. Also, I know little to nothing about option groups. I have a feeling that I may have some trouble with the -1 option value, but I don't know what it means. Does anybody have some helpful hints or ideas?
 

A:How to alter 2 Checkboxes to an Option Group in Access

Read other 11 answers