User Profile

iskov · Mar 2 '15, 01:27 PM

This does not solve my Problem is at will still only Show ALL of the "erledigt" or ALL of the "non-erledigt"

I have at the Moment in my database two different customers:

Danish Crown Konzern

And

Tönnies Konzern

in a form I Show Information such as CustomerName, Subsidiary, data etcetc, in my searchfield (txtsearch) that is connected with the button:...

iskov · Mar 2 '15, 01:06 PM

I am sorry, I have changed the codes so they are alittle easier to look at.

Should I make a new thread?

My Problem is basically:

The Report-filter works perfectly fine along with the button that filters for "erledigt" or "non-erledigt" HOWEVER when I use my search field (txtsearch) with the button to search with, the Report still only Shows ALL of the erledigt or ALL of the non-erledigt....

iskov · Mar 2 '15, 07:29 AM

I am going to pump this post as I am running into a minor Problem.

Basically the Report button works perfectly, however my form ALSO has a search field:

Code:

Private Sub Befehl104_Click()
Dim strsearch As String
Dim strText As String
Dim filterstr As String

If (Len(Txtsearch.Value) > 0) Then
    strText = Me.Txtsearch.Value
    strsearch = "SELECT * from ServiceAuftragTabelleQ

...

iskov · Feb 24 '15, 01:40 PM

Thank you once again, I like the idea alot!

iskov · Feb 24 '15, 01:24 PM

@Twinny

If I want to add a msgbox to say "filtered for 'erledigt'." and "Filtered for None-'erledigt'" where do I put the msgbox's??

Kind Regards

iskov · Feb 24 '15, 01:17 PM

Vielen Dank, dass war sehr erfolgreich!!!!
;-)

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Filter FormTable to show only "Yes" from Yes/No BOX