if i run the program it goes hang here is the code
Set rs = New ADODB.Recordset
.Open "Select * from tblCandidates1", cn, 2, 3
Do While Not .EOF
If !Position = Combo1.Text Then
ElseIf !Position = Combo2.Text Then
ElseIf !Position = Combo3.Text Then
ElseIf !Position = Combo4.Text Then
ElseIf !Position = Combo5.Text Then
ElseIf !Position = Combo6.Text Then
ElseIf !Position = Combo7.Text Then
Not a lot to go on here. At first glance, it appears that the construction of your mega-IF/ELSIF construct will never get the the ".MoveNext" on line 24 because it has to fail every condition before it goes to the next row. So, if you have "!Position" match any of the criteria, the loop will simply repeat over and over, never advancing to the next row.
However, if that's not the problem, there is other information that needs to be supplied before we can help. Where are you setting the connection (I assume the variable "cn" is your connection)? Which statement actually hangs? Have you tried to step-execute to see how the logic actually flows? And so on.
No, I don't have any information on that. I don't do anyone's homework for them. You asked a question, I gave pointers to help you solve it. If you need more fundamental coding examples, I recommend you use google to search it out.
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.
OK, so HostGator for some reason no longer allows gcc/g++ access unless you have a Designated Server account, which is a lot of money to spend just to compile my "Hello World" program. Thus I figured I'd compile at home, then upload. Program is your regular old bare-bones Hello World ...