So what are the undocumented SysCmd items?
In my previous posting I linked to Undocumented SysCmd Functions. So I was curious and created my own code to go through the various SysCmds. I came up with the following code.
Sub FindSysCmds()
Dim ReturnCode As Variant, i As Long
On Error GoTo tagError
' 1 through 13 are document in A2003
For i = 14 To 1024
' The following caused A2003 to crash
If i = 602 Or i = 605 Or i = 606 Then _
GoTo tagNextLoop
ReturnCode = SysCmd(i)
Debug.Print i & " " & ReturnCode
tagResume:
If i > 605 Then
' Stop
' If i Mod 10 = 0 Then _
' MsgBox i
End If
tagNextLoop:
Next i
Exit Sub
tagError:
Select Case Err.Number
Case 2439 ' The expression you entered has a function containing the wrong numb
Debug.Print i & " - wrong number of arguments."
Resume tagResume
Case 7952 ' You made an illegal function call.
Resume tagResume
Case Else
Stop
End Select
Resume Next
End Sub
This code returned the following items.
14 - wrong number of arguments.
555
603 - wrong number of arguments.
604 - wrong number of arguments.
607 252
609 5912
610 - wrong number of arguments.
611 - wrong number of arguments.
612 - wrong number of arguments.
701 - wrong number of arguments.
710 0
711 67699721
713 - wrong number of arguments.
714 True
715 6566
Most of those are on Wayne's list. A few aren't such as 14 and 713. And his list hasn't been updated as a few on his list appear to not work in Access 2003.
Now I'm sure the folks at Microsoft are going to see the crash reports regarding codes 602, 605 and 606. And I suspect a few on the Access team follow my blog. So it'll be interesting to see if I get any comments.
Anyhow I don't have the time today to continue this research on what syscmd(14) does or which crash or don't crash in other versions of Access.