Search results

What did you have in mind?

I don't understand why it worked by you. Could it be that since the first page consists only of the group header the second page of the report is actually regarded as the first?

Will this work: Set rsUnfiltered = CurrentDb.OpenRecordset(strSQL, , dbFailOnError) rsUnfiltered .Filter = "[DateUpdated] >= " & [Forms]![frmDateRange]![txtFrom] & " AND [DateUpdated] <= " & [Forms]![frmDateRange]![txtTo]

Do you mean using a clone?

Of course I am. How else would I open the recordset? Once the recordset is open how do I filter it?

I must be missing something, does OpenRecordset hava a where clause?

Removed all code but that line, no difference. Could it be a problem with my machine?

Dim rs As DAO.Recordset Dim strSQL As String Dim rpt As Report Dim strFile As String Dim strPath As String Dim strReport As String Dim strFullPath As String DoCmd.OpenReport "rptRealGrouped", acViewPreview, , , acHidden Set rpt = Reports("rptRealGrouped")...

How do I add it to the OpenRecordset?

I'm trying to set a DAO recordset to the following query: SELECT DISTINCT Temp.ID, Temp.DateUpdated FROM (SELECT DISTINCTROW B.ID,[P].[DateUpdated] FROM (tblBuyers AS B tblApartments AS P)as Temp WHERE (([Temp].[DateUpdated]) Between ([Forms]![frmDateRange]![txtFrom]) And...

It still won't show the header on the second page. (The first page is the group header, the second one is the beginning of the actual report).

Here it is.

So what do you suggest?

Thank you. I'll get right to it.

I just put the textbox in the Detail section, and code in the Section_Detail_Format event. Private Sub Section_Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.txtRunSum = 1 Then Me.Section_PageHeader.Visible = False Else Me.Section_PageHeader.Visible =...

I changed the title of the thread (for better clarification) before any responses were made. I have a report which is grouped by a field called name. I want to hide the PAGE header on the first page of each group. I remember seeing a suggestion to create a group count using the Running Sum...

Sorry about the language if you need I can translate but it will take time. If the textbox is in the Detail section, it numbers the records and not the groups. For some reason the page header isn't visible on the first and second pages of each group.

I created the group before your suggestion. It serves it's own purpose, to have a header on top of the detail section on all pages. Is their a better way to do that?

Ok. The db is for a foreign client so data and captions of all controls are not in English. I hope that's ok. I just had a thought, the report uses a 'dummy' group section using the expression =1. Could that have anything to do with it? Anyway here's the file.

Is the 2010 format ok?