Help me please please help !!!!! 
Author Message
 Help me please please help !!!!!

I created a database with access 2000 and some of the fields are scroll
down(a field from another table)  type how can I get that to happen in VB6
program I need it like is because the fields are always changing  please
help


TIA



Sun, 18 May 2003 03:00:00 GMT  
 Help me please please help !!!!!
Why don't you use a combo box on your vb form, and have it list the records
from your other 'lookup' table

Quote:
> I created a database with access 2000 and some of the fields are scroll
> down(a field from another table)  type how can I get that to happen in VB6
> program I need it like is because the fields are always changing  please
> help


> TIA



Sun, 18 May 2003 03:00:00 GMT  
 Help me please please help !!!!!
how can i do that

Quote:
> Why don't you use a combo box on your vb form, and have it list the
records
> from your other 'lookup' table


> > I created a database with access 2000 and some of the fields are scroll
> > down(a field from another table)  type how can I get that to happen in
VB6
> > program I need it like is because the fields are always changing  please
> > help


> > TIA



Sun, 18 May 2003 03:00:00 GMT  
 Help me please please help !!!!!
Sub LoadCombobox()
dim rs as new Recordset
rs.Open "LoookUpTable", adOpenForwardOnly, adLockReadOnly
With ComboBox1
    do Until rs.EOF
        .AddItem rs("TextField")
        .ItemData(.NewItem)=rs("IdentityField")
        rs.MoveNext
    Loop
end with
End Sub

Or (faster)

Sub LoadCombobox()
dim rs as new Recordset, vaRS as Variant, i as Long
rs.Open "LoookUpTable", adOpenForwardOnly, adLockReadOnly
vaRS=rs.GetRows( , adBookmarkFirst, Array("TextField","IdentityField")
With ComboBox1
    For i=0 to Ubound(vaRS, 2) - 1
        .AddItem vaRS(0, i)
        .ItemData(.NewItem) = vaRS(1, i)
    Next
end with
End Sub


Quote:
> how can i do that


> > Why don't you use a combo box on your vb form, and have it list the
> records
> > from your other 'lookup' table


> > > I created a database with access 2000 and some of the fields are
scroll
> > > down(a field from another table)  type how can I get that to happen in
> VB6
> > > program I need it like is because the fields are always changing
please
> > > help


> > > TIA



Sun, 18 May 2003 03:00:00 GMT  
 Help me please please help !!!!!
Some DBGrid have built in functions for that too.

R



Quote:
>Sub LoadCombobox()
>dim rs as new Recordset
>rs.Open "LoookUpTable", adOpenForwardOnly, adLockReadOnly
>With ComboBox1
>    do Until rs.EOF
>        .AddItem rs("TextField")
>        .ItemData(.NewItem)=rs("IdentityField")
>        rs.MoveNext
>    Loop
>end with
>End Sub

>Or (faster)

>Sub LoadCombobox()
>dim rs as new Recordset, vaRS as Variant, i as Long
>rs.Open "LoookUpTable", adOpenForwardOnly, adLockReadOnly
>vaRS=rs.GetRows( , adBookmarkFirst, Array("TextField","IdentityField")
>With ComboBox1
>    For i=0 to Ubound(vaRS, 2) - 1
>        .AddItem vaRS(0, i)
>        .ItemData(.NewItem) = vaRS(1, i)
>    Next
>end with
>End Sub



>> how can i do that


>> > Why don't you use a combo box on your vb form, and have it list the
>> records
>> > from your other 'lookup' table


>> > > I created a database with access 2000 and some of the fields are
>scroll
>> > > down(a field from another table)  type how can I get that to happen in
>> VB6
>> > > program I need it like is because the fields are always changing
>please
>> > > help


>> > > TIA



Tue, 20 May 2003 03:00:00 GMT  
 Help me please please help !!!!!
1-many relationship
use a databound combobox set the
rowsource propety = table which is from 1 part of relationship
list field property= lookup field from table which is from 1 part of
relationship
bound column property =the common field between two tables.
data field property = the common field field between two tables.
datasource propert = table which is from many part of the relationship

regards dawlat (MCSD).



Sun, 25 May 2003 03:00:00 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. Help me please please help !!!!!

2. Help me please please help !!!!!

3. PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP,

4. Can anyone HELP me PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE

5. PLEASE HELP PLEASE HELP PLEASE HELP

6. Design Help PLEASE PLEASE PLEASE!

7. Please Please PLEASE HELP!!!!!

8. URGENT HELP PLEASE PLEASE PLEASE???

9. Please please please, help me :-)

10. Please, Please, Please I need help working with dates

11. Please, please, please help!!

12. Cloning problem -- please please please help

 

 
Powered by phpBB® Forum Software