Results 1 to 2 of 2

Thread: VB6 data report

  1. Feb 14th, 2008, 07:56 AM #1
    LostAngel
    LostAngel is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2003
    Posts
    419

    VB6 data report

    Hello, I have a report pulling data from access. The data is put in the detail field. Is it possible to get more than one record of data on one detail line at a time? I have an 8.5x11 sheet of paper with labels on it...and would like to fill each label...not just down the left side of the sheet.
    Code:
    If LostAngel.Tag = "Programming" then
   LostAngel.Caption = "Awake"
Else
   LostAngel.Caption = "Dreaming of Code"
End If
    Reply With Quote Reply With Quote
  2. Feb 14th, 2008, 03:01 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: VB6 data report

    The DataReport is pretty limited and printing multiple records in a section is not supported.

    What you need to do is create a recordset that contains the same fields X number of times. For example, if you have 3 labels per row the recordset fields could be

    Address1, City1, State1, Address2, City2, State2, Address3, City3, State3

    I don't know the sql statement to generate such a recordset. I would use an in-memory recordset and populate it manually. The in-memory recordset would be the data source for the report.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width