Modules & VBA :: Unique Option In Combo Box
Sep 4, 2013
I have table with a list description and prices. However, some of the descriptions are the same but with differernt prices. If I create a combo box just want user to select description, how can I make use of this table in the combo box but only showing each descrpiton as a unique option?
View Replies
ADVERTISEMENT
Feb 24, 2005
I have a table called students and one attribute is called Ethniticity and have a text datatype.......I'm setting up a form to add a new student.... for the Ethniticity part I set up a set of combo boxes ---- African American, White, Hispanic, Native American, Asian, Multicultural, Other: ---- beside the "other" option there's a text field where the user can type in their own answer. I want the text for the option selected to be placed in on the student table in the ethniticity field and if the "other" selection is selected the text in the textfield will be placed on the students table........................how could i get this to work???? any help would be appreciated
View 1 Replies
View Related
Mar 15, 2006
Hello,
I have a combo which I have set to activate successive combos when a selection is made in it.
Unfortunately if you delet what is in it i.e. to make it empty it does not deactivate the other combos. I presume this is a peculiarity with combos as once you have clicked in it it is active?
is there anyway of getting Acess to recognise you don't want to use a particular combo by removing the data manually or by selecting a 'none' option in the combo?
Does this make any sense?
View 1 Replies
View Related
Nov 23, 2006
Is it possible to create a combo box to list all record ID, when selected that record appears on the form?Ifso how would i go about this?
Thanks in advance?
Andrew
View 1 Replies
View Related
Feb 20, 2006
Currently I'm working on a quote form in an inventory database. The invoice form consists of a main form with the customers information and a subform which is continous and is for selecting parts. Each part has multiple serial numbers which need to be quoted individually. Basically what I want to do is when you select a specific serial number on one record, I want it removed from the combo box on all other records in the continuous form. (either previous or new) How would I go about doing this?
View 1 Replies
View Related
Jul 22, 2014
I've used this guide [URL] .... to only show unique values in a combo box. I can't get it to work, it just shows a load of blank values. If I run the expression builder part from the background, it works but it doesn't work in the combo box. Not sure what I can post to give more details?
View 13 Replies
View Related
Dec 3, 2013
I have built a database that is fed from tables provided from outside computer systems, so the architecture isn't exactly how I would design it.
I am trying to use a combo box on a form to quickly jump to a specific department. I have about 130 personnel that are assigned to 10 different departments. I have to use a subform to update the position info vs. the personal info.
The combo box works, but I can't get it to display each department once. It shows the department 130 times for each employee instead of 10 unique departments.
View 11 Replies
View Related
Mar 31, 2006
Does anybody know how to add an option that says 'none' or 'no selection' or something to a list of combo options.
I use a query by form to produce a report. But I may close that report and it goes back to the form. If I want to re-run a new query I have to close the form and re-opne it so the combos are empty.
Is there anyway to have a 'none' option to empty the combo box?
View 2 Replies
View Related
May 15, 2006
Hey all,
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.
Thanks
View 4 Replies
View Related
Jun 17, 2006
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
View 3 Replies
View Related
Jun 28, 2006
Morning folks,
Todays problem is as follows!...
Is there away to set the values in a combo box depending on what option button you have selected.
What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another option button it would change the values in the same combo box?
So if I selected optWhite, the values in cboEthnic = British AND Irish AND Other
If I select optMixed, the values in cboEthnic = White and Black Asian AND White and Black Caribbean etc...
Hope this makes sense.
View 1 Replies
View Related
Dec 13, 2004
How do you convert a combo box to a radio option?
I have made a table called level it has only one column and is only two values (udergrad and grad)
I have a form that sets requirements and in there I have the option to choose what level the requirement is on.
Instead of using a combo box for the level (with a select statement SELECT Level.LevelName FROM [Level]; )
I was wonder how I can conver the Level into two radio buttons one for undergrad the other for grad,
and depending on what was selected that value would be stored in the table.
thanks for any help
View 1 Replies
View Related
Oct 9, 2005
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
Any Ideas please help.
View 2 Replies
View Related
Mar 28, 2013
I have tried creating a combo box in a form and as I have gone through the steps, the option to bind each choice that I created in my drop down box for the form is not an option, so how do I make each choice in my drop down box access the report I need?
View 1 Replies
View Related
Oct 18, 2006
I'm trying to disable users from right clicking, from within a combo box and selecting paste. The following code is suppose to work
Private Sub DESCREP_DESCRIPTION_GotFocus()
Application.CommandBars("Form View Control").Controls("Paste").Enabled = False
End Sub
but it doesn't work, any suggestions?
View 2 Replies
View Related
Mar 31, 2014
I have two dropdown boxes on my form, the second is dependent on the first and shows only employess from the company selected in the first dropdown box. I am using an AfterEvent update to filter the employees.
Now when I try and choose an employee other than the first one on the list it automatically goes back to the first person and the info in the subform only shows their information.
View 9 Replies
View Related
Jun 10, 2015
I have 2 Option buttons that I want to use to control a combo box. If I select Option1 then I want it to pull from one table for the drop-down choices. If I select Option2 I want it to pull from a different table. The Option buttons and combo box are all on the same form.
View 5 Replies
View Related
Jul 15, 2005
Hi all, a newbie with novice access skills.
I'm very good with utilizing the access tools however I can only code in vb editor minimally. What I'm looking to do is have the option buttons control two combo boxes. One to search by user name and the other to search by serial #. I've created an option group with two buttons I set the default values in the combo boxes in accordance with the option buttons However, the option buttons aren't doing what they are supposed to do. I've been told I need to tweak the code for the buttons in order to make them control the combo boxes. Does anybody know what I need to do to make this happen? Ultimately the user will be able to click either of the buttons to perform a search through a single combo box.
Thanks to everyone out there for making this possible. Your expert knowledge will help me grow into an expert myself.
Thanks to all in advance! :confused:
View 4 Replies
View Related
Jul 14, 2006
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.
Thanks for any replies in advance...
View 6 Replies
View Related
Aug 2, 2005
Hi I'm a real newbie at this but basically I have a form displaying three lots of contacts Expediting, Quotation & Miscellaneous contacts.After choosing the company name from a list box it displays the Expediting, Quotation & Miscellaneous contacts info - but doing it this way there isnt much space on the screen to show all the Contact names,Telephone fax & email addresses clearly& at a decent size.Apart from the company list box I want to have a list box/combo box with:
Expediting
Quotation
Miscellaneous
and then after choosing Expediting, Quotation or Miscellaneous from the list/combobox i want it to take the relevant data from the Expediting, Quotation, or Miscellaneous contacts sections and only display the information relating to those sections only, therefore allowing me to have bigger text and not so cramped display so everyone can read it ok and get more info on the screen for each contact group.
If anyone could help it would be much appreciated!!!! Thankyou in advance for any help. Be gentle with me I am a newbie,lol.
Thanks again
View 2 Replies
View Related
Jun 20, 2013
I have a form with a combobox whose list items are taken from a table of currencies (called tblCurrencies)
Row Source = SELECT [tblCurrencies].[Ccy] FROM tblCurrencies ORDER BY [Ccy];
Problem is, there may come a time when the currency they want to select is not yet part of the tblCurrencies table, and needs to be added. For simplicity, I'd like to have an additional option in the dropdown (perhaps at the bottom) to specify a new currency.So an additional list item (e.g. 'Add New...') which when selected could prompt a subform where the user could specify the new currency (and any other relevant details specific to that currency) which can be programmatically added to tblCurrencies.how do I get that extra option into the list items for the combobox?...
View 2 Replies
View Related
May 1, 2013
How do I get only one item in a combo box when using the Table/Query option (ie No Duplicates). I want only one of each field with no duplicates.
View 2 Replies
View Related
Dec 11, 2013
I've created a form using the form wizard and all of the fields show up as combo boxes. I would like to change a couple of them to option groups with radio buttons. Is there anyway to do this without deleting the fields and making the option boxes from scratch? The reason I ask is because when I do the option boxes from scratch with the wizard, it alters the way the information shows up in the datasheet (it's a split form).
View 2 Replies
View Related
Dec 18, 2012
I am building a database to store student assessment information. I have a table with student information, a table with teacher information, and tables which will store the student's scores on a certain assessments.
Q1: I have a field in the assessment table for Teacher ID and Student ID which are linked to their respective tables. What I want to do is create a form for inputting the assessment data but the fields for teacher ID and Student ID to auto-complete or be combo boxes, I don't care which. That is, when a person is entering a student's scores, and go to enter their ID, they won't have to type the whole number out and hope they dont make any mistakes, they will essentially have a list of choices to choose from. Or as they type, the corresponding number will filter down. I already have refferential integrity on so that they can't enter an invalid ID in either field but I want them to have the choice.
Q2: In an assessments table, there is a 1-1 correspondence btw student ID's because only one student can have one score on a particular assessment. However, clearly one teacher can be tagged to several student's assessment scores. Any better way to tag the teacher to multiple student's scores without having fields in the assessment table for teacher ID which is repeated multiple times.
View 3 Replies
View Related
Oct 2, 2013
I have a Combo Box bound which gets its values from a table (T_Users).
The Combo Box displays the Users 'Initials' [Column 1], but the Bound Column [Column 2] is that of the Users 'ID' (which is used when a record is edited or a new record added).
What I want to be able to do is when the user clicks the Combo Box, and the drop down list 'drops down' the options, I want them to not only see the 'Initials' but also selected other columns - BUT - when the option is selected I just want the 'Initials' to be displayed in the Combo Box.
Code:
So, Normal > | ABC |
Dropped Down > | ABC |
--------------------------------------------
| ABC (Annabel Carcus, Big Company Ltd.) |
| JB (Joe Bloggs, Medium Company Ltd.) |
| FS (Fred Smith, Little Company Ltd.) |
Select JB, and > | JB |
View 6 Replies
View Related
Mar 30, 2015
I'm looking to have either a combo box,, or 2 options buttons (whichever is easiest) that set a date field based on what is selected in the combo box/ option buttons.
The variables are 'Payment in 30 days" " Payment upfront"
if "payment in 30 days" is selected the date field on the form will enter the date as + 30 days from todays date
if "payment upfront" is selected the field on the form will enter todays date.
This date field must be blank unless an option is selected, as this information is only entered in a later stage of the form.
I've tried a few different ways to enter this but i can't quite get it to work as i want.
View 3 Replies
View Related