Search results

Thank you so much. I've been trying for days.

I attached an updated database (database16) and it works as intended with the records it has. Once I add more groups i get that error database16-error).

This mess is what i got so far.

Sorry, that was for the report that was not grouped. After I posted the database i was using another vba. Ill update another database with what i got so far.

I'm cant win... I modified the table and form to accommodate an extra column a numeric Group. I got it working on my test database but now when i transfer the new report/vba i get the following error. "Run-time error '2176': The setting for this property is too long." I'm guessing that the new...

😫😩Getting Closer. I figured out that my issue is with the HashID. My HashID is short text and the sample i found has a Group ID that is numeric.

Hello, I found another sample but now im getting just the "blanks" but not the stored data. o_O Option Compare Database Option Explicit Dim lngI As Long Dim lngForeColor As Long Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) lngI = lngI + 1 If Me!HashID Like...

Attached is a sample of the form I'm trying to add blank lines to. Report ranges between 1 to 4 pages, with approximately 400 users (different groups). I found a couple more samples from arnelgp but all i can manage to do is add blank lines on an empty report. Thanks for your time.

Hello AccessWorld. I found a post by arnelgp (AddBlankLinesInReport.accdb) that helped me add blank rows to complete a report. I was able to use the report when printing a single person's report. However, now I am now trying to use the same code but in a grouped report. I've tried but have...

I would like to thank everyone in the forum. You guys make work easier and faster.