Results 1 to 5 of 5

Thread: Making a Simple Report in VB6

  1. Mar 22nd, 2007, 01:40 AM #1
    khandu
    khandu is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2006
    Posts
    139

    Making a Simple Report in VB6

    One of my friend wants to print a report..

    Now the form contains some labels and a text box.. NONE of the data is taken from any DB.. the txt comes from another form

    so how to print that as a report / text file or straight to printer?? i don't think a complex CR is required for it..

    Some simple command can help ?? the formating has to come right

    help here..
    Reply With Quote Reply With Quote
  2. Mar 22nd, 2007, 02:29 AM #2
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Making a Simple Report in VB6

    you can use Printer.Print with Format function...consider the following example
    vb Code:
    1. Printer.Print "REPORT"

    2. Printer.Print Form1.Label1.Caption & " : " & Form1.Text1.Text

    3. Printer.Print Form1.Label2.Caption & " : " & Form1.Text2.Text

    4. '....
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    Reply With Quote Reply With Quote
  3. Mar 22nd, 2007, 04:25 AM #3
    khandu
    khandu is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2006
    Posts
    139

    Re: Making a Simple Report in VB6

    that is ok..

    but what about formating?? looking good and proper on the paper ??
    Reply With Quote Reply With Quote
  4. Mar 22nd, 2007, 09:49 AM #4
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Making a Simple Report in VB6

    You can set the font to use, the position to print the text, draw lines/circles/pictures, ...

    See our Classic VB FAQ's for a printing tutorial - it explains how to do these and more.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  6. Mar 29th, 2007, 11:55 PM #5
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Making a Simple Report in VB6

    you can use the font "Courier New" with font size "10" and padd white spaces to make it align properly...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    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