By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,659 Members | 910 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,659 IT Pros & Developers. It's quick & easy.

Printing, printers, and reports

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.fontsize = 14
Printer.FontBold = 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" <kt*******@qwest.net> wrote in message
news:41***********************@news.getnet.net...
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

---
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
Jul 17 '05 #2

P: n/a
Simple Data Report without a Data Environment
http://www.veign.com/vrc_codeview.asp?type=app&id=84

Print a report of a Listview control in Report mode (high quality reports)
http://www.veign.com/vrc_codeview.asp?type=app&id=31

--
Chris Hanscom
MVP (Visual Basic)
http://www.veign.com
--

"Karl E. Taylor" <kt*******@qwest.net> wrote in message
news:41***********************@news.getnet.net...
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

Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.