Plss Help: Combo Box with Database

Shinaj · February 1st, 2009, 09:12 AM

Hi, I'm new to VB, and I'm doing my first project, I need help for following..

1) I have a ComboBox in a Form in VB which should be (read only)filled by items(75 items) from a field of a table in MS access databse, I have done databinding but, only first item of the table is visible in the ComboBox. I dont want to use BindingNavigator to step to next item, I'm looking for a drop down comboBox.

2) The project required many Forms, so by clicking a button one form should be closed next Form should appear, I'm using following codes
Form1.Show()
Me.Close()
but, this looks not proffessional as it blinks while opening in different window,
how do i use a parent Form and call all other forms into that form.?

Plsss Help me on this, Pls explain as I'm not expert in VB yet...

Thanks..

planoie · February 4th, 2009, 06:33 PM

I'm not sure what you are asking about in question 1.

But for question 2, it sounds like you need to build an Multiple Document Interface (MDI) type application. You'll have a master form into which you can open other forms. You can control what get's opened, so basically instead of having multiple forms, you'll just have a single one that is contained in a parent.

Patrick Cambria · February 7th, 2009, 04:00 AM

Quote:

Originally Posted by Shinaj

Hi, I'm new to VB, and I'm doing my first project, I need help for following..

1) I have a ComboBox in a Form in VB which should be (read only)filled by items(75 items) from a field of a table in MS access databse, I have done databinding but, only first item of the table is visible in the ComboBox. I dont want to use BindingNavigator to step to next item, I'm looking for a drop down comboBox.

2) The project required many Forms, so by clicking a button one form should be closed next Form should appear, I'm using following codes
Form1.Show()
Me.Close()
but, this looks not proffessional as it blinks while opening in different window,
how do i use a parent Form and call all other forms into that form.?

Plsss Help me on this, Pls explain as I'm not expert in VB yet...

Thanks..

Question 1.)
When you query the database with SELECT * FROM you need to get the number of records returned and loop though them adding them to the list.

You can either of the following where rs = RecordSet
Please note Im typing these examples with no compiler so i may make a mistake but it will point you in the right direction.

Code:

For i = 0 to rs.RecordCount -1
ComboBox1.Items.Add(rs.Fields(i).Value)
Next

Code:

        Do
            ComboBox1.Items.Add(rs.Fields("ID").Value)
            rs.MoveNext()
        Loop While Not db.rs.EOF

Question 2) You can either put the code to open the new form in the formclosed event of the opend form or you can put the code to close the previous code in the form load even of the new form. Or you can just use panels and hide them and show them all in one form depending on what you are trying to do.