dmcp
Last Activity: Oct 28 '08, 02:21 PM
Joined: Apr 12 '08
Location:
-
this is not what i meant. what i need is to show the records that contain the characters that i wrote in the combo box -
filter a combo box in a continuous form
hi
i have a combo box in continuous form is there a way that i can filter the combo as i write in it? -
thanks for your useful hints
the rowsource type was empty. it worked.Leave a comment:
-
the current value is correct in the table groups 4040& 4050.
there are 2 tables groups & IO . 1 to many relation from grp to IO.
the purpose of filtering the IOs is that i want to get only the GRPs in the IO to get a filtered list of IO. sometimes i need more than one io_grp to get the list of IO ....Leave a comment:
-
stewart here is the last test in the immediate window
?SQLSTR
SELECT internal_orders .ior_no, internal_orders .ior_descriptio n,internal_orde rs.ior_date, internal_orders .io_grp FROM internal_orders WHERE internal_orders .io_grp IN (4040,4050)
it also didn't work...Leave a comment:
-
stewart
here is the immediate window test
?SQLSTR
SELECT internal_orders .ior_no, internal_orders .ior_descriptio n,internal_orde rs.ior_date, internal_orders .io_grp FROM internal_orders WHERE internal_orders .io_grp IN(4040,4050)...Leave a comment:
-
hi stewart
i'm not quite sure i understood your remarks but what i did is tested the sqlstr in the immediate window and pasted it in the sql query and it gave correct data.
if there is something wronge with the code would i get correct data? could my problem be in the IO listbox?...Leave a comment:
-
the original query that i sent gives no data . i didn't know what's wronge with it...Leave a comment:
-
unbound list box
i have an unbound form with 2 multiselect list boxes. grp & io.
the IO listbox is unbound and depends on the grp listbox but after finishing from the grp listbox i'm getting a null IO listbox.
the below code is tested and ok.
[code=vb]Dim V As Variant
Dim GRPS As String
If Me.grp.ItemsSel ected.Count > 0 Then
For Each V In Me.grp.ItemsSel ected
GRPS = GRPS & Me.grp.ItemData (V) &... -
i have an unbound form with 2 multiselect list boxes. grp & io.
the IO listbox is unbound and depends on the grp listbox but after finishing from the grp listbox i'm getting a null IO listbox.
the below code is tested and ok.
Dim V As Variant
Dim GRPS As String
If Me.grp.ItemsSel ected.Count > 0 Then
For Each V In Me.grp.ItemsSel ected
GRPS = GRPS & Me.grp.ItemData (V)...Leave a comment:
-
thanks for the hint
but i was wondering why the query didn't workLeave a comment:
-
subquery
hi
i have the below query that is not working .
select gro_code,grp_na me from groups
where exists
(select * from groups where len(gro_code)<5 )
i want to get all data in groups where no# of digits in gro_code<5
No activity results to display
Leave a comment: