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!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...
  2. MIrizarry

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

    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)...
  4. MIrizarry

    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?

Part and Inventory Search

Back
Top