Click here to Skip to main content
16,004,890 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralTransfer Large Files in Client-Server Application Pin
Vasant Salian2-May-03 4:01
Vasant Salian2-May-03 4:01 
GeneralCompiling question Pin
Patricio2-May-03 3:34
Patricio2-May-03 3:34 
GeneralRe: Compiling question Pin
J. Dunlap2-May-03 7:18
J. Dunlap2-May-03 7:18 
GeneralRe: Compiling question Pin
Dave Kreskowiak8-May-03 7:07
mveDave Kreskowiak8-May-03 7:07 
GeneralRe: Compiling question Pin
RichardGrimmer12-May-03 4:42
RichardGrimmer12-May-03 4:42 
Generalcustomizing datagrid Pin
SharadGNair2-May-03 2:31
SharadGNair2-May-03 2:31 
GeneralFlexGrid rows Pin
sardinka1-May-03 6:02
sardinka1-May-03 6:02 
GeneralRe: FlexGrid rows Pin
pradipta4-May-03 23:37
pradipta4-May-03 23:37 
Try this code

Private Sub Cmdprint_Click()
'grdDetailReport(Name of the grid control)
Dim i As Integer
Dim defaultGridStyle As Integer
Dim defaultFixedGridStyle As Integer
Dim picGrid As StdPicture
Dim defaultFontsize As Single

' Initalize Variables
hl = grdDetailReport.HighLight ' Save current settings.
tr = grdDetailReport.TopRow
lc = grdDetailReport.LeftCol
X = 0
Y = 0

defaultGridStyle = grdDetailReport.GridLines
defaultFixedGridStyle = grdDetailReport.GridLinesFixed


Printer.Orientation = 2
Printer.Font.Size = 18
Printer.Font.Bold = True
'Printer.Print label1.Caption

grdDetailReport.Redraw = False

' Highlight off
grdDetailReport.HighLight = 0

Printer.Font.Size = 10
Printer.Font.Bold = False
Do Until X - grdDetailReport.Rows >= -2
X = X + 45
Y = Y + 1
Printer.Print "Page " & Y
If X > grdDetailReport.Rows - 1 Then
grdDetailReport.Row = X - 44
grdDetailReport.Col = 0
grdDetailReport.RowSel = grdDetailReport.Rows - 1
grdDetailReport.ColSel = grdDetailReport.Cols - 1

Else
grdDetailReport.Row = X - 44
grdDetailReport.Col = 0
grdDetailReport.RowSel = X
grdDetailReport.ColSel = grdDetailReport.Cols - 1
End If

For i = grdDetailReport.FixedRows To grdDetailReport.Rows - 1
If i < grdDetailReport.Row Or i > grdDetailReport.RowSel Then
grdDetailReport.RowData(i) = grdDetailReport.RowHeight(i)
grdDetailReport.RowHeight(i) = 0
End If
Next
For i = grdDetailReport.FixedCols To grdDetailReport.Cols - 1
If i < grdDetailReport.Col Or i > grdDetailReport.ColSel Then
grdDetailReport.ColData(i) = grdDetailReport.ColWidth(i)
grdDetailReport.ColWidth(i) = 0
End If
Next

' Scroll to top left corner.
grdDetailReport.TopRow = grdDetailReport.FixedRows
grdDetailReport.LeftCol = grdDetailReport.FixedCols

' Copy picture.
Clipboard.Clear
On Error Resume Next
grdDetailReport.PictureType = 0 ' Color.
Clipboard.SetData grdDetailReport.Picture

If Err <> 0 Then
grdDetailReport.PictureType = 1 ' Monochrome.
Clipboard.SetData grdDetailReport.Picture
End If

With flxGrid
Set picGrid = Clipboard.GetData(vbCFBitmap)
End With

grdDetailReport.GridLines = defaultGridStyle
grdDetailReport.GridLines = defaultFixedGridStyle
Printer.PaintPicture picGrid, Printer.CurrentX, Printer.CurrentY
Printer.NewPage
' Restore control.

For i = grdDetailReport.FixedRows To grdDetailReport.Rows - 1
If i < grdDetailReport.Row Or i > grdDetailReport.RowSel Then
grdDetailReport.RowHeight(i) = grdDetailReport.RowData(i)
End If
Next

For i = grdDetailReport.FixedCols To grdDetailReport.Cols - 1
If i < grdDetailReport.Col Or i > grdDetailReport.ColSel Then
grdDetailReport.ColWidth(i) = grdDetailReport.ColData(i)
End If
Next

grdDetailReport.TopRow = tr
grdDetailReport.LeftCol = lc

Loop

' Print commands
Printer.EndDoc

' Restore grdDetailReport
grdDetailReport.HighLight = hl
grdDetailReport.Redraw = True

End Sub
GeneralRe: FlexGrid rows Pin
sardinka6-May-03 7:30
sardinka6-May-03 7:30 
Generalkeypress event Pin
Christopher J Anderson1-May-03 5:29
Christopher J Anderson1-May-03 5:29 
GeneralRe: keypress event Pin
J. Dunlap1-May-03 6:33
J. Dunlap1-May-03 6:33 
GeneralRedirect output from a process Pin
Jachin1-May-03 3:56
Jachin1-May-03 3:56 
GeneralInstall .inf file from Visula Basic Pin
aslm1-May-03 3:56
aslm1-May-03 3:56 
GeneralReact to javascript in web browser control Pin
Jim Taylor30-Apr-03 10:40
Jim Taylor30-Apr-03 10:40 
GeneralFound the solution Pin
Jim Taylor6-May-03 9:56
Jim Taylor6-May-03 9:56 
GeneralHyperlinks, VB, and Access Pin
Anonymous30-Apr-03 6:38
Anonymous30-Apr-03 6:38 
GeneralRe: Hyperlinks, VB, and Access Pin
J. Dunlap30-Apr-03 8:35
J. Dunlap30-Apr-03 8:35 
GeneralRe: Hyperlinks, VB, and Access Pin
Anonymous30-Apr-03 8:49
Anonymous30-Apr-03 8:49 
GeneralRe: Hyperlinks, VB, and Access Pin
J. Dunlap30-Apr-03 9:07
J. Dunlap30-Apr-03 9:07 
GeneralArray Pin
sardinka30-Apr-03 6:01
sardinka30-Apr-03 6:01 
Generalu Pin
Anonymous29-Apr-03 14:35
Anonymous29-Apr-03 14:35 
GeneralRe: u Pin
Nick Seng29-Apr-03 16:00
Nick Seng29-Apr-03 16:00 
GeneralRe: u Pin
Daniel Turini30-Apr-03 6:41
Daniel Turini30-Apr-03 6:41 
GeneralRe: u Pin
Villly4-May-03 3:52
Villly4-May-03 3:52 
GeneralRefresh without erasing Pin
Zlosk29-Apr-03 11:27
Zlosk29-Apr-03 11:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.