Hide Some Choices In Combo Box?

Oct 26, 2006

I have a combo box populated from a table containing names. Whomever processes the order selects their name from the combo box. Some entry persons have left the company but I cannot delete their names from the table as the orders are stored with their names and I want to maintain that history. Is there a way to hide their names from being displayed in the combo box?

View Replies


ADVERTISEMENT

Limiting To Just Combo Box Choices

Dec 20, 2006

Hello,

I am figuring this must be an easy question. I have combo boxes setup and working great. I just noticed that I can put my own text into the box and not be limited by just the choices in the combo box. If that makes sense.

When I try to lock the boxes then it doesnt allow me to select. I want the combo boxes to be the only selection they can make, and not be able to put their own text in.

Attached a screenshot to help clarify.

Anyone know what option I am missing?

Thanks.

View 2 Replies View Related

List Multiple Choices In Combo Box Once

Feb 13, 2006

I have 2 cbo boxes : Year and Company

A certain year might have multiple entries for the same company. I want to have the company listed once instead of multiple times. How do I do that?

Thanks.

View 2 Replies View Related

Forms :: Combo Box Where List Of Choices Are Narrowed In Real Time As You Type

Sep 29, 2014

I would like to create a combo box (or something similiar if a combo box simply can't do it) where the list of choices in the pulldown shows only the matches of what a user types in. The list of choices are coming from a field in a table. Also I would like the "search" of the user's input to include what is "within" each choice, e.g. if a user type "ber", then valid results should be bertha, october, robert.

View 1 Replies View Related

Forms :: Hide Value From Previous Combo In Next Combo?

Jan 8, 2014

I have a continuous form which has 1 field in which is a combo box which has a list of names. Once you select a name, the next record down is available for selection. This is because my tables PK is a autonumber. How do i filter the records to only show the names which have not been previously entered in my above records.

View 11 Replies View Related

Hide A Combo Box

Aug 24, 2006

hello,
i'm trying to make the combo box hide after i choose one out of combo
box, eg: i have in combo box 1,2,3,4,5,6 and when i choose 4 i want it to hide
i have tried

me.nameofcombobox.Visible = False

but does not work because it has the Focus so i tried

me.nameoftextbox.SetFocus
me.nameofcombobox.Visible= false

but it comes up saying

Run time error '2108':

You must save the field before you execute the GoToControl action,
the GoToControl method, or the SetFocus method.

i don't no what to do can someone help me plz
___________________
David

View 5 Replies View Related

How To Hide The Drop-down Arrow On A Combo Box

Oct 4, 2005

Is there a method you can use to hide the drop-down arrow on a combo box until the combo box is selected?

View 5 Replies View Related

Hide Combo Box In Continuous Form

Jul 12, 2005

Is it possible to hide or show a combo in certain records in a continuous form. i.e if certain certain conditions are met.

At present I have if Check1 = true then Combo1.Visible = true

The trouble is it then displays the combo in all records.

View 2 Replies View Related

Hide Duplicates Values In A Combo Box

Mar 31, 2006

Hi Guys,

I have a problem. I'm trying to import values to a Combo List from a table:

Row Source = SELECT Tasks.Milestones FROM Tasks;

where Task is a table and Milestones a field of that table. In this field (Milestones) there are repeated values, but I'd like to hide those duplicates when I want to chose them from the Combo List. I don't know If it is clear, if not it's because I'm not an Expert of Access :p

Thanks a lot for your attention,

Ciao

View 4 Replies View Related

Forms :: Hide Records That Have 1 In Combo Box

Jun 10, 2013

I have a form with a checkbox and a combo box. When I click the checkbox, I would like it to only show the specified records that are in the combo box. The current code I have is this:

Code:

Private Sub chkHideComplete_AfterUpdate()
On Error Resume Next
If Me.chkHideComplete = True Then
Me.filter = "[ReservationStatus] = 3"
Me.FilterOn = False

[Code] ....

I basically want to hide all records that have "1" in the combo box.

View 2 Replies View Related

Combo Box Value Hide / Show Image

Jul 7, 2011

I'm using access 2007. I'm trying to get a combo box on a form to show or hide an image on a report based on the combo box's value. It seemed simple, but I've tried lots of codes.

View 7 Replies View Related

Combo Box-concatenate Field And Hide Column

Jul 8, 2005

Hi,

I have a combo box which is populated by a table with the fields ID, First Name and Surname. What I want to do is display the first name and surname concatenated and hide the ID column, but populate the field with the ID number.

Is this possible?

View 3 Replies View Related

3 Choices

Oct 24, 2006

Hello,

I have an option group with check boxes on my form that updates a yes/no field in a table, so the choices the user used to have were check "something A" or "something B". Now I have to add a third choice of "nothing" to this.
Is there a way to achieve this with my current setup, or do I need to add a field to my table so that I can have the choices of "something" or "nothing", and then of "something A" or "something B" if the user choses "something"?

Thank you.

View 14 Replies View Related

Lots Of Choices

Dec 15, 2006

In this database, there is a table of users (name, address, phone, etc.) There is also a table of 35 groups. Each user may be in any combination of 1 or all of the groups. The list of groups is not static. At any point in time, I need to be able to show that Bob is in groups 1, 19 and 35. All I can think to do is list all 35 groups in the user table, then make each one a yes or no field. HELP! There’s got to be a better, more efficient way.

View 3 Replies View Related

Multiple Choices On A Query.

Aug 3, 2005

Hi All.
I currently have a query that runs a report. The "Project_Status" field of the query is decided from a combo (cboPS) that is on a form (frmReportManager). The user selects the status from the combo and clicks a button to run a report with that status. That is all OK.

What I would like is 4 tick boxes on the form with the 4 project Status (Ongoing, complete, invoiced and quote). The user would then choose the status types he would like in his report, not just the one type as in the combo.
How do I go about referencing the 4 text boxes for the status types, to the one field in the query (Project_Status).

I have tried using And and Or, but with no luck.

Czn anyone help?

Many Thanks.

Frank.

View 14 Replies View Related

Parameter Query With Possible Choices?

Feb 27, 2006

OK, this has to be simple, I know...But I cannot figure it out.

I have a parameter query that works great, however, it has become complicated to remember all the values the field can have and so sometimes it is difficult to find the info needed. How can I do it so that instead of having an empty box pop up when the query needs my parameters, I get a list of possible choices??

Appreciate the help

View 5 Replies View Related

Best Way To Group Combobox Choices?

May 9, 2005

I have a combobos using a table to look up its values, no problem. The table could have several identical values to place in the combo box ( same city, State multiplt times). I want to group these so that the city, state will only show once in the combobox, hence makiing the list a little shorter. is the best way to do this by creating a new query to group the choices and base my combobox off this new query? or is there another way from within the combobox properties?

Thanks all
Kevin

View 3 Replies View Related

How To Sum Up Various Choices With Unique Values

Jul 29, 2015

I would like to sum up choices made by a user. I'm not sure whether I should create a new table and a couple of fields (not including primary key) with Fruit & Fruit Value.

Where: Apple (Y or N)=4 or 0, Oranges (Y/N)=3/0, Bananas (Y/N)=2/0, etc. As the user chooses the fruit, the value rises.

For example, if the user selected Yes for APPLE and ORANGES the sum is 7-- or if the user selected ORANGES and BANANAS the sum is 5, etc.

Is it possible?

View 1 Replies View Related

General :: Selecting And Storing One Or More Choices

Oct 17, 2014

there could be one or more categories for each person, and in the end there could be a lot of categories, certainly 20+, but the idea is that i could add more when needed.

What's the best way to store these data?Should i create a new table called groups and create a coloumn for each category and write the ID there? Should i add one field to the common table and store all interests there as csv? Many coloumns?

how to collect these data? i don't want text field due to spelling errors and inconsistency (don't want someone to add automobiles and the other cars). Plenty of checkboxes? Multichoice box?

View 5 Replies View Related

Queries :: Ribbon Choices Grayed Out

Nov 13, 2013

Suddenly most of my ribbon functions are greyed out. I noticed it when I was trying to change a simple format. I tried closing outlook and reopening it but nothing is changed. I also tried other databases and still no dice.

View 2 Replies View Related

Lookup Choices Controlling Calculations

Dec 18, 2014

I am running Access 2010 on a Windows 7 platform and attempting to write a simple database for a local charity, and whilst I have basic skills in Access I would not put my level higher that enthusiastic amateur.I have a couple of fields, one called 'Income' which is a simple currency field. The second field is called Frequency and is a combo field where the user can choose from Weekly; Monthly; Quarterly; or Annual.

The database user enters data taken from a survey sheet which captures the income of an individual along with the frequency of the payment.The requirement.I would like to create a calculated field which gives the annual income.

Example:
Income = $5,000 Frequency = Monthly
the calculated field would return (5,000 x 12) = 60,000

Equally
Income = $1,000 Frequency = Weekly would return (1,000 x 52) = 52,000

View 2 Replies View Related

Query Selection - Multiple Choices, One Field

May 19, 2005

I have a database which keeps track of a trucking business. Each truck has a trailer number. I have no problem having a query prompt the user to enter a single trailer number to query on. What can I do when the customer needs to select more than one trailer number to query on?

View 4 Replies View Related

Use Randomize And Rnd In The Same Query To Get Real Random Choices

May 14, 2006

The queries go like this at present :

SELECT TOP 1 [Table].[QuestionText], [Table].[Answer] AS CorrectAnswer
FROM [Table]
GROUP BY [Table].[QuestionText], [Table].[Answer], rnd([IDQuestion])
ORDER BY rnd([IDQuestion]);

SELECT TOP 3 Table.Answer AS Correct, qQuestionTextAndAnswer.QuestionText, qQuestionTextAndAnswer.CorrectAnswer
FROM [Table], qQuestionTextAndAnswer
WHERE (((Table.Answer)<>[qQuestionTextAndAnswer].[CorrectAnswer]))
ORDER BY Rnd([IDQuestion]);

These queries are displayed now in an Access form "frmQuestions" which is applied to "Table" that has three columns id, text , and answer. The result is one question and four suggested answer with one only being correct.The arrangement of the answers is randomized--
but the choice of the question is not realy random....it always starts with the same question as it relies only on rnd.

can I improve the queries and randomize and rnd in the same ...or else can I switch these queries to be used from vb6 code and achieve that result.

any help would be appreciated.

By the way I am really a beginner at this who is seeking help from the experts.

View 14 Replies View Related

Tables :: Check Box Field - Store Only Two Possible Data Choices

Oct 7, 2014

Is it possible to create a field in a table that stores only two possible data choices: a check or null value ?

View 6 Replies View Related

Forms :: Table With Choices For Subform / Related Records?

Jul 11, 2013

I have a table that has the list of "Project design" choices, and I enter in there the choices that a project can be. I then have that table related to a junction table that has the "Project design choices" linked to the "project code." Anyway, I THOUGHT that one of the bonuses to using Access was that if you see something spelled wrong, you could fix it in one table and it would fix it everywhere. However, when I see that I spelled something wrong in "TBLProjectDesignChoices" and I want to fix it, it tells me that I can't because it contains related records.... ok so, if this is bad design.. I may have to leave it because I have spent countless hours doing data entry for this..

View 8 Replies View Related

Forms :: Conditional Formatting For Choices And Printing In Color

Aug 23, 2013

I have an access form that has a dropdown box list of 10 choices.

For example:

The form states please choose 1, 2, 3 or 4 then the choice should print in BLUE.

They choose 5, 6, 7 or 8 Then it need to print in RED.

So forth and so on.

I am sure there is a code I need to type in the conditional formatting area that would reflect if [1], [2], [3], [4] then I choose the red color.

I do not know how to use VBL or coding.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved