MS ACCESS :: Combo Boxes

Combo Boxes / Text Boxes
Hi guys, I have a related databes with about 20 tables.

My main table stores the data linking with most of the other tables. This main table stores football match records with player line ups. Initially I had a problem linking the 11 player fields in the main table to the player table, Icould only do it with 1, so someone at work suggested to link it using the lookup function. This worked brilliantly. However, now I am designing a GUI with forms but the forms have combo boxes where the lookup function was used and when i change these to text boxes, the players names are replaced with their ID numbers.

Is there any way of creating the form without the unsightly combo boxes, as they won't be needed, the GUI will be read-only. I look forward to your help!!

View Replies ! View Related

Combo Boxes And Text Boxes
I have a table that has client names and addresses. I have designed a form to be able to invoice these clients and everything is fine however what I'd like to do is have the address of the client appear automatically.

I have set the client names in a combo box and would like their address to appear in either a text box or sunken label automatically from the table. Is this possible and how do I do it.

Please keep in mind that I've done basic programming so please be kind to this newbie :D

View Replies ! View Related

List Boxes And Combo Boxes
Hi everyone,
I have been making progress with customizing a
MS Access program, but one major problem is that
I have been trying to make a List Box or Combo Box
that I can use to enter data in the TABLE, but I
find that I get a pull-down list that has the list of
values from only the parameter that is primary key.
More specifically, the program is set up as follows:
I have two tables in this program: One that is called
"invoices" and one that is called "items". In both of
these tables, there is one common parameter, which
is "Item Number". Item number is the primary key,
and I used the "relationships" function to tie this
parameter to itself between the two tables.
I was successful in setting up a list-box for the
"Item Number", but when I try to set up a list-box
for another parameter that is supposed to display
a person's initials, the pull-down list displays the list
of item numbers instead of the list of people's initials.
In fact, I don't know if there is an extra step I need to
take so that the database stores a list of people's initials.
Instead, I just fill in the initials in the field for each
record for which the "Item Number" is the primary key.
How can I get the list-box to pull down a selection of
different people's initials, or in other words how can I get
all the people's initials to be stored so that the list of
initials can be looked up. Just so you know, I have tried
different choices of entries in the "Lookup" tab in the
Design mode of Tables, including Display Control,
Row Source Type, Row Source, and Bound Column,
but the outcome is that the only parameter that I
get get in the pull-down list is the primary key, which
is Item Number.
I appreciate any help you can offer in explaining how
to correct this.
On a separate note, one of the parameters is "Date", and
on the reports, I'm trying to figure out how to filter a
specific date range so that I can limit each report to a
specific month. Please advise me on this procedure as well.
Thanks.

View Replies ! View Related

Combo Boxes
Hi
I have a combo box and its row source is a query that selects distinct values from a column in a table

However i would also like the user to be able to select nothing/null value from the combo box. How do i do this.

Thanks

View Replies ! View Related

Combo Boxes
What is a combo box and how do I make one?

View Replies ! View Related

Combo Boxes
I have created a query to simply bring up various parameters asking questions which then give back the results that are correct! i am wondering if it is possible so that when the parameter boxes display on the screen, for you to be able to select the answer from a combo box list (within the parameter box) instead of typing them in???

Cheers

View Replies ! View Related

Combo Boxes
I have read the cascading combo box solution and would like to know if this would help me with my specific solution.

I have a subform that is used to populate a table which is later used to cost each row by linking to a costing table (see later).

3 off the columns in this form have been set up as combo boxes e.g.

(1)Supplier/(2)Product type/(3)Product 2 is dependant on 1 and 3 is dependant on 1 & 2

These combo boxes currently refer to my costing table to ensure that the user can only enter a combination that is in this table so that when I compare the data entered in my subform table these combinations will be present in the costing table.

I get the 2nd combo box to show only the product types available for the selected supplier by afterupdate me![Product type]requery on the 1st combo box

The 3rd combo box is dependant on both 1 & 2 so I have applied afterupdate me![product]requery which has filters in the query as follows
Forms![subform]![Supplier]
Forms![subform]![Product type]

This seems to work ok when entering data initially into the form which places it directly into my table

The problem I have is when someone later goes into a record and changes combo box 1 and the data in combo 2 & 3 may now not be an option so how can I force them to go and re-visit these filed before exiting the form?

The second problem is if they go to the next record in the form and select the 3rd combo box to edit the field the qry does not show the correct option and shows the ones for the previous row?

Any suggestions please..

View Replies ! View Related

Help With Combo Boxes
I have a Order form that i would like to use combo boxes when adding details records to the order. For example, my list of products is very long, each product belongs to a Series(category) I would like to create two combo boxes when placing an order. First one to select series, then another one to select product. I would like the product combo box to show only those products related to the series. Seems like a simple task but i am having so much trouble. I tried looking at the Northwind db because it has categories and products but in their order form their combo box just list products and there is no example like the one i want to do. Can anyone help?

View Replies ! View Related

Help W/ Combo Boxes
Hi,

I have attached a small version of my database/form. I am trying to display only those records in a subform based on the values selected from two combo boxes. So when the user selects a client from the 1st combo box, the 2nd combo box is populated with the tests that pertain to the client selected. When the user selects a test from the 2nd combo box, I want the records to update with only those records that have the test for that client. So if there is no record for that test, then no records should be displayed (even though they may have records for another test - not sure if that made sense...).

My whole purpose is to allow the user to select a test only once and only have to select the level list based on however many levels are available for that test (I want it to be simple for the user).

Example: Open up my form, select Alabama from the clients list.
The subform has all of the tests for the client and the levels. Select Physics from the tests list. I now want the subform to display only the records were Test=Physics.
Once I get that working, I will make ClientID and Test in the subform not visible (only the Level drop down list will be displayed). So when a user selects a level from the list, the table needs to get updated with all of the information (clientID, testID, levelID).

Have any suggestions? Any help will be much appreciated.

Thanks,
dbnewbie

View Replies ! View Related

Combo Boxes
I'm sure this question must have been asked before but I can't find it here, so my apologies.

I have a form for collecting addresses, it has two combo boxes, the first contains a list of states, and then the second contains a list of postcodes found within that state based up a query with the criteria

[forms]![FRM_Delpoint]![StateID]

the problem is the second combo box always shows the list relevant to the first record.

View Replies ! View Related

Combo Boxes
Hi all,

I have a combo box who's Row Source Type is set to Table/Query and who's Row Source pulls 2 columns of data from an existing table (UserID;UserName).

I would like to set the first row on the combo to "*;Select All" and follow this by "UserID;UserName" for all users in the table.

I've tried using combobox.additem Item: = "*;Select All",Index: = 0 but it requires the combo box to have the Row Source Type set to Value List though I'm not sure how to pull in the table data if the type is set to Value List.

Any Idea's how I can get around this problem?

Thanks,

Dave

View Replies ! View Related

2 Combo Boxes
In my form I have 2 combo-boxes. The first combo-box is linked to the 2nd field in my table, the 2nd combo-box is linked to the 3rd field in my table.
The selection of the 2 combo-boxes should show the content of the 4th field in my table.. No matter what I tried I could not get it to work.. Can somebody help me ?? :eek:

View Replies ! View Related

2 Combo Boxes
In my simple database I have 3 fields, field 1 = UN number, field 2 = Packing group and field 3 = proper shipping name.
After my selection in the 2 combo boxes the correct proper shipping name should appear in a text field. When I select the UN number in the first combo I get a proper shipping name but not the correct one.. I have 2 scroll through the records to get the correct one and my input in the 2nd combo doesn't seem to effect my selection.. Can somebody please help !?

View Replies ! View Related

2 Combo Boxes
I am trying to set up 2 combo boxes in my form. The first one holds the Category and the second on holds the Sub Category. I would like the second combo to only pull Sub Categories pertaining to the Category selected.

I have the Category fields set as: CATID, CATEGORY
I have the SubCategory fields set as: SUBCATID, CATID, SUBCATEGORY

I don't know if I set this up properly, so help would be greatly appreciated.

Regards,
Irish

View Replies ! View Related

Combo Boxes
Im new in using Access 97 and would like some help. Basically I have two combo boxes on a form - one containing Months of the year Jan...Dec that I have typed in manually and the second one containing years 1999....2006 (Also manually typed in). On a table I have got data on food and one of the columns is expiry date(Set as Date/Time data type in 22/06/2004 format) for example. I have got a form with these combo boxes on and Im stuck on the code. What I would like is for me to select from the first combo box (Month) say June and then select from the year combo box (Year) say 2004 and then press a command button that will look at the selected choices which looks at the expiry date column in the table, and process a report with everything expiring in June 2004. Would I go around this by making a hidden text box which temporary holds the selected month and year then processes a query along the lines of Between 01/06/2004 and 30/06/2004 (or between the first day of the selected month and year to the end of the selected month and year)??? Not sure how you go around it as it's set out as dd/mm/yyyy format and I only want the month and year looking at. Im totally stuck and dont know where to begin. Im new to Access and I would like this as it helps me look at my data better. Cheers. Hope someone can help?

View Replies ! View Related

2 Combo Boxes
Hi,

Sorry, i know that this has been asked but im rather new to access and do not really understand what i need to do!

I am runnning a system that will allow me create a booking system. I have a table which looks like this

Mon Morning
Mon Afternoon
MonEvening
Tue Morning
...
...

I would like to use combo boxes so that i can then select just the day from the first and then choose from the slots avalible for that day.

If you can help or need any information please reply!
THanks

View Replies ! View Related

Combo Boxes
Thnaks for the replies thus far to previous combo problem. I have used the Not in List event and this is fine...but I dont want the user to be able to type anything into the box at all in the first place.

I have set auto correct feature off and my list is still useable but the user can still type into the box.

Any ideas??

View Replies ! View Related

Combo Boxes
How can I limit the contents of a combo/list box on a sub-form based on what's selected in a combo/list box on the main form?

View Replies ! View Related

Combo Boxes
Ok so another query from me today.

On my database I have a number of different teams, on some of the combo boxes not all the entries are relevant to all the teams but they may also share some of the same entries in the combo.

Can I have the combo filter it's drop down list dependant on the team that the user is under, understanding that on some entries 3 or 4 teams will want to view this.

I was thinking along the lines of for the relevant table, have fields for each team and then a yes no check box ?

So for entry line 1, team 1, 2 & 4 have yes but 3 &5 are no, so they do not see it in there drop down ?

Many thanks

MattP

View Replies ! View Related

Combo Boxes
Hi, I hope some one can help me with a few questions I have surrounding combo boxes:

I imported a table into Access from Excel. I then created a form based on the table. Here is what I would like my combo boxes to do:

For my records that already exist, I want the combo boxes to list all data for all records in the drop down. So in my DB, I have a state abbreviation in that field, so in record one it may be CA and in record 2 it may be NJ, I want it so that you see NJ and CA when you click on the drop down.

For entering a new state, I want a user to be able to choose from the drop down and it save to the table but also be able to add a new state if it's not listed. Then that new state should be added to the drop down list.

I'm not sure if this is possible but if you can give any suggestions, I would greatly appreciate it.

Thanks

View Replies ! View Related

Combo Boxes??
I want to use two combo boxes. The first will allow me to choose a particular crew, and the second will allow me to choose an employee on that crew. My problem is with the second combo box. How do I get it to display only the employees that belong to the crew chosen in the first box?

View Replies ! View Related

Hep With Combo Boxes
I have 2 Combo boxes, (CboCallType) & (CboSubCall). These have 2 seperate tables (TblCallType with A CallTypeid & Type) (TblSub with Subid, CallTypeid & Subid).
What I require is when CboCallType has been populated I require the corresponding list to be available in CboSubcall.
Please help going mad trying.

View Replies ! View Related

Combo Boxes?
If I have 3 combo boxes that have autocomplete turned on, is there an absolute limit on how many records I have? Right now, I have approx. 30K. I expect to be at 40K in a couple months.

Originally, I just wanted fast data entry. I didn't expect there to be so many records. I don't feel what I started with is my best option for the future.

Anybody have a better option?

Thanks in advance

View Replies ! View Related

Combo Boxes???
Is there a way to store more than one value in a field that has been selected from a combobox?

For example your combo box includes the values "One", "Two", and "Three". Can you drop down the list and select a first value (say "One") then do the same and select a second value (say "Two") so that the value in the field is now "One, Two"

View Replies ! View Related

Combo Boxes
In a form i want it possible that when i click on one drop down menu you have a choice of makes and then in the net drop down menu the choice of models. The problem is if you select make = Sony only the sony models should be allowed in the next drop down menu.

Regards

MPV

View Replies ! View Related

Combo Boxes
I have a form that prompts the user to select 2 criteria proior to opening a main form for view or edit. The first combo box asks them to select a Model Number and the second asks them to select the Version Number. I need the Version Number to limit itself based on the Model Number entry. For example, some Model Numbers have 2, 3, 4 or more versions whereas others only have 1. I wrote a query that had [Forms]![Model Number Selection]![Model Number] for the criteria for Model Number and [Forms]![Model Number Selection]![Version Number] for the criteria for Version Number, which of course got me nowhere. I am sure I am making this harder than it needs to be, so can someone enlighten me?

CorrieAnn

View Replies ! View Related

Combo Boxes
Help please??!!

I have created a combo box in my database and although I can see all the fields in the form view, nothing happens when I try to select them. I don't know what I have done wrong - has anybody got any suggestions?

Thanks a lot!!

View Replies ! View Related

Combo Boxes.
hello.

I am trying to create a combo box that will display items that are associated with an item selected from another combo box. I am attaching the db here. It is a litter more self explanitory when you look at the db.

View Replies ! View Related

Trouble With Combo Boxes!
Hi everyone,

This would seem like the easiest thing in the world to do, but I can't find out how. Am I over-complicating things?

I have lists of tables of contacts (a new table for each company). On my "Menu" form, which loads up when the database opens I want to be able to have a combo box that lists the companies (I have the company names in a separate table), so that the user simply picks the company name from the drop down list, then presses a command button and is taken to the first record of that company's table (in form view).

I've spent ages trying to work out how to do this but I'm failing miserably. All help appreciated! Many thanks. Stuart.

View Replies ! View Related

Problem With Combo Boxes
Hello,

First for all, sorry for my poor english.

I have one table tblDATA with fields country and city and one form. It has two combo boxes. One combo box (Combo_Cities) is based on another combo box (Combo_Countries). Everything works fine. Choice in the Combo_Cities combo box depends what user choose in Combo_Countries combo box.

I am using SQL statement in Row Source:

SELECT tblDATA.Country, tblDATA.City FROM tblDATA WHERE (((tblDATA.Country)=[Forms]![frmMAIN]![Combo_Countries]))

There is code in VBA I am using to add data to Combo_Country on not in list event:

Private Sub Combo_Country_NotInList(NewData As String, Response As Integer)

Response = acDataErrContinue
If MsgBox("Do you want to add country?", vbYesNo) = vbYes Then

Dim db As Database
Dim rstCountry As Recordset
Dim sqltblDATA As String

Set db = CurrentDb()
sqltblDATA = "Select * From tblDATA"
Set rstCountry = db.OpenRecordset(sqltblDATA, dbOpenDynaset)

rstCountry.AddNew
rstCountry![Country] = NewData
rstCountry.Update

Response = acDataErrAdded
rstCountry.Close
End If
End Sub

Everything work fine seperate, but if I put SQL statement and VBA code together, I 'm getting errors. Maybe somebody can share code how to do, that users can add data in combo boxes, where one combo box depends on another? Thanks in advance!

Renaldas

View Replies ! View Related

Editing Combo Boxes
Is there a way to edit combo boxes? I'm trying to add a null value to a combo box.

View Replies ! View Related

Interrelated Combo Boxes
Hi All
I have a table of products and within the table there is a field that stores the products family name, and another that stores its suffix.

Ie:

For a product called a CLASS CL1

Product_Family_Name = CLASS
Product_Suffix = CL1

I would like to implement a combo box which would allow me select firstly a family name. And then, then second combo box would show me all the corresponding suffix's for the already chosen family name.

So, if I had 3 products in the CLASS family, one called CL1, another CL2 and
the last CL3. On selecting the 2nd combo box, I would like to be able to choose between CL1, CL2 and CL3.

There would be other different family names too, each with a different number of product suffix's.

Is this easy to achieve? If so, could anyone explain to my how to do it?

Many Thanks
Lee

View Replies ! View Related

Cascading Combo Boxes
I have a few cascading combo boxes that restricts the value of one combo box depending on what the the value of other one is.

The problem I have is that some of the data is not displayed in the combo boxes when scrolling through the records after data entry.

I have tried to re query them on the form on open event but it does not seem to help much.

Any Ideas?

thanks :)

View Replies ! View Related

Linking Two Combo Boxes Together
I have created a database for tech calls that come into my office.

I have created two tables with information i need on my form

table 1 = Office Location ID and Office Location (ie Chicago and other towns)
table 2 = Employee ID, Employee, and Employee Location Code (ie Chicago = 1)

I have created a form with the fields that i need to record all the data.

What i want to do is create a Combo box for office location and place the 3 office locations via a field list. I then want to setup another combo box that would display only the employees that are part of the office location that was selected in the previous combo box.

If anyone could assist me in this it would be greatly appreciated.

View Replies ! View Related