Opening up Notepad from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db that exports a resume text from an employee db to a text file
with a hard coded name and location via the TransferText Method and it works
just fine. Is there a way I can tell Access to then automatically open up
the file in Notepad so the user can preview it and change the file
name/location to one of their choosing?

Thanks
 
Search Help on "Shell". Here is the example from Help:

' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator.
 
Back
Top