Connecting Tech Pros Worldwide Forums | Help | Site Map

auto ComboBox with MSHFlexGrid

Familiar Sight
 
Join Date: Jul 2007
Location: United Kingdom
Posts: 203
#1: May 26 '09
Hi

it's my 1st post in VB,
i'm trying to get data from ComboBox & result with MSHFlexGrid
it's working fine there is no problem

they only thing i need is
Another ComboBox & ( result inside is 5 then ) generate auto
another ( 5 resulted ) ComboBoxs & get result with MSHFlexGrid.

Expand|Select|Wrap|Line Numbers
  1. Private Sub ComboBox_Click()
  2. rs.Open "select*from tblProduct where Supplier='" & cboSupplier.Text & "'", cn, 3, 3
  3. If Not (rs.BOF And rs.EOF) Then grdProduct.Enabled = True
  4. Set grdProduct.DataSource = rs
  5. Set rs = Nothing
  6. End Sub
  7.  
& MSHFlexGrid
Expand|Select|Wrap|Line Numbers
  1. Private Sub grdProduct_Click()
  2. i = grdProduct.Row
  3. With grdProduct
  4.     lblItemName.Caption = .TextMatrix(i, 2)
  5.     scAd = .TextMatrix(i, 1)
  6.     itmAd = .TextMatrix(i, 2)
  7. End With
  8. If Not scAd = "" Then
  9.     cmdAdd.Enabled = True
  10. End If
  11. End Sub
  12.  
everything should be automatic

is any body knows how to do it, thanks in advance for reading & reply

Familiar Sight
 
Join Date: Jul 2007
Location: United Kingdom
Posts: 203
#2: May 26 '09

re: auto ComboBox with MSHFlexGrid


Hi is any body know's how 2 fix this ?

or any thing like this i can do ?

from the dropdown it's just print result with MSHFlexGrid but get result from 1st field & make it's bold & then next field with continues with previous result ?

is any thing i can do ?

thnks in advance
smartchap's Avatar
Familiar Sight
 
Join Date: Dec 2007
Location: Lucknow, India
Posts: 194
#3: Jun 15 '09

re: auto ComboBox with MSHFlexGrid


Quote:

Originally Posted by Fary4u View Post

Hi is any body know's how 2 fix this ?

or any thing like this i can do ?

from the dropdown it's just print result with MSHFlexGrid but get result from 1st field & make it's bold & then next field with continues with previous result ?

is any thing i can do ?

thnks in advance

Dear Fary4u
Actually I think your question is not clear and that's why not getting any reply. Please make it clear or post ur code with the problem u are getting.
Reply


Similar Visual Basic 4 / 5 / 6 bytes