New profile posts

Thank you MajP for your Date Picker selection. I'm a real novice a Access VBA but learning a bit more every day, your instructions are perfect and they got me out of a hole. Much appreciated.(y)
Thank you for helping me most of the time. I posted a question, may be if you have time to help out in this post.
Hi @arnelgp , thank you for helping me most of the times. I posted question, may be if you have time to help me out there..

hiii ....can you help me to filter listbox by command button then search by textbox
listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
but
button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
when i click button 1 .....listbox nolonger filtered by text search box
hiii ....can you help me to filter listbox by command button then search by textbox
listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
but
button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
when i click button 1 .....listbox nolonger filtered by text search box
can i filter listbox by both command button and search textbox
H
haitham Elareny
listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
but
button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
when i click button 1 .....listbox nolonger filtered by text search box
i want to filter listbox by command button then search in listbox by textsearch
H
haitham Elareny
listbox rowsource based on query in which used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" in testname field
on load it filters listbox
Private Sub Command2_Click()
List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
End Sub

Private Sub Command3_Click()
List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
End Sub

Private Sub txtsearch_Change()
Me.List0.Requery
End Sub
H
haitham Elareny
i wish to help me since i was tried more
Welcome. Looking forward to your contributions. Your first post was spot on.
A
alphonseg
Thank you. I'm hoping this forum will be more interesting than the MS forums.
hi arnelgp

still I need your help in my post


please check ranking serial

is not correct

thanks for you help!
arnelgp
arnelgp
I already given you two examples.
you ask other people in the forum.
I already done my part.
  • Like
Reactions: hatmak
H
hatmak
thank u for reply
when I filter data
rank not change as filter
look like
1
2
4

number 4 should be 3

do u understand me
thank u again
H
hatmak
please try to change filter and see ranking
Dear Mr Sonu,
Regarding your post "acCmdInsertHyperlink does not allow to set a default start folder" in which Code 1 and Code 2, to Open the File in Specific folder.
May I know that this Issue resolved? As I am also facing the same issue with my DB in Access.
Kindly guide me.
Regards
Zubair Mughal
@jcsuarez - your question via the Profile Post method requires an answer that is too long. I will create a conversation to answer what I need to answer.
hi.... i want to design a message box which appear from right to left on opening at bottom of screen ,then disappear from left to right on closing .i tried with
form_load inside height=20000&inside width=0 but want to change message width from 0 to line length on opening
hi..i want to design a message which appear from right to left at bottom of screen on opening then disappear from left to right on closing .i tried using inside height
I appreciate greatly for your tremendous help with building the database for me. Thank you for all your help
Back
Top Bottom