[AccessD] Abstract question

Michael R Mattys mmattys at rochester.rr.com
Sun Feb 11 10:19:20 CST 2007


I forgot this part ...

'-----Module1-----
Public Function SSInit(ByRef rfrm As Form)
    Dim obj As New clsSpreadSheet
    obj.Init rfrm
End Function

Public Sub AddSpreadSheets()
    Dim frm1 As New Form_Spreadsheet
    Dim frm2 As New Form_Spreadsheet
    Dim frm3 As New Form_Spreadsheet
    With frm1
        .Visible = True
        DoCmd.MoveSize , 0
    End With
    With frm2
        .Visible = True
        DoCmd.MoveSize , 500
    End With
    With frm3
        .Visible = True
        DoCmd.MoveSize , 1000
    End With
End Sub

Sub OpenSpreadSheets(NumberOfSS As Integer)
    Dim i As Integer, f As Form, h As Long, r As Integer, d As Integer, M As 
Integer
    r = 100
    For i = 1 To NumberOfSS
        r = r + 500
        Set f = New Form_Spreadsheet
        With f
            d = M + f.Section(0).Properties("Height")
            .Caption = .Name & i
            .Visible = True
            h = .hwnd
            DoCmd.MoveSize , d
        End With
        d = d + d
    Next
End Sub

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com 




More information about the AccessD mailing list