Search results for query: *

Thanks Remou.

I am trying to hide certain rows on the detail section of a report if the field value is null Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull(contact_date) And action = "" Then Me.action.Properties("Visible") = False End If End Sub but this hides the Action...

Thanks for the replies Dawn and Duane. I can not use the sorting and grouping. I am using a form to input the user parameters and use On Format of detail section to set the orderby conditions. If I use the sorting and grouping that will over ride any settings I have. I need to hide the older...

I have a report which is based on a query. Need to hide some rows based on a criteria. For eg: the query returns fld1 fld2 fld3 ABC 3/1/2005 text1 ABC 10/3/2006 text2 DFG 10/10/2005 text3 EDF 3/4/2006 text4 When fld1 has the same value I want to display the latest record( fld2...

Thank you . But I can't do that since i have lot of other parameters for the user to select in the form.

I have a report with a changing where clause for the recordsource. I am using DoCmd.OpenReport "Action", acPreview, , sqlCondition, , strfinal3 + "." & " Status: " + strfinal2 sqlCondition = " Year_entered BETWEEN 2003 AND 2004 " ( the year is input from user) The recordsourse for the...

I have a report which ahs about 3 to 6 pages depending on data selected. Right now the user has to select the next tab on bottom left to go to next page of the report( in Print preview). Is there anyway to allow scrolling in report's preview ? Thanks, Sangeetha