473,387 Members | 1,925 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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
Jul 17 '05 #1
2 4062
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: John | last post by:
Hi I am looking into Oki ML 590 and ML 591 printers to see if any of these will work with multi-part (multiple copies) continuous stationery for printing invoices from access. Has anyone had any...
16
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use...
0
by: Bryan Bernstein | last post by:
I have an ASP.NET intranet application that uses crystal reports 9. I have three HP printers installed on the web server (windows server 2003). For the past 6 months I have had no problems with...
4
by: Russ | last post by:
To ASP.NET printing experts: My Asp.net web form needs to print some reports at the client side. I've been trying to research this and find some confusing and conflicting information in previous...
1
by: Dreamtime | last post by:
Hi I am using Visual Studio 2005 and the bundled Crystal Reports (previously I used .net 2003 and bundled Crystal Reports for 2 years - same issues!) I have a report which is displayed in the...
4
by: joel | last post by:
Is there a way (code, plugin, etc.) to output a single Access report as multiple reports? Preferrably, I want to control the output target by data in the record group. The scenario is this: We...
4
ADezii
by: ADezii | last post by:
Recently, there seems to be several questions specifically related to Printers and changing Printing characteristics for Forms and Reports. For this reason alone, I decided to dedicate this week's...
0
by: mahesh123 | last post by:
Hi Folks, I want Help regarding the Printing of the datareports in the dotMatrix. I am using the VB6.0 and developed the reports in the datareports. But my customers have a dot matrix...
18
by: Brett | last post by:
I have an ASP.NET page that displays work orders in a GridView. In that GridView is a checkbox column. When the user clicks a "Print" button, I create a report, using the .NET Framework printing...
0
by: Tim | last post by:
Our application has used this PrintersClass module for some time without a problem but some new Toughbooks have caused problems. We use laser printers, usually the default choice, and some label...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.