I tried using the Wizard to create the code behind a cmd button to do this; here is the code:
Private Sub cmdPNG1_Click()
On Error GoTo Err_cmdPNG1_Click
Dim stAppName As String
stAppName = "W:\MARKETNG\RICKWEST\PNG.mdb"
Call Shell(stAppName, 1)
Exit_cmdPNG1_Click:
Exit Sub
Err_cmdPNG1_Click:
MsgBox Err.Description
Resume Exit_cmdPNG1_Click
End Sub
But I get "Invalid procedure or call argument" - any hints as to what I should try next?