Search results for query: *

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

is not working, same problem then if statement is has error

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...

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

really is not working,,, theres no other way?

yes i paste it in the onopen event.

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

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...

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

yes correct how can i build my sql to fly?

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.

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...

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!

how can i build a where clause? in my query?

should i remove the source from the 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...

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

how can i copy it here? the query it self?

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

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