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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by MIrizarry
-
VBA Report and Template Question
This is the code from the template: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Trim(Me.txtSortGroup) = "9" Then Me.Line (0, Me.Detail.Height)-Step(Me.Width, 0) End If Debug.Print "Report Detail" End Sub Interestingly I...- MIrizarry
- Post #7
- Forum: Microsoft: Access Reports
-
VBA Report and Template Question
I put the code in the Format event of the detail section of the report template but nothing happens when I run the job. I put in a debug.print statement but nothing was printed. Is the format event triggered if the report is used as a template? Mel- MIrizarry
- Post #5
- Forum: Microsoft: Access Reports
-
VBA Report and Template Question
I'm still a bit confused. Here's my logic flow in VBA Enter values into Form. Press button which executes the following code: Create Arrays Create Tables rpt.openreport(,Template) rpt.CreateReportControl(...Header) rpt.CreateReportControl(...Detail) rpt.CreateReportControl(...Footer)...- MIrizarry
- Post #3
- Forum: Microsoft: Access Reports
-
VBA Report and Template Question
I am creating a report entirely in VBA using a blank report as a template. I want to underline some, not all, of the detail lines based on the value of a field in the recordset. Any help on how thiscan be done?- MIrizarry
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
