Resident Experts,
I am currently working on a database to track the employee training for my company. Access is the only tool that is available and I'm definitely a novice. I'm working on a form to enter training event information and I have an option group and combo box problem. How can I disable a combo box until a certain option is selected?
I had made a database earlier for this customer but I worked with no process and so therefore I did the best I could. However, the customer has brought something to my attention that needs correcting.
The problem is that although the current database does record training events it doesn't produce reports which show what the employee hasn't done.
Because there are training events that pertain to everyone and then there are events that only pertain to individual employees based off of a 'job code' (which identifies their specialty) I've struggled to establish a link between employees and these two different types of training.
In an effort to correct this problem, I've added a 'project mandatory code' to the 'EmployeeInfo' table which holds all employee information along with their job code. Each time a new employee is entered into the table, a default value is entered into the project mandatory row.
I have seperate tables called 'JobCodes', 'ProjectMandatoryCode', and 'TrainingEventFrequency' which are connected to my 'TrainingEventInfo' table. The TrainingEventInfo table holds the information for all known events.
When a new training event is recorded, an entry is made into my 'CompletedTrainingRecord' table. This table records the event name, date completed, and the employee clock number.
Although I think my logic is sound, I may have missed something and made no progress at all.
Having said all that, the form I am working on to enter training events into the TrainingEventInfo table is where my original question came in. The option group I have has two choices: Project Mandatory Training and Position Related Training. If the user selects Project Mandatory Training then I want the combo box to be unavailable and based off the value it will automatically input a default value for the ProjectMandatoryCode. If the user selects Position Related Training from the option group I want the combo box to become active. My combo box is run from a query which pulls the job codes from the appropriate table and this value can then be written to the record in the TrainingEventInfo table.
Because both the ProjectMandatoryCode and the JobCode are in the EmployeeInfo table I'm hopeful that I can write a query which will pull all events, related to the individual, whether they have been completed or not.
Thank you in advance for any assistance you may be able to provide. I've attached a document which may be helpful. Respectfully,
Dale Gagnon
I stumbled upon the Option Group function just yesterday and, happy as a clam, I created a group with 2 options in radio button style. I assigned the values to a field called Registration_Type as the 2 options are "Confirmed Registrants" and "Prospective Attendees".
[Great. That part works well. When I look at the table, a 1 or a 2 is in that field so it's great to know how to control accidental ticking of radio buttons (previous 450 records or so didn't have this option group functionality so one might easily tick one of the buttons. So one part of controlling option group I know I can handle via the table itself for now.]
The challenge is how to ensure the user always ticks one or the other ... I went back to the main table and tested the 'required entry' option for the Registration_Type field but forcing an action like this is not ideal in my mind. The usual error message vagueness for the average user is no good and I don't want to limit the user so much.
Is there a way to simply have a popup come up warning that neither radio button was ticked? Perhaps something linked to the form - i.e., maybe "after update"?? I only learned about attaching code to before and after update on controls a couple of days ago, so not sure if this would be best approach.
Just something to let the user know that nothing has been ticked in the option group as that controls in which of 2 reports the data will show up in so any record not ticked might mean a registrant being left out, which would be rather disastrous <g>.
I am trying to link a option group to a combo box. The combo box has a list of employee names. The option group has two options Active and Inactive. All I want the user to be able to do is check the current status of an employee (as active or inactive) and to be able to change their status. I am having some troubles linking the two together.
I have a male or female option gorup. I know when it is an option group one must be check is there any way to uncheck these boxs so nothing will be check if a user accidently checks one of these.
Also in a report i have male/female but on the report it show 1/2 1=M 2=F is there any way that on the report it will show as an X instead of 1/2
2. Combo box. on a form I have a combo box that looks up the managers first name last name.
The problem i'm having is when i select the combo box on the form is does show first name last name however when i select the name in the combo box it only show first name in the field
Hey all, I am wondering if there is a way to do this:
Create an Option Group from a list (the Option Group would be most popular responses), and then, using the same control list in a table, have a combo box for the other possible entries?
Whatever is selected, it would be stored to one table to prevent reduncy... This would be strictly to expidite data entry.
I am using an Access database for a foreign language dictionary project.
One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA.
This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad.
The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA.
When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.)
Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too!
Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event. Me.FilterOn = False Me.Filter = "wordtype = 'A'" ‘(or N, etc) Me.FilterOn = True
And this for the Lost Focus event Me.FilterOn = False
I have a combo box that searches for surnames in my database. if there are two surnames the same, it brings up the first one. if this is not what i want then how can I ask it to search again instead of just pulling down the list and searching manually?
At present I have a form which is used to select a date range then using one of three buttons I can select one of three reports. I want to use an Option Group with three options to replace the three buttons. I have fiddled around using three separate Option Buttons and they work ok but in my opinion they are not the way to go. I need some assistance with the code as the Option Group is slightly different to the Option Buttons.
I have a very simple option group, status 1, 2 , 3 or 4. When the status of the group is changed i have the following code used to label txtStatusChangeAudit which lables who changed it based on the log in name. I have this code for each of the four options. The code works great but when i leave the form and come back to it the txtStatusChangeAudit that holds the code is now blank. When i click an option it again shows the information i want.
How do i get the form to save this information so when i leave the form and come back to it the last person to change the status will still be present?
Private Sub OpenOptionButton_GotFocus() Me.StatusChangeAudit = "Status Open By; " & User.UserName & Space(1) & (Now) End Sub
This should be an easy one.... I had an existing form. Needed a second form. But the two were so close I just added and option group to make certian fields visible when that option was picked. Now.... The problem is sorting or doing a query by the value of the option group. What I am thinking is I need to store the value of the option to a field. ie My option group is named "PickWO" the value is "1" or "2", so I added a field to my WO table... so how do I store the value of "1" or "2" to the new field? Hope this makes sense!
I have created an option group. There is a question and the response is yes, no or N/A. If the answer is no or N/A then I want to skip to the next question. If the answer is yes then I want to ask a follow up question. How would I make it so that when the answer is no or na and the user hits tab it would skip right over the follow up portion and move on to the next question?
I have a option group with several buttons. Is it possible to apply a msgbox to one of the buttons where it will ask the user "Are you sure you want to generate report to excel". I would like the user click ok to continue or cancel. I am not sure how to get this message box prior to the code running when the option button is pressed. Thanks you for your time.
Will someone look at my option group in my form (frmcustomer) and help me figure out why the option group selections for existing records nulls out (visually you cannot see which button had been previously selected).
The option group is working fine in that it is adding the appropriate selection to the record, but when you open the form up in edit mode the selection has been grayed out.
I have an Option Group with 3 choices...1,2 and 3. The default value is 2 as setup in the table default value setting. I have a subform that has a check box and when checked I want the Option Group value to be "1" otherwise I want the default value of "2" or "3" to remain in the table. I can get all this to work through a Afterupdate code in the subform check box except the part where I want the value left at what ever was in the option group part. Here is my code...
Private Sub Paperwork_Returned_AfterUpdate() If Me.Paperwork_Returned = "yes" Then Me.Parent.paperworkstatus = "1" Else Me.Parent.paperworkstatus = False End If End Subvalue
I think the problem is in the "Else" part. The if trus seems to work but if false it will not leave the previouse value in the field.
This last little thing is the last thing I need to finish up. This board has taught me so much...most of all it has taught me that when somebody ask me if I am an advanced access user, I will have to say is anyone? This program is so powerful and I can take a lifetime to master, or so it seems.
I have an option group set up on my form that represents four different sheets. I want to be able to select one and have a certin function occur (docmd.openquery) according to which button is selected. Any ideas? :confused:
I have an option group, with two options buttons. I need to to be a required field. (I cant) make this required at the table level, as there are already 56K records).
I've tried on the before update on the form, making the frame tag = required. For some reason this is not working. Any idea's
Dim blnContinue As Boolean Dim ctl As Control blnContinue = True For Each ctl In Me.Controls If ctl.Tag = "Required" Then If IsNull(ctl) Then MsgBox "Required Information Missing", vbCritical + vbOKOnly + vbDefaultButton1, "You must fill in the field indicated with red" Cancel = True ctl.SetFocus Exit For End If End If Next ctl Set ctl = Nothing End Sub
I want to use an option group with a seperate check box for yes and no for a series of yes/no fields. I find that when I do this, once a record is started all have these items have "no" checked. I tried defaulting the value to null and other such things, but to no avail.
I'm not sure if this is possible. I have a form (link to a table) with option boxes that when I click on one of the option boxes sets a value to a field in the table. The problem is that when I check a different option box I have to manually uncheck the other option box that was previously checked. Is there a way to have this done automatically? Meaning that if I check box 1 and then box 2, when I check box 2, then box 1 has to get Unchecked.
I also tried using a group option with different option boxes and that seems to work fine as far keeping only one option box checked, but don't know how to make the checked box to store its value to a table. Please help! :confused: Thanks!
I thought this would be easily found by searching the forum! But I had no luck. Having trouble with an Option Group. I have an option group with 2 options, YES and NO. Value of Yes set to -1 and value of No set to 0. The field this is bound and is set to Yes/No. The problem is.... No matter what I try it keeps assigning a value to this field in my form! The option group is the last item on the form. Date being the first..... After you enter a date, and an auto number is created, it gives the option group a value of YES or "-1" There is nothing in the default value of the radio button, the frame, or the field to which it is bound. Why is this assigning a value and how can I stop it???? This group needs to remain blank to force the user to THINK before it has a value. I have managed to get around this by changing the bound field to "Number" instead of a "Yes/No" .... But I am concerned with future queries and filtering. So is this the only way around this problem? Setting the field to "Number"?? And where is it pulling the value of the option group from when I have everything set to null??
Talk about frustrating and I am sure the answer will be easy for some.
I have a Main form with search criteria and a subform with the data. See the attached image for the layout. The data comes from a query.
I have a yes/no field called "CompletedP" that I want to use to search on. This field is to filter in/out completed jobs. The Frame is called the generic name "Frame60". I am using an option group with the choice of yes or no plus other search criteria using combo boxes. The combo box filtering is fine but the option box does not appear to form any part of the search. To search I select any of the boxes and select "Search".
I post the code here.
Any assistance would be very much appreciated.
Private Sub cmdSearch_Click() On Error Resume Next Dim strFilterSQL As String Dim sSql As String Dim sCriteria As String sCriteria = "WHERE 1=1 "
'This code is for a specific search where you will need to enter the exact string 'The source for this code can either be from a table or query If Me![Location] <> "" Then sCriteria = sCriteria & " AND qrySearchCriteriaSub6.Location = """ & Location & """" End If
If Me![Code] <> "" Then sCriteria = sCriteria & " AND qrySearchCriteriaSub6.Code like """ & Code & "*""" End If
If Me![ClientCode] <> "" Then sCriteria = sCriteria & " AND qrySearchCriteriaSub6.ClientCode Like """ & ClientCode & "*""" End If
If Me![ProjectCode] <> "" Then sCriteria = sCriteria & " AND qrySearchCriteriaSub6.ProjectCode = """ & ProjectCode & """" End If
If Me![StartDate] <> "" And EndDate <> "" Then sCriteria = sCriteria & " AND qrySearchCriteriaSub6.DateAllocated between #" & Format(StartDate, "dd-mmm-yyyy") & "# and #" & Format(EndDate, "dd-mmm-yyyy") & "#" End If
Select Case Me.Frame60.Value Case 1 strFilterSQL = sSql & " Where [CompletedP] = -1;" Case 2 strFilterSQL = sSql & " Where [CompletedP] = 0;" Case Else strFilterSQL = sSql & ";" End Select
If Nz(DCount("*", "qrySearchCriteriaSub6", Right(sCriteria, Len(sCriteria) - 14)), 0) > 0 Then sSql = "SELECT DISTINCT [JobID],[Location],[Premises Details],[ProjectCode],[Code],[ClientCode],[DateAllocated],[CompletedP],[FileNumber] from qrySearchCriteriaSub6 " & sCriteria Forms![frmSearchCriteriaMain6]![frmSearchCriteriaSub6].Form.RecordSource = sSql Forms![frmSearchCriteriaMain6]![frmSearchCriteriaSub6].Form.Requery Else MsgBox "The search failed find any records" & vbCr & vbCr & _ "that matches your search criteria?", vbOKOnly + vbQuestion, "Search Record" End If
I have created an option group with two buttons (New, Used). The defaultvalue of this option group is being set to nothing being selected(i.e no option is being checked). How do I make sure that the user has to choose either one of these option before he/she is allowed to save the record?
I dont want the default value to be either New or Used. And that is why I purposely set the default value of the option group = 0(optGroup.defaultValue = 0) on Form_Current event. However, I want the user to select either one of buttons(New, Used) before he/she is allowed to save the record.
Hello all, I'm new to the site, hoping someone familiar with both continuous subforms and option groups could give me a hand please?
I have a "dialog window"-type form with a subform in it. The subforms are in continuous mode, and I have a scrolling window in my main form that contains one subform for each record that meets the criteria. On each subform, I have a 3-button option group, each option corresponding to a particular "type" that I want assigned to the value in a linked table. The choice is made by the user, then there is a control button that executes an update query which saves the choice to the table (value is 1, 2 or 3) This works fine when there is one record returned. The problem I am running into is when there are multiple instances of the subform, each for a different record. When you click a choice in the subform for record #1, it updates the value in the option group for all of the open subforms. I need this to work such that a different choice can be made in the option group for each subreport. It seems like the application only knows one option group, rather than optiongroup.subform(record 1), optiongroup.subform(record)2, etc. Any ideas on what I am doing wrong?
The subform is "modal" and continuous, and the option group is unbound. I've attached copies of the forms and the save query. If anybody can offer some insight, I'd greatly appreciate it!
Hi, I need an help on my DB. I have a form with some comboboxes and checkboxes inside an option group, which is a value of a table. The table is named TB_ALLEGATI and the field inside this table is named TIPO_CANALE (this also the option group name).
the checkbox inside the option group are named SMS, MMS and VOICE with value as 1, 2 and 3.
I want to save the value checked by the user and store it in the table TB_ALLEGATI, but the problem is that i'm able to save only 1,2 or 3 and not the value name that are SMS, MMS and VOICE.
Have you a suggestion on how to perform this action? Have you any code example?
I have an unbound form with an option group among several other controls. I also have a "Clear" command button which resets the form and removes any entries in any controls.
How can I reset the value of an option group (with check boxes) so that none of the options are selected? VB does not allow me to assign values to either of the options independently.
