Code:
Code:
Public Sub AddItem(ByVal Item As Variant, ArrDim As Variant) ReDim Preserve ItemArray(0 To lCount, 6) ItemArray(lCount, ArrDim) = Item
Public Sub AddItem(ByVal Item As Variant, ArrDim As Variant) ReDim Preserve ItemArray(0 To lCount, 6) ItemArray(lCount, ArrDim) = Item
• Sql = "Select * from tblTableName where SearchField
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer) If Len(Text1.Text) < 1 Or Combo1.ListIndex = -1 Then MsgBox "Please
Dim oFrm as Form For Each oFrm in Forms msgbox oFrm.Name Next oFrm
Leave a comment: