Hello
It is me again. I have another issue that I can not solve by myself or with google and would be happy if you could help me.
My database consists a form with details of persons. There is a subform with a combobox that consists "languages" and there is a checkbox on the mainform (yes/no) with the name "Translator ".
I would like that the checkbox "Translator " is automatically activated if a language from the combobox in the subform is chosen and vice versa. What I would like in addition, is that the checkbox can not be activated or deactivated manually by the enduser of the form.
Can anybody tell me how I can do that?
Greetings and thanks!!
Mike
16 1506
With the number of answers I have provided, I might just as well have written your DB
Firstly if you have a Combo box for languages, you restrict the person to only 1 language,
Secondly, from your description of what you want, if a language is selected, by definition the person is a translator, so there is no point in the translator checkbox.
Thirdly, with only one language allowed, this should be a Combo box in your main form, so what is in your subform?
Do you need a rethink?
Phil
Dear Phil
Thanks a lot, and yes, you have provided really a lot of answers for which I am very thankful!! I hope I won't have many more questions...
I have a subform in which is a combobox with languages. For each person, more than one language can be chosen. The languages are in an individual "page" in a subform. On the main page of the form, I have the checkbox with the languages so that you see just in a second whether a person can be asked for translation or not. Therefore, the checkbox.
Greetings
Mike
OK Mike, that's clear, but are you saying that if a person has any language then they can translate ALL the languages listed on the subform, or are you saying that they are good at some languages which they can translate, and have limited ability in other languages? In which case the checkbox should be on the subform.
If it is the former, I still can't see what the check box achieves as an entry on a subform is far easier to see than a tick in a chec box.
Phil
Dear Phil
Thanks for your answer. My question is about the former situation, meaning that when a language is in the combo, then the person can do the translation for that language and is a translator.
The checkbox is to make it much faster visible for the user of the database. To understand that, I send you a short attachment.
Mike
OK. First set the Translator Check Box to Locked = Yes. That stops manual changing.
Then on current of the main form you need something like -
ChkTranslater = [LanguageSubForm].[Form].RecordsetClone.RecordCount > 0
-
So see if there are any language records and set the Translator box accordingly.
You will need a similar routine on the After Update of the language subform
Phil
Dear Phil
I could not really succeed, sorry. I have a main form in which the checkbox is situated, a subform and a combobox in the subform.
If you feel tired of helping me, I am really sorry. I will try not to poste more questions after that problem...
Thanks!
Mike
More than happy to help. Mike.
So what's the name of your subform?
Is there any information on it other than the language?
What code did you try?
Phil
Dear Phil
Thank you!
The name of my SubForm is "T_Sprache-Unterformular". There is no other information on it than just the languages in the combobox "cmbSprache " out of the table "T_Sprache" .
The mainform where the checkbox "Checkbox Übersetzer" is, is called "MainForm".
I tried the code you sent me on the Combo and additionally on the main form. It did not work, therefore I tried to put the Code on the Subform instead of the main form. I did the same with codes like the following, without success:
If Me.cmbSprache = 1 Then
Me.Checkbox_Übe rsetzer = True
Else
Me.Checkbox_Übe rsetzer = False
End If
I tried different codes like that which I found in the internet...
Mike
I'll try to get my head round the German -
Private Sub Form_Current()
-
-
Übersetzer = T_Sprache-Unterformular.Form.RecordsetClone.RecordCount > 0
-
-
End Sub
-
In even better way if this is so important would be to have a great big label called LblÜbersetzer with the Caption Übersetzer and change the code to -
Private Sub Form_Current()
-
-
LblÜbersetzer.Visible = T_Sprache-Unterformular.Form.RecordsetClone.RecordCount > 0
-
-
End Sub
-
Phil
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jason McDonald |
last post by:
I have a PDF form that has a combo box "no_wireless_mics" with the
values "1" "2" and " " where " " is the default. I need a JavaScript
that will cause the check box "wireless_mics" to be checked
(value=true) when the combo box value is "1" or "2"
I ama JavaScript newbie and I'm having quite a time figuring this out.
Thank you for your time and attention.
|
by: wolf_y |
last post by:
My question is simply: under what conditions will empty tags of the
form <MOM></MOM> pass schema validation? Of course, the mirror
question is: under what conditions will empty tags fail validation?
The former seems to be an easier question to answer.
XML files will arrive from around the world and must be schema
validated before further processing and loading into a database, so I'm
trying to foresee the various layouts that might be...
|
by: arun.hallan |
last post by:
Hi,
I have two columns in a datagrid that are filled with checkboxes.
I want one checkbox in a row to be checked when the corresponding
checkbox is checked.
I've added an OnCheckedChanged event to the checkbox and implemented
the method with the following code:
|
by: ayeung |
last post by:
Hi,
I have written a GUI application that I want to automatically run on a Linux system (Fedora Core 6) upon powerup. I've created a script which runs correctly and have added a run script using chkconfig for the appropriate run levels. However, when I reboot, my application is not automatically loaded. Any help will be much appreciated.
Cheers,
Aaron
|
by: tvnaidu |
last post by:
How can I disable checkbox when it is selected Kernel?.
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr><td align="right" width="40%" valign="top" class="text1">Facility:</td>
<td width="60%" valign="top" class="text1">
<select name="logConfig.facility" size="1" class="txtbox" id="selFacility">
<option $| web.dropdownSelected(configRow == "Kernel") |$ value="Kernel">Kernel</option>
<option $|...
| |
by: yappy77 |
last post by:
I am trying to change the label color of a checkbox on a subform if it is checked.
The code I have so far is:
Private Sub Emergency_Contact_Click()
If Me.Emergency Contact = True Then
Me.Label23.BackColor = vbYellow
Me.Label23.BackStyle = 1
Else
Me.Label23.ForeColor = RGB(0, 0, 0)
|
by: debre |
last post by:
hi,
i m new to asp.net n i m tryin to work wit datagrid.
my prob is tat...when i click the header checkbox all d checkbox in the first page is selected n when i go to d sec page in datagrid..the checkbox are not selected in the sec page..but i want the sec page checkbox to be selected as well..i used onitemdatabound..but looks like when i click the sec page..by default d header checkbox is unchecked..pls help me wit tis...
thanks
|
by: TensE |
last post by:
How do I make specific checkboxes be checked when I select an entry in a combobox? Like if I select entry 1 checkbox 1 and 3 will be checked if entry 2 then 3 and 4 be checked? So far I'm encountering a problem that when I change the combobox entry the checboxes that were checked stay checked.
Here's the code from the sub it's related to if that helps
Private Sub getProgramsNamount(strProgID As String, dblDuration As Double)
Dim...
|
by: tamcq |
last post by:
When my database is opened, it starts with the form Patients.Page 2 of the the Patients form contains a subform called New Record. This New Record subform is where you put entries about the medications taken by a particular patient. The medications are categorized into two: current and past, depending on the specific checkbox that is checked.
What I want to happen is, when the fields in the New Record subform is filled, two other subforms...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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: 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...
|
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: 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...
| |