o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Adding record to a Combo Box -

Hello,
I got a combo box that I want to connect to a field in a table that I have.
How can I add the records to the combo box in order that each time I access the combo box, it has all the new available data.

Thanks in advance.

David

 

Adding record to a Combo Box -
Hello, I got a combo box that I want to connect to a field in a table that I have. How can I add the records to the combo box in order that each time I access the combo box, it has all the new available data. Thanks in advance. David

Combo Box/Database Help Question -
Hello, I have a combo box that is filled with data taken from a MS Access table. Each record's name is in the combo box. Each record has an ID which is not in the combo box. I have a seperate text box for the ID. When the user changes the value in the combo box, I want the text b

Avoid Duplicate in Combobox -
Hi All, I have a combo box control in my application. I have to add the items from the database. I added it from database. But it adding duplicate data. Like by running the combo box second time it adding the same data once again. So i need to check the combo box that the data item

Adding a null value to a combo box at design time -
Anyone know how to add a Null value to the list property of a combo or list box at design time? I'm Unable to bind the combo box to my recordset because the added record has null values that the combo box doesn't recognize as a choice in it's list. Thanks, Pooch

Update Form with Combo Box Values -
I have a form that I use for both editing and adding. When the form is used for editing I load the fields with vaues from the table. When loading the combo boxes I set the option selected to the value of the record but when I click the update button it says my field is null. Why doesn'

adding item into combo_box -
hihi.. i am currently adding item from my MySQL database into the combo box. however, its keep adding the item without refreshing it when the search change. e.g if fruit is selected, all variety of fruits will be added into the combo box. however, if i decided to choose food

Control the combo list from displaying problem -
Hi All, I put my vendorName as combo list.So,when i click on it,it allows me to display out all the details of that vendor.We'll,there's fine. But,let's say I want to add a new record,but with same vendorName in combo list.So,once i click to the VendorName in the list,it will aut

[2008] Combo problem -
Hello all, I have a bound DataGridView, displaying some columns relevant to the user, which I use to scroll up and down to display more detailed data in another area of the form relating to the row selected in the DataGridView. This works ok, except for a ComboBox on the form. The C

How to use a combo box to find a record -
Thanks for checking this out! I have a llarge data base of clients each of whom have a reference No (auto number). It is cumbersome using the Go to next record; Go to last record macro as it doesnt give me the exact record I want. What I would like to do is insert a combo box

save combo box list to database -
i am using MS Access 2000 with VB 6.0 i am populating a combo box with user input using the .additem function. this combo box is a bound control bound to the database, when i move forward from record 1 to 2 , the information in the combo box text field and list field are stored in th

2 data combo box questions -
I have a couple data combo box questions. 1) I am having a difficult time getting a data combo box to work. I add the adodc control & the data combo box, I link everything properly. However, the combo box only shows one record at a time. I have to click the adodc control to get

Combo Box Display -
I have a combo box whose item data property is the id field of a departments table. When the user is entering info and selects a department I use this id to identify which department was selected. The problem is that I need to use this same combo to display a previously saved record.

Access - Displaying information in a txt box -
Hi everyone, I am using Access 2007 and I have created a new database and a new form. On the form, I have have one combo box and on text box. On the combo box that under the Row Source property, it is running a query statement that filters the records to only the ones that have under

custom collection and combo box is really making me mad Please help! *RESOLVED* -
Ok i'm going to do my best at trying to explain what's happening. ok here we go i have a form that is basically the base form for adding, editing and deleting information. so far i've only got the adding portion work somewhat... where i'm having the problem. so i inherit the ba

adding to combo box -
if a user enters something into a combo box, how can i add it to the list in the same combo box?

Using rs.Seek to Find a Record -
Hi there, I'd like to add a find record option to my application, and also have a combo box that I would like to load a record relating to the combo box selection. To this end, can anyone explain how I use rs.Seek to find a record within a recordset? Thank you, GT

load contents of ini file to combo box -
Hi i have question again lol..ho can i load this data on my combo box, this is my ini file record: Code: //edit this for adding problems No Signal No power Software Error Contact Service No Display //end That problems will add in my combo box, and when i select that

form bound by combo box -
Forgive me, I'm just getting back into this VB stuff. All I need to do is base a form on a selection from a combo on the same form. In other words, the form is opened and record 1 is displayed in a bunch of text boxes. From the combo box select an entry in the list and the form is up

ADO Combo Box Query -
I want to be able to search for a record in an access database by using a combo box that has one DB field of all of the records in its list. It can move to that record on selection or with a command button, i don't care. PLEASE HELP!!!!!!!!!!!

Adding new records that arent seen until program restart -
I am writing records to an access database. The code works fine the database updates with the new record. BUT after adding a record when I try to view the record it does not appear. If I restart my program the new record will be there, but not if i add it then go to a different screen

Combo box and Typing -
Is there anyway for the user to type in the combo box and it find the record closest to those letters. Like the combo box in vb?

[2005] Auto-Complete a combo box -
Can anyone give me an idea as to how to make a Combo box auto-complete? The combo boxes are being filled from a SQL table, which works fine. I am not sure how to make them auto-complete when a letter is typed. Also, in the db, there are some records with corresponding characters.

Adding new record -
When adding a new record to database table, the record is added in the very first position and at the end of the table. How do stop writing over the first record in the table?

On Click Combo Box -
I have a combo box that lists all records from a Year table. The details on the form are based on the value selected in the combo. The form is requeried On Exit of the combo. If the user types in a Year that is not in the table a new record is saved in the Year table. This occurs

Putting a database list into a combo box. -
Can anyone tell me the code for putting one column of an access database into a combo box. I just need to go through the list from the first record, put the data into a combo box, them move to record two, put this data into the combo box etc.etc....

Populate text boxes from combo box**RESOLVED** -
Anyone got good examples of how to populate text boxes when the user selects an item from a combo box. i.e. I've got a form - when i click a record from my combo box i need to display whats in that record in the multiple text boxes below. What do i put in form load & what do

Adding new record in Datagrid -
Is it possible to set the cetain column in the grid to some default value when adding new record in it ? I tried to mess around with the BeforeInsert event .. but got stuck . Some one please help. Thx

combo box initially blank -
hi guys, i added a combo box on my form and it looks up data from a text file. it works fine, except that initially it is blank, i actually have to click on the combo box down arrow and then select a record. how do i get it to show by default the first record ? thanks, kevin

add new record in table with textbox and combobox without button -
Hi, is it possible to add a new record by opening a form with 3 textboxes en 2 comboboxes. First, i push on the button, new record and then I fill in the 5 boxes and this should give one new record. The big problem is to make this all as 1 record. Or, has anyone another struc

Retrieve autonumber ID after adding a new record -
I have code to write a new record to my ACCESS 2007 database but i want also to read the new ID for that record. Anyone have an idea to fix this? I know you can do it afther adding with a new Select statement. This is a part of the code i have to adding a new record. After adding i

Lookup combo box with value from DB -
hi i have a form with 3 txt fields and a combo box. When the user selects a record to edit I want to load the fields with the database info. When it comes to the combo box I want the suppliername to appear in the combo box from one of the entries that exists already then allow the

Navigating data using a combo -
I'm developing a VB app that uses data from an Access table and run into a problem. I'm used to working in VFP where a bound combo will move the record pointer in the table when you select a value from it's list. In my app, I have a dropdown combo and several text fields. the user s

Combo box & Saving -
Ok, I'm having problems with my final project. First, How can I limit the values in a combo box???? Example: I have a combo box with values 2,3,4. When the user goes to that combo box to chose one and enters any other data, it accepts it. I don't want that!! HELP!!! Second,

Adding records via a data control -
Hi everyone, I have binded textboxes to a data control and called the Recordset's Addnew method programatically to add a record. However instead of adding a new record to the database, it simply overwrites the existing record, which the pointer points, with my new

Adding a record to an identity field -
We have SQL server with an identity colum which acts as a primary key, due to crazy reasons (and they really are crazy). I need to add back a record with a the identity colum set to 22. Is there anyway to do this without altering the column so it is not an identity field then adding t

Master Detail Combo boxes -
Dear All, I have 2 combo boxes (Master-detail). The one is showing the business sectors and the other the sub-business sectors. the values of Sub-business sector combo box are based on the business sector combo box. Lets say that i have selected business sector 1 and under this busi

Stupid Data Combo Question -
Maybe I'm just tired because this should be really easy. I have 3 data combo boxes on a form. Each data combo box is populated by a seperate access 2000 table. The second combo box's contents is dependant on what is selected in the first combo box. The third combo box's contents

Error in adding new record -
Hi, it mi again. Pai seh ah, ask so many things in e forum. I now doing e adding of records hor, i can add into the database liao. But hor, when i go search, i cannot retrieve e data which i have added in the beri first place. There is a count in e form, n the count works, it got dete

Re: Database - How can I add a record to a database -
This thread has been split from here. I have been trying to use the logic in this post to see how I can update a table, but in vain. My concern is, in my GUI, a user will be using a combo to select the conditions of the update, and another combo box to decide where where the updat

recordset refresh -
hi to all of you.. badly need help... how can you refresh the recordset after adding and editingrecord. because when i add new record to the database, the record won't show up in the textboxes after adding it.. i need to rerun the program to be able to see the new record...