技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 61
|
5#
發(fā)表于 2024-1-28 10:32:57
|
只看該作者
主窗體
Private Sub Form_Current()
Dim frm As Form, intRC As Integer
Me.Label145.Top = Me.費(fèi)用報(bào)銷單明細(xì).Top + Me.費(fèi)用報(bào)銷單明細(xì).Height
Set frm = [Form_費(fèi)用報(bào)銷單明細(xì)]
With frm
intRC = .RecordsetClone.RecordCount
If intRC <= 4 Then
Me.Label145.Top = 2830
Else
Me.Label145.Top = Me.費(fèi)用報(bào)銷單明細(xì).Top + Me.費(fèi)用報(bào)銷單明細(xì).Height
End If
End With
End Sub
子窗體
Private Sub Form_AfterInsert()
intRC = Me.RecordsetClone.RecordCount
If intRC <= 4 Then
Me.Parent!費(fèi)用報(bào)銷單明細(xì).Height = 730 + 300 * (intRC + 1)
Me.Parent!Label145.Top = Me.Parent!費(fèi)用報(bào)銷單明細(xì).Top + Me.Parent!費(fèi)用報(bào)銷單明細(xì).Height
Else
Me.Parent!費(fèi)用報(bào)銷單明細(xì).Height = 3470
Me.Parent!Label145.Top = Me.Parent!費(fèi)用報(bào)銷單明細(xì).Top + Me.Parent!費(fèi)用報(bào)銷單明細(xì).Height
'1641
End If
End Sub
Private Sub Form_Current() 'InsideHeight = 1544 這是調(diào)整子窗體高度的參數(shù)
intRC = Me.RecordsetClone.RecordCount
If intRC <= 4 Then
Me.Parent!費(fèi)用報(bào)銷單明細(xì).Height = 730 + 300 * (intRC + 1)
Me.Parent!Label145.Top = Me.Parent!費(fèi)用報(bào)銷單明細(xì).Top + Me.Parent!費(fèi)用報(bào)銷單明細(xì).Height
Else
Me.Parent!費(fèi)用報(bào)銷單明細(xì).Height = 3470 '1641
Me.Parent![Label145].Top = Me.Parent!費(fèi)用報(bào)銷單明細(xì).Top + Me.Parent!費(fèi)用報(bào)銷單明細(xì).Height
End If
End Sub
1.但是要把完整的窗體發(fā)出來才能全部弄好
2.最終要的效果圖發(fā)出來
|
|