Selecting Entries In Combo Box That Aren't There
Jul 14, 2006
I seem to remember that there is a way, in a combo box, of entering an entry that isn't displayed in the combo box, so that you can then process that entry into a form's underlying table?
I think the example of doing this was in the MS Samples database for either Access 97 or Access 2000.
Does anyone recall what I'm talking about? Second question, does anyone have a link to those sample databases? Our technicians didn't bother loading the samples for us, so I'm kinda stuck.
Thank you tremendously to any and all who reply..... I'm looking forward to your responses!
View Replies
ADVERTISEMENT
Dec 18, 2013
I'm creating a form where people can choose something in the first combo box [ComboBox1] which results in the second combo box [ComboBox2] displaying only the items that are associated with the first combo box [ComboBox1].
In my second combo box I have the amount of "empty lines" that equals with the items associated with the first combo box. But there is nothing displaying. No words.
View 8 Replies
View Related
Sep 18, 2012
I have setup a simple access database consisting of 3 tables
Volunteer
Id (PK)
Name
Job
Id (PK)
JobName
Link
Id (PK)
VolunteerId (FK)
JobId (FK)
There is a one to many relationship between Volunteer and Link and a many to one between Link and Job
I want to create a form from which I'll select a Volunteer Name and then choose a JobName from a list box of options and have it create an entry in link with the id of the volunteer selected and the id of the job selected
So let's say there are 5 entries currently in the Job Table.. let's call the JobNames A,B,C,D and E.
In my form I select my name from the list (sourced from volunteer.Name) and then select B from the dropdown. My desired result would be a single entry gets created in Link with VolunteerId = 1 (representing me) and JobId = 2 representing the selection of B. Problem that I am having is that after I select B in the dropdown it creates a new record for B in Job and the Link table gets updated with that JobId as opposed to simply using the one that was already in the table.
View 1 Replies
View Related
Nov 8, 2006
I have a quick question on Forms. I have a combo-box in a Form that displays the student ID, first name, last name, and test scores from a source table. I have selected only specific fields to display from the source table in the combo-box. The intention is to note down the ID of a student for future querying purpose and I’m looking at easier ways to do it.
The question I have is, as I look down the drop-down and select a student by his last name (say Johnson), I want the student ID to be selected (or copied) when I click the specific student. There could be many students with same last name, and once I select a particular student from the drop-down, I was wondering if there was a way for this ID to be copied or selected. At present, the student ID is written down and used later for querying other information.
Thanks in advance.
View 1 Replies
View Related
Jun 5, 2005
Not sure what to search for so I thought Id write a new post:
I have a combo box which selects 3 items-
Primary key, Surname, Firstname
After an item is selected, the fields are populated according to the item.
Since there will be many records, it would be nice if the user can begin typing the surname and have predictive text, so the three items should then be-
Surname, Firstname, Primary key
So my question is, how do I get at the primary key if it is not selected?
myText = dlookup("myValue", "myTable", "primarykey = '" & ???? & "'")
If this does not make sense, what I am trying to say is:
The surname is selected, but I want to do a calculation based on the primary key so I get all the data associated with that user. I cant use the surname because there are duplicates.
Thank you
View 2 Replies
View Related
Feb 16, 2005
Hi,
ok part of my database is made of 2 tables.
tblItems
item_id
maunfacturer_id
supplier_id
item_name
tblQuantities
quantity_id_num
item_id
quantity
(item_id linked)
ok so I want a form that has a combo box with [item_id, item_name] on each row that i select. when i select one it displays the relevant quantity and allows me to edit the quantity.
any ideas how i can do this?
Thanks:)
View 3 Replies
View Related
Jul 7, 2006
Hi,
I was wondering if it was possible to use a combobox where you could select a month and year (eg March 2004, April 2004) so I could run a query to find orders made during the chosen time period.
Does anyone have any ideas how this could be done?
Cheers,
Ben
View 1 Replies
View Related
Feb 3, 2014
In Access 2013, I would like to be able to choose more than one value from a combo box, but I believe this is not possible. However, I can prepare a list box and set the Multi Select to Extended. Doing this, I can indeed select more than one value, but I don't know how to get those values into a text field in the form. (If poss, they would become comma separated in that field). Ideally, the code would call the list box because it would take up too much space if it were there all of the time.
View 2 Replies
View Related
Apr 8, 2005
Nubie question ( first real database)
I'm trying to populate a combo box with the last few entries of a record. I've been looking on SQL Queries and can see a way of using SELECT TOP on the recordset but querying/sorting the whole record every time seems a very clumsey way of doing it (especialy if the recordset gets large).
So is there a more elegant way of getting lastrecord,lastrecord-1,lastrecord-2, etc into my combobox ?.
Note as a suplemental question is there a way of a subform showing records from last to first instead of what seems to be normaly first to last?
Thanks for any help.
View 4 Replies
View Related
Aug 1, 2005
Hi,
I am trying to choose an entry from a COmbo Box which ahas a Lookuop underlying in it. I then want to display the additonal four entries in the form it self. The data is already created and displayed in a query. The primary key gets displayed but thte other data cannot be displayed. Is there any way I can display the other details eg: Firstname, Surname Age in the same form but under different fieldnames. I am not sure how to do this.
I could retype it all in but that is uneconomical. Any ideas? Please help.
Thanks.
View 2 Replies
View Related
Sep 10, 2004
hey,
sorry to bother everyone again, this is such a great forum, and ive gotten soo much help here.
i have a customer table, containing custRef, custName, drawerRef, Address, Phone, Fax
now it contains site addresses so the custName can be the same for quite a number of entries. no the combo box in my form obviously shows all entries for custName which means the same name repeated sometimes 6 or 7 times, as i only need to select one, is there a way without looking to different tables etc to just show unique entries. i dont want to list them all in another table because i dont know them all yet, so i want it to lookup the list as i enter them.
cheers
Baz
View 3 Replies
View Related
May 17, 2007
Hi all
I am trying to get my head around some of the more advanced “features” of access..
At the minute I am trying to change the criteria of a query from selecting a value from within a combo box.. I believe I have got the syntax correct, but I keep getting no results returned..
I am using:
[forms]![frmMovies]![combo2] as the criteria where frmMovies is the name of the form, and combo2 the name of the combo box.. I have set combo2’s source as the table containing the movie information “tblMovies”
Before you ask I am not trying to setup my own movie store, more apply the theory to a bigger DB that I am working on :-p
Hopefully you can help, as I have now been scouring the forums for 2 days and am getting no where..
Thanks in advance
Noel
View 2 Replies
View Related
Apr 30, 2005
i have a combo box containing dates, however it will only display the date at the top of the list, no matter which date is selected.
any help would be gratefully excepted!
cheers
View 2 Replies
View Related
Feb 1, 2005
Is it possible to select more than one item in a combo box? I have attached a sample of a database I am working on. I have a table called Interests and on the Bookings form, I would like to be able to select more than one interest in the Interests combo box, but I can't figure out how to do it. In databases I have seen, you simply have to hold down ctrl or shift to make multiple selections - that's what I want to do.
Can anyone help, please?
Thank you!!
View 13 Replies
View Related
Apr 13, 2005
I have an unbound combo (because it is synchronised with another unbound combo box) box that selects a record, but I can not get it to update the rest of the form to show the required data.
The form looks up project data from 3 seperate tables which are all linked by relationship.
What do I need to do to make this work?
Thx for looking.
View 2 Replies
View Related
Jun 15, 2006
Is it possible to have a combo box on a form and allow users to select multiple entries from the drop-down list? Thats just the tip of the iceburg. If you can, then I'll probably be asking more questions soon.
Thanks in advance.
View 2 Replies
View Related
Jun 24, 2013
I have a form to modify existing property records. Each record has a PIN number and a unique ID which is a combination of year, state county and PIN. The same property can have a record for more than one year. On this form I have a combo box for selecting the record to be modified. The combo box includes PIN and Prop ID. The combo displays each record by PIN then ID as separate records. For example:
PIN Prop ID
06104409012 2007-IL-Lake-06104409012
06104409012 2010-IL-Lake-06104409012
But when I select a record it will always select the first record with identical PINs. In the case above if I click the 2010 ID the record fills in with the 2007 ID.
View 3 Replies
View Related
Jul 22, 2015
I have a combo box that has three items in it. Name, ID_Num, Date
I need to use ID_Num and Date to filter the results of query. I can use one or the other but not both. I have tried ListIndex but apperently am writing it wrong in the expression builder.
[Forms]![TableName]![Combo0].
[ListIndex]????????????
I have tried =0, =1, =2 after the
[ListIndex] but it doesn't work.
How do I use two items from combobox in a query?
View 2 Replies
View Related
Aug 17, 2005
Hello
I am trying to get a 2nd combo working from the first .
I have a table called Keystage (tblKeystage) and I have also named my 1st combo cboKeystage. then by following the vba below I created another 6 tables with corresponding names and combo's.
Private Sub cboKeystage_AfterUpdate()
On Error Resume Next
Select Case cboKeystage.Value
Case "Foundation"
cboYear.RowSource = "tblFoundation"
Case "KS1"
cboYear.RowSource = "tblKSOne"
Case "KS2"
cboYear.RowSource = "tblKSTwo"
Case "KS3"
cboYear.RowSource = "tblKSThree"
Case "KS4"
cboYear.RowSource = "tblKSFour"
Case "Post16"
cboYear.RowSource = "tblPost"
End Select
End Sub
The combo boxes both work, brilliant. My problem is that when I enter another record and make a selection from the 1st combo box, it changes all the records.
Could somebody please help.
Thanks
Wong
View 3 Replies
View Related
Apr 21, 2013
I've got a combo box that lists duplicates. I want the dupes removed.
I went to the Query Builder for my Combo Box and set Unique Values from "No" to "Yes" - Saved, then re-opened the form. It still lists dupes.
I went back into Query Builder and unchecked the box for the Patient_ID (Autonumber) field. I saved it, then viewed the Datasheet for the Query, and it correctly lists the data I want WITHOUT dupes.
However, when I go to Form View, the combo box lists several blank entries..
The entries come back when I re-enable the Autonumber field in the Query.
This is what I currently have...
SELECT DISTINCT Patients.FullName FROM Patients ORDER BY Patients.FullName;
View 4 Replies
View Related
Jan 26, 2015
I have two tables and their associated forms. Agent Firm and Agent Person. I have created a one (Agent Firm) to many (Agent Person) relationship because a Firm can have many Persons (not vice versa).
I have also created a combo box autofill so that some of the information from the Agent Firm can be posted on the Agent Person.
Query one: I tried using text for the AutoFirm ID because each firm's name is unique. However, when I tried to see what happened if the firm changed its name, still having a unique value, I was not allowed to. Why? and can I over-rule this? For the time being I have used an autonumber as an ID, but I feel that is inefficient.
Query two: I have set up a combo-box, which works, using the following:
Private Sub cboAgentFirmID_Change()
Me.txtAddress1.Value = Me.cboAgentFirmID.Column(2)
Me.txtAddress2.Value = Me.cboAgentFirmID.Column(3)
Me.txtAddress3.Value = Me.cboAgentFirmID.Column(4)
Me.txtTown.Value = Me.cboAgentFirmID.Column(5)
Me.txtPostcode.Value = Me.cboAgentFirmID.Column(6)
End Sub
I originally had a first line Me.txtAgentFirm.Value = Me.cboAgentFirmID.Column(1) but deleted it because the AgentFirm is being entered in the AgentFirmID box (why??)
AgentFirmID, which is the autonumber primary key (see query 1) in Agent Firm is the link between the two tables in the relationship.
Query three: A major feature should be that if an AgentFirm changes its name, or address, phone number, etc this is reflected immediately across all related entries. And it does not happen: each one has be updated manually.
(Imagine if a bank changed its name and had to alter each account manually!) How do I make it work as I am sure it is meant to?
View 13 Replies
View Related
Sep 15, 2005
Ok sorry to be a pain :D
I have a main form frmProperty from where you can go via a button to frmTraining and these two are linked by "Property Code".
On frmTraining i have an unbound combobox which gets it data from the tblTraining table. I want this to only display data for the "Property Code" that the frmProperty is pointing to.
I assumed this would just work if the link criteria was present in the button code, however it appears that no matter what the "Property Code" the combo box displays all the data in the tblTraining table.
Anybody have any ideas?
Many thanks
View 1 Replies
View Related
Sep 29, 2005
Hi,
Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES.
Thanks any help with be greatly appreciated
View 1 Replies
View Related
Sep 29, 2006
Selecting a value from an unbound combo box in Access 2000
Hi,
I am attempting to default a combo box to a value I have passed in. I have already populated the combo box dynamically by setting the column numbers and widths and specifying the row source as Value List, supplying the row source string.
Since I am working with classes and collections, I wish to avoid data binding as I would prefer that the classes handle everything, which they can do.
Now my problem is that I cannot find how to select the correct value on the dropdown after populating it with all the values. When I try a line like:
cboAppType.Column(0) = lngValue (where lngvalue corresponds with a value in the list)
it returns the error "object required". It won't recognise the column at all, even though it sees and displays the rows and columns.
I am beginning to tear my hair out as I have been struggling against Access all the way to try and implement unbound combo boxes and listboxes and having overcome everything else, I'm stuck just here.
Any help very much appreciated - thank you
View 2 Replies
View Related
Sep 30, 2005
Hi,
Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES.
Thanks any help with be greatly appreciated
View 1 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
