473,405 Members | 2,310 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,405 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 4066
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.