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_AfterUpd ate()
If Check5 = True Then
Aust_Ent_Sum = True
Aust_Ent_Sum.En abled = False
Else
Aust_Ent_Sum = False
Aust_Ent_Sum.En abled = True
End If
End Sub
"Aust_Ent_S um" is the name of the checkboxes i want to check. Any help in checking/unchecking ALL the checkboxes would be appreciated!
Thanks, Siwei
4 11694
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
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?
Try looking at the following post:
http://www.thescripts. com/forum/showthread.php? p=2449139#post2 449139
I believe you are having the exact same problem that someone else helped me solved.
Mark
Sign in to post your reply or Sign up for a free account.
Similar topics |
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
|
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 work.
<script language="JavaScript">
function selectAllCheckBox()
{ //alert(document.addzone.c1.value);
document.addzone.c1.value = "on";
}
</script>
|
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
where field=true, otherwise just let everything pass through.
For checkboxes I know I can used iif(xxx,true,(true or false)) but I also
wish to use strings, where iif(xxx,yyy,'*') doesn't work - as the search on
|
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) how to use the selection "All" as criteria for a field in a
query, which is used to generate data for a report.
|
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 JavaScript code, but the main problem I have
is that checkboxes ids aren't kept when the datagrid is rendered, for
example, if the checkboxes have the name chkNumid, when the datagrid is
rendered, the checkboxes become dgDataGrid_ctl02_chkNumId,
| |
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 MULTIPLE NAME="myOptions" SIZE=5>
<OPTION VALUE="Blue">Blue</OPTION>
<OPTION VALUE="Red">Red</OPTION>
|
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 download the selected
files using a single click to "Download All" button. How can I do
this? Is there some canned script that would do this? Is this even
possible with a client side script?
Thanks.
|
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 "If Bank Holiday Price Two". Is it possible to have "Price 1" visible as default but then if I tick a check box to have "If Bank Holiday Price Two" pop up and the values in B be used when clicked instead of "A".
Hope this makes sense ?
Regards...
|
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 "True/False" in design view so on my report it will assign either a 1 if true, or a 0 if false. I need a way to sum each category by itself so I can keep track of how many times each box is checked every month so that when I print out a report it...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |