Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ssecca26
  • Order by date
  1. ssecca26

    Multi Select List Box to filter Report

    thats the only way to choice the fields in list? thanks i'll try it again.
  2. ssecca26

    Multi Select List Box to filter Report

    is not working, same problem then if statement is has error
  3. ssecca26

    Multi Select List Box to filter Report

    so its gonna be like this? Private Sub Report_Open(Cancel As Integer) Dim strWhere As String Dim strSQL As String Dim strSection As String Dim frm As Form Dim i As Integer Set frm = Forms!form1 strSection = "" For i = 1 To 4 '4 represents the...
  4. ssecca26

    Multi Select List Box to filter Report

    but i want to select all if the user didnot tick any of the section. please help me solve this problem. thanks!
  5. ssecca26

    Multi Select List Box to filter Report

    really is not working,,, theres no other way?
  6. ssecca26

    Multi Select List Box to filter Report

    yes i paste it in the onopen event.
  7. ssecca26

    Multi Select List Box to filter Report

    i change it and a error pop up "The action or method is invalid the form or report isn't bound to a table or query
  8. ssecca26

    Multi Select List Box to filter Report

    Dim strWhere As String Dim varItem As Variant Dim strSQL As String Dim strSection As String Dim frm As Form Set frm = Forms!frmReportCriteria strSection = "" For Each varItem In frm!lstSection.ItemsSelected strSection = strSection & "[Weekly...
  9. ssecca26

    Multi Select List Box to filter Report

    i can still need the previous code i build in module right? i will just add this one. am i correct?
  10. ssecca26

    Multi Select List Box to filter Report

    yes correct how can i build my sql to fly?
  11. ssecca26

    Multi Select List Box to filter Report

    no i want to display all the value of each section it (no criteria). for example i tick area 1, cp 1, name malu, section 2 it will only show the value of area 1, cp 1, for malu and the value of section 2. if i tick section 5 and 7 it will show the value of section 5 and 7.
  12. ssecca26

    Multi Select List Box to filter Report

    Now my form before is working,, i now know the logic of that one, i encounter again another problem in the same report, i have the section list which list all the section in my table like this Section_1....text Section_1details..memo Section_2...text Section_2details....memo and so on then...
  13. ssecca26

    Multi Select List Box to filter Report

    Thanks FancyPrairie! now it is working and i figure out the problem, i have a control source in my property. Thank you so much! hope you wont get tired on answering my questions in the future til i got all my database working. Thanks again!
  14. ssecca26

    Multi Select List Box to filter Report

    how can i build a where clause? in my query?
  15. ssecca26

    Multi Select List Box to filter Report

    should i remove the source from the report?
  16. ssecca26

    Multi Select List Box to filter Report

    SELECT [Weekly Report].ID, [Weekly Report].Project_Week, [Weekly Report].Area, [Weekly Report].CP, [Weekly Report].Name, [Weekly Report].Section 1, [Weekly Report].Section 1_Details, [Weekly Report].Section 2, [Weekly Report].Section 2_Details, [Weekly Report].Section 3, [Weekly Report].Section...
  17. ssecca26

    Multi Select List Box to filter Report

    or the code which i copy from the faq? sorry im really dont know how to make this database right/work
  18. ssecca26

    Multi Select List Box to filter Report

    how can i copy it here? the query it self?
  19. ssecca26

    Multi Select List Box to filter Report

    i cannot attach the snap shot any way here it is ID Project_Week Area CP Name Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 1 262 Area 3 18 Malu 10 Days NA NA 20 Days List of Tech NA
  20. ssecca26

    Multi Select List Box to filter Report

    i already created a query before and it is working all the values and fields shows their data.

Part and Inventory Search

Back
Top