Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Datagrid won't print

Posted on 2009-07-10
2
Medium Priority
?
249 Views
Last Modified: 2012-05-07
Below I pasted my code that I use to print my datagrid.  However, nothing is printing out.  Paper comes out blank.  Can anyone figure out why that is happening?
Private Sub PrintGrid(ctlGrid As Control)
Dim i As Integer
Dim j As Integer
Dim PTab As Integer
 
Printer.Orientation = vbPRORLandscape
 
 
   With ctlGrid
'       PTab = 35 'Set the first tab value
       
'       For j = 0 To .Columns.Count - 1
 '          .col = j 'Set the current column
       
           'Send the field to the print line and add the tab.
           'Notice the semicolon at the end of the line.
'           Printer.Print Trim$(.Columns(j).Caption); Tab(PTab);
       
 '          PTab = PTab + 30 'Increment the tab value
  '     Next
   '    Printer.Print
       
       For i = 0 To .ApproxCount - 1
       
            PTab = 20 'Set the first tab value
           
           'This checks to see if a page break is needed
           If Printer.CurrentY + Printer.TextHeight(.text) > Printer.ScaleHeight - 600 Then
               Printer.NewPage
           End If
           
           For j = 0 To .Columns.Count - 1
               .Col = j 'Set the current column
           
               'Send the field to the print line and add the tab.
               'Notice the semicolon at the end of the line.
               Printer.Print Trim$(.text); Tab(PTab);
           
               PTab = PTab + 20 'Increment the tab value
               
               
           Next
           
            
           'After each column has printed to the print line
           'a Printer.Print statement without a semicolon will
           'will send the line to the printer and start a new
           'one.
           
           
           Printer.Print
           
           On Error Resume Next
           .Row = .Row + 1 'Set the active row
           On Error GoTo 0
           
       Next i
   End With
   Printer.EndDoc
End Sub

Open in new window

0
Comment
Question by:al4629740
2 Comments
 
LVL 13

Assisted Solution

by:game-master
game-master earned 2000 total points
ID: 24837457


GOOD afternoon!

i have tried ur code and it works for me...
make sure u have set ur default printer...


game-master
0
 

Accepted Solution

by:
al4629740 earned 0 total points
ID: 24840690
Its funny.  It prints out, but nothing is on the page!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question