Printing, printers, and reports

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Karl E. Taylor

    Printing, printers, and reports

    Could someone point me in the direction of a good example of coding
    report printing from database tables through VB?

    I have 5 tables that I need to run a report from. They are actually
    very small, 1 - 8 columns wide, containing from 1 - 24 records in each
    table. So by my estimation, the whole database, should print to a
    single sheet of paper, if formated properly.

    Problem is, in all the VB5, 6 books and tutorial sites that I've got or
    visited, I can't find one, ONE, good example of printing, anywhere. Oh
    sure, lots of stuff on the Printer Dialog object and what knot, but not
    on what to do after you've got it.

    Please, someone, point me in a direction, before I have no hair left? I
    do admit, as you can see below, that I am new to this language, but I do
    want to learn it, and learn it well. Any help is appreciated.

    Thanks.
    --
    Dr. Karl E. Taylor

    Unix Systems Administrator / Oracle DBA
  • Hal Rosser

    #2
    Re: Printing, printers, and reports

    Look in the object browser - at the printer.
    the printer has methods and properties
    Printer.print "Hello Wrold" '**for instance
    Printer CurrentX and CurrentY sets the 'cursor' anywhere on the page
    printer.fontsiz e = 14
    Printer.FontBol d = True
    these are sample lines which may give you a clue....
    The printer object is the key - once you play with it awhile you'll be able
    to
    do reports with ease.


    "Karl E. Taylor" <ktayloraz@qwes t.net> wrote in message
    news:413b3f53$0 $99883$4c5eba9e @news.getnet.ne t...[color=blue]
    > Could someone point me in the direction of a good example of coding
    > report printing from database tables through VB?
    >
    > I have 5 tables that I need to run a report from. They are actually
    > very small, 1 - 8 columns wide, containing from 1 - 24 records in each
    > table. So by my estimation, the whole database, should print to a
    > single sheet of paper, if formated properly.
    >
    > Problem is, in all the VB5, 6 books and tutorial sites that I've got or
    > visited, I can't find one, ONE, good example of printing, anywhere. Oh
    > sure, lots of stuff on the Printer Dialog object and what knot, but not
    > on what to do after you've got it.
    >
    > Please, someone, point me in a direction, before I have no hair left? I
    > do admit, as you can see below, that I am new to this language, but I do
    > want to learn it, and learn it well. Any help is appreciated.
    >
    > Thanks.
    > --
    > Dr. Karl E. Taylor
    >
    > Unix Systems Administrator / Oracle DBA[/color]


    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.752 / Virus Database: 503 - Release Date: 9/3/2004


    Comment

    • Veign

      #3
      Re: Printing, printers, and reports

      Simple Data Report without a Data Environment


      Print a report of a Listview control in Report mode (high quality reports)


      --
      Chris Hanscom
      MVP (Visual Basic)
      Veign, Columbia. 118 likes. A South Carolina development company whose primary focus is to leverage the power of machine learning to better understand your data. From image and object detection to...

      --

      "Karl E. Taylor" <ktayloraz@qwes t.net> wrote in message
      news:413b3f53$0 $99883$4c5eba9e @news.getnet.ne t...[color=blue]
      > Could someone point me in the direction of a good example of coding
      > report printing from database tables through VB?
      >
      > I have 5 tables that I need to run a report from. They are actually
      > very small, 1 - 8 columns wide, containing from 1 - 24 records in each
      > table. So by my estimation, the whole database, should print to a
      > single sheet of paper, if formated properly.
      >
      > Problem is, in all the VB5, 6 books and tutorial sites that I've got or
      > visited, I can't find one, ONE, good example of printing, anywhere. Oh
      > sure, lots of stuff on the Printer Dialog object and what knot, but not
      > on what to do after you've got it.
      >
      > Please, someone, point me in a direction, before I have no hair left? I
      > do admit, as you can see below, that I am new to this language, but I do
      > want to learn it, and learn it well. Any help is appreciated.
      >
      > Thanks.
      > --
      > Dr. Karl E. Taylor
      >
      > Unix Systems Administrator / Oracle DBA[/color]


      Comment

      Working...