473,799 Members | 3,121 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to ensure that on a continous form of 12 row only 1 tick box is checked??

Hi there,

I have listed 12 month on a continous form, where as I flag the current

month with a tick box.
To ensure at only 1 tick box is check not more or all I would want to
validate and ensure that at all times one tock box is checked!

any ideas??

so far I used dsum(xx,xx) in reference with the before update event of
the check box. This works as a once of. If I click it again it allows
me to select 2 check boxes. ???

Regards
Robert K

Nov 13 '05 #1
3 1881
make sure all your check boxes are part of the same Option Group and
you should only be able to select a single value for them. you can set
that value either through code or simply by selecting them and you'll
only be able to select one value for the overall frame in that case.
you can also set them by using the Default Value.

Nov 13 '05 #2
Jamey,

I find what you say confusing.
How can you set a frame on a contious form, whereas only one check box
represents the value of eg: column A??

It just doesn't make sence!
Thanks for your comments.

Regards

Robert K

Jamey wrote:
make sure all your check boxes are part of the same Option Group and
you should only be able to select a single value for them. you can set that value either through code or simply by selecting them and you'll
only be able to select one value for the overall frame in that case.
you can also set them by using the Default Value.


Nov 13 '05 #3
"Robert K" <Re*********@am p.com.au> wrote in
news:11******** **************@ f14g2000cwb.goo glegroups.com:
Jamey,

I find what you say confusing.
How can you set a frame on a contious form, whereas only one
check box represents the value of eg: column A??

It just doesn't make sence!
Thanks for your comments.

Regards

Robert K

Jamey wrote:
make sure all your check boxes are part of the same Option
Group and you should only be able to select a single value
for them. you can

set
that value either through code or simply by selecting them
and you'll only be able to select one value for the overall
frame in that case. you can also set them by using the
Default Value.

First of all, I canot imagine a valid databsae design which would
require your 12 child records. One record with a number from 1 to
12 would be adequate for any design.
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2331
by: adolph | last post by:
I would like to add a check box to the detail area of a continous form. So that I can check on specific records, then after I've marked all the records I watn to delte, click a button to loop thru these check boxes, if checked get the field with the underlying table record ID and run a query to delete it. I've built a continous form to show all the records. I now want to add a check box beside each record, so that I can check specific...
2
322
by: Rene_Muench | last post by:
Hi there, I have listed 12 month on a continous form, where as I flag the current month with a tick box. To ensure at only 1 tick box is check not more or all I would want to validate and ensure that at all times one tock box is checked! any ideas??
0
1729
by: gavo | last post by:
Hi. using A2K; i have a form containing a continous subform. The question is, how can i call a calculation for one of the fields in the continous subform from the main form. At the moment i have a button on the main form that will call a public code containing the calculation i need, the problem i have is that it will only perform the calculation on the first record on the continous subform and i need it for all the records
0
1425
by: ReidarT | last post by:
I have started to develop in vb.net. Earlier development was in MS-Access. I need a lot of continous forms to present data. The customer add and edits data in the continous form. Is use of datagrid the way I should do it in vb.net? I need up to 1000 records in a continous form (mostly 3-400) regards reidarT
0
1520
by: Toby Inkster | last post by:
Like me, you are probably confronted with many requests for surveys, questionnaires, feedback forms, registration forms and so forth: forms where the processing requirements are very simple (store in a database or e-mail to a particular address). Despite the simple requirements, there is often quite a lot of work involved: crafting a database to store results, writing a function to store the data to the database, one to verify submitted...
2
1799
by: DoomedLung | last post by:
Hey, I'm currently developing an online work brief, where the user has to enter details regarding the project into a form. I've come to a section in the form where the user has the option of selecting between two checkboxes and an input element. I have to ensure that at least one of the checkboxes have been checked or that the input element is not empty. I've come up with this function: function validateMedia(){
3
1480
abouddan
by: abouddan | last post by:
Hi all I am trying to create a form 'Form1' that updates my database. Fist this form is based on a query that returns all the records in table 'employe'. query1="Select id, name, salary from emoloyee" Form1 is Continous and it shows me all the records and within every record I have a check box. In the form footer I have a button that increase salary of all the selected rows. The problem is that when I check one check box, all check boxes...
1
1551
by: questionit | last post by:
Hi I am showing records on a continous form. I have also created a check box to appear with each record. The problem is that when ever i tick the check box, the check-boxes with other records are also ticked. How would i stop other check-boxes to change ?
2
1411
by: questionit | last post by:
Hi I know how to implement Continous form. In the method i have tried, the source for data on the continous form comes from table using SQL query Now, i want to try something different and i need your help. With the same continous form, i want the source for the data to be a simple piece of code that returns names of files in the folder. I have completed working code for getting file names in the folder:
5
2132
by: AccessHunter | last post by:
Hi, I have a continous form that displays Name and Address of Suppliers. In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table, "Primary Suppliers". The combobox is for 'Active Address' with values 'Yes' and 'No'.Control source of the form is, Select * from PrimarySuppliers where ="Yes". I want the form to display only the Suppliers who has 'Active address' = "Yes".If user selects...
0
9538
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,...
0
10470
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10023
tracyyun
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...
0
9067
agi2029
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...
1
7561
isladogs
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...
0
6803
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();...
0
5583
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3751
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2935
bsmnconsultancy
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...

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.