Hi i am trying to open notepad and command promt from access through Shell function. i tried different option but its not opening.

option for notepad.exe

Option 1)

Private Sub doexe_Click()
Dim RetVal
RetVal = Shell("C:\WINNT\NOTEPAD.EXE", 1)
End Sub

Option 2)
Private Sub doexe_Click()
Dim RetVal
RetVal = Shell("NOTEPAD.EXE", 1)
End Sub
Option 3)
Private Sub doexe_Click()
Dim RetVal
RetVal = Shell("C:\WINDOWS\NOTEPAD.EXE", 1)
End Sub

any idea, why its not working.

hi ketAccess,

If you remove the full path and just enter "notepad.exe" this should work, as effectivly, using the SHELL command
is the same as clicking Start > Run.

I have tested the following:
Which is your "Option 2" and this worked fine. Are you being given an error message?

Best Regards,
Rob