Check boxes in continuous subform - Microsoft Access / VBA

Karl Roes

Thanks Turtle, but ... what for ? Could you please explain a little
more.
I am wanting to know the status of all check boxes in a continuous
form ie. all are 'ticked'.

MacDermott wrote -

You'll need an extra field in the table underlying the subform.

"Karl Roes" <ka******@hotma il.com> wrote in message
news:7c******** *************** ***@posting.goo gle.com...

Hi all,

Is it possible to check the status of the check box on every record in
a continuous subform ( one check box per record ).

I am wanting to check the " Approved " status of all subform records
in the Before_Update event of a main form combo.
Thanks and regards

Karl.

Nov 13 '05 #1

Subscribe Reply

3046

MacDermott

If you put a checkbox on the form without binding it to a field in the
recordset (underlying table), it will behave the same for each record -
tick one, they're all ticked; untick one, they're all unticked.
In order to keep the information for each record separate, you need to add a
Yes/No field to the underlying table, and bind your checkbox to it.

If you'd like to post a few more details on what you want to do with the
information you garner, perhaps I can help with the coding...

"Karl Roes" <ka******@hotma il.com> wrote in message
news:7c******** *************** ***@posting.goo gle.com...

Thanks Turtle, but ... what for ? Could you please explain a little
more.
I am wanting to know the status of all check boxes in a continuous
form ie. all are 'ticked'.

MacDermott wrote -

You'll need an extra field in the table underlying the subform.

"Karl Roes" <ka******@hotma il.com> wrote in message
news:7c******** *************** ***@posting.goo gle.com...
Hi all,

Is it possible to check the status of the check box on every record in
a continuous subform ( one check box per record ).

I am wanting to check the " Approved " status of all subform records
in the Before_Update event of a main form combo.
Thanks and regards

Karl.

Nov 13 '05 #2

Perhaps do a quick lookup such as

if isnull(DLookup( "Approved","Tab leName","Approv ed=0 AND .....)) then
'either all records are checked or there are no record in the
subform
end if

Nov 13 '05 #3

Similar topics

5407

Invisible Check Boxes

by: jdph40 | last post by:

Is there any way to do this on a form in Access 97? If the value of a combo box is .5, I want two check boxes to be visible (labels are a.m and p.m.). If the value of the combo box is 1, I want the two check boxes to be invisible. Thanks, JD

Microsoft Access / VBA

395

Check boxes in continuous subform

by: Karl Roes | last post by:

I'm still having trouble posting follow-ups. :-( "Unable to retrieve message 7cc66112.0501041919.3a6628b4@posting.google.com" Now Turtle wrote "You'll need an extra field in the table underlying the subform." ....................hmmmmmmmmm................... I put in a field in the underlying table with a default value of 1. I created a text box which adds up the values in the new field

Microsoft Access / VBA

3165

Using Combobx In Continuous Form

by: Kathy | last post by:

What is the standard technique for handling the fields in the following scenario on a continuous form? Multiple Divisions. Each Division has multiple Buildings. Each Building has a Supervisor. Tables: (abbreviated) TblDivision DivisionID

Microsoft Access / VBA

2915

Continuous subform -LOOP

by: gavo | last post by:

Hello everyone! Using A2K i have a form(a) with a subform(b) and within the subform there is a continuous subform(c). in the subform (b) there is a command button used to call a public function

Microsoft Access / VBA

15377

Displaying (scrolling to) a specific record in a continuous form with VBA

by: Typehigh | last post by:

I am a good programmer, but this one stumps me! I have a form with a continuous subform. The continuous subform contains records of data and may reach a depth of 1000's of entities. I have created a search button on my form and it does its job quite well. It presents the user with an inputbox, prompting for the string to search. Then the code returns with a record number of the record which contains the string. Here's the problem. I...

Microsoft Access / VBA

8783

Select all check boxes in subform

by: jsurkin | last post by:

I have a form that lists a single work request, with an attached continuous subform that lists specific items that are part of the request. Each item in the subform has a check box to indicate when the work is completed, along with a date text box to indicate when the work was completed. There is also a check box and corresponding date field in the main form to indicate when the entire request is completed. I'm trying to create an event...

Microsoft Access / VBA

2279

Copy Command using Cascading Combo Boxes in a Subform

by: SPOILED36 | last post by:

I am building a database to track attendance. I have one main form with multiple subforms. Within one of the subforms name sfrDailyAttendance, I also have cascading combo boxes (cboCategory and cboException) to filter difference absences (ie.Regular, Overtime, etc). cboCategory is filtered as follows: !!... Because I have the subform set up as a continuous form, I needed to add a text box (txtException) on top of one of the combo boxes...

Microsoft Access / VBA

1764

Controlling Visibility on a Continuous Subform

by: Chipperzs | last post by:

All, First time user, I tried searching for related posts but none pertaining to my specific problem. I have a form with a "Continuous" subform on it. The Continuous subform has a combo box with a list of selections. What I want is to have cretin entry fields on the continuous subform show up depending on the selection of the combo box. I can get this to work with the code below but it updates all the records of the continuous subform...

Microsoft Access / VBA

11641

Continuous forms with subforms

by: Steffen Beck | last post by:

Hi NG I need some help with a problem on my forms. If I have 2 related tables, for instance companies and employees, and want to display all companies on a continuous form with their employees on a sub form as another continuous form, as shown below

Microsoft Access / VBA

5153

Unbound Text Boxes in Subform

by: jwessner | last post by:

I have a form (Form1) which contains basic Project data and a subform listing the personnel assigned to the Project as a continuous form. Selecting a person on that project and clicking on a command button will open a new form (Form2). Form2 has two subforms. Both are embedded in the main form. (Subform2 is NOT embedded in subform1.) Subform1 displays records as a continuous form based on the Primary ID of the main form and lists the...

Microsoft Access / VBA

7965

What is ONU?

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...

General

7885

Changing the language in Windows 10

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,...

Windows Server

8258

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

5847

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

3881

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3923

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2399

transfer the data from one system to another through ip address

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

C# / C Sharp

1493

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1231

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General