473,385 Members | 1,347 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

"Check all" button checkboxes in MS Access

15
Hi,

I have a "continuous" subform which is linked to a table which has a checkbox field. I would like to create a Check All/Uncheck All checkbox control that both checks and disables the checkboxes in the subform.

At the moment I can disable/enable all textboxes, however my coding only checks/unchecks the FIRST checkbox in the subform, and ignores the other checkboxes in the list. My current VBA code is:

Private Sub Check5_AfterUpdate()
If Check5 = True Then
Aust_Ent_Sum = True
Aust_Ent_Sum.Enabled = False
Else
Aust_Ent_Sum = False
Aust_Ent_Sum.Enabled = True
End If
End Sub

"Aust_Ent_Sum" is the name of the checkboxes i want to check. Any help in checking/unchecking ALL the checkboxes would be appreciated!

Thanks, Siwei
Apr 3 '07 #1
4 11632
ChaseCox
294 100+
I answered a similair question here,

The Scripts
Apr 3 '07 #2
chengsi
15
ChaseCox,

Appreciate your reply, however my issue is that the number of checkboxes are not fixed as they are determined by the number of entries in the table (which is dynamic). Also, the checkboxes do not have individual names as they are essentially one control (i.e. Aust_Ent_Sum) being used to represent the entire field in a continuous form.

I had been thinking maybe some sort of loop is required in VBA, but not sure. Anyone have any suggestions?

Thanks, Siwei
Apr 4 '07 #3
ChaseCox
294 100+
ChaseCox,

Appreciate your reply, however my issue is that the number of checkboxes are not fixed as they are determined by the number of entries in the table (which is dynamic). Also, the checkboxes do not have individual names as they are essentially one control (i.e. Aust_Ent_Sum) being used to represent the entire field in a continuous form.

I had been thinking maybe some sort of loop is required in VBA, but not sure. Anyone have any suggestions?

Thanks, Siwei
Are you actually creating them as you go along? if so how is that done?
Apr 5 '07 #4
mrowe
7
Try looking at the following post:
http://www.thescripts.com/forum/showthread.php?p=2449139#post2449139

I believe you are having the exact same problem that someone else helped me solved.
Mark
Apr 5 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Askari | last post by:
Hi, How do for do a "select()" on a CheckButton in a menu (make with add_checkbutton(....) )? I can modify title, state, etc but not the "check state". :-( Askari
4
by: Matt | last post by:
In ASP page, there is a "SELECT ALL" button, when user click it, it will select all checkboxes. I am not sure should I use client-side code to do that? the following is my approach but it didnt...
3
by: Not Me | last post by:
Hi, Is there any criteria I can use in my where clause to say 'anything'? Maybe like the _ used in some languages? For my example, I want to use an inline-if, so if a checkbox is ticked I say...
4
by: meganrobertson22 | last post by:
Hi Everyone- I have a question about how to add and then use the "All" selection in a combo box. I am trying to figure out how to: (1) add "All" as a selection to a combo box and then (2)...
7
by: Jaime Stuardo | last post by:
Hi all.. I have a DataGrid with checkboxes. In the header I have a "check all" checkbox. I'm wondering if there is an easy way to check all checkboxes using that checkbox. I could do it using...
3
by: Robert Kilroy | last post by:
Greetings, I've been working on this for a few hours now. It seems to be a pretty simple task but I keep running into " has no properties". I have a select box defined as follows: <SELECT...
4
by: Pandu | last post by:
Hello: Our HR dept wants to allow users to download various HR forms from our comp intranet. But since there are over 20 forms, I need to allow users to select the files they want and then...
1
by: vincehallam | last post by:
Hi newby here sorry if this sounds bread and butter stuff. Using MS Access 2003 On a Form I want two Combo boxes which are getting their data from a table. The Combo boxes are A "Price 1" & B...
1
by: eclipse93081 | last post by:
I need a way to sum check boxes in Access. On the database interface I have 3 boxes you can check; "Scheduled/Went On", "Scheduled/Did Not Go On", and "Not Scheduled". I have the boxes set up as...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.