Search code examples
listviewms-accessvb6runtime-error

Arguments not optional in VB6


Why am I getting this error?

    Private Sub loadEmployee()
    With frmEmployee.lvEmployee.ListItems
    Call connect
    'SQL = "SELECT * FROM tblemployee "
    Rs.Open "SELECT * FROM tblemployee ", Conn, adOpenDynamic, adLockOptimistic
      If Not Rs.EOF Then
        Rs.MoveLast
        Set Item = lvEmployee.ListItems.Add(1, , Rs!id)
            Item.SubItems(2) = Rs!firstname
            'Item.SubItems(2) = Rs!middlename
            Item.SubItems(3) = Rs!lastname
            Item.SubItems(4) = Rs!agename
            Item.SubItems(5) = Rs!gender
            Item.SubItems(6) = Rs!address
            Item.SubItems(7) = Rs!datehired
            Item.SubItems(8) = Rs!birthdate
            Item.SubItems(9) = Rs!birthplace
            Item.SubItems(10) = Rs!citizenship
            Item.SubItems(11) = Rs!cellno
            Item.SubItems(12) = Rs!Status
            Item.SubItems(13) = Rs!basicsalary
            Item.SubItems(14) = Rs!designation
            Item.SubItems(15) = Rs!department
            'Item.SubItems(16) = Rs!m_name
            'Item.SubItems(17) = Rs!m_occupation
            'Item.SubItems(18) = Rs!n_spouse
            'Item.SubItems(19) = Rs!dependents
            'Item.SubItems(20) = Rs!SSS
            'Item.SubItems(21) = Rs!PHILHEALTH
            'Item.SubItems(22) = Rs!PAGIBIG
            Item.EnsureVisible
      End If
      Rs.Close
      Conn.Close
      Set Conn = Nothing
     End With
    End Sub

ERROR: Arguments not optional

This error comes when I call the function. I called it like this:

Private Sub Form_Load()
loadEmployee
End Sub

"Private sub..." is highlighted yellow, and "Item=" is highlighted blue.

How do I fix this?


Solution

  • Did you declare the Item?

    Try declaring:

    Dim Item as listitems