Invalid procedure call or argument error

Question

When pressing a command button the code below is executed, and it results in an error as seen in the picture

Cmd button Code:
Private Sub cmdCheck_Click()

On Error GoTo Err_Close_Jobs

Dim i As Integer 

' check in our list 

If MySel(Me!Cat) Then 

   ' already in list - remove 

   CheckItems.Remove CStr(Me!Cat) 

Else 

   ' not in the list - add it 

   CheckItems.Add Me!Cat.Value, CStr(Me!Cat) 

' Debug.Print CheckItems

End If 

Me.ckSel.Requery 

Exit_Close_Jobs:

Exit Sub 

Err_Close_Jobs:

MsgBox Err.Number & "/" & Err.Description 

Resume Exit\_Close\_Jobs 

End Sub

Code:

Public CheckItems As New Collection

Private Sub cmdCheck_Click()

On Error GoTo Err_Close_Jobs

Dim i As Integer 

' check in our list 

If MySel(Me!Cat) Then 

   ' already in list - remove 

   CheckItems.Remove CStr(Me!Cat) 

Else 

   ' not in the list - add it 

   CheckItems.Add Me!Cat.Value, CStr(Me!Cat) 

' Debug.Print CheckItems

End If 

Me.ckSel.Requery 

Exit_Close_Jobs:

Exit Sub 

Err_Close_Jobs:

MsgBox Err.Number & "/" & Err.Description 

Resume Exit\_Close\_Jobs 

End Sub

Answer 1

Hi Ahiezer,

Backup your Access file and do the following steps:

• Uncheck 'Microsoft Outlook 16.0 Object Library' if you do not use it.
• Compact and Repair Database from Database Tools tab.

This error can also occur if an attempt is made to call a procedure that isn't valid on the current platform, see below for more details:

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/invalid-procedure-call-or-argument-error-5

Finally, try to open your Access file on another computer to see if it resolves the issue.

Best Regards,

Sophia

Answer 2

I can't seem to uncheck 'Microsoft Outlook 16.0 Object Library', it displays a warning message.

Answer 3

Hi Ahiezer,

I've tried your code and it worked for me:

This might be something related to Reference Issues:

In rare cases, reference issues with external libraries can cause this error.

Try checking the references (Tools -> References).

Best Regards,

Sophia

Answer 4

What should be checked in the references?

Also, this was working just fine before. I don't know why it started showing this issue and I'm the only user with this issue.

Answer 5

Ok I unchecked 'Microsoft Outlook 16.0 Object Library' and hit compact and repair but i still get the error.

I dont get any issues opening it on another computer. Other users dont report having this issue.