code to call an application with a field name.

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

Guest

I have two fields tnumber and lname. I want to call either MSWORD or
Notepad using tnumber+lname as the file name to open. I cannot figure how to
get WORD or notepad to see the value of tnumber+lname as the file name. Any
help.
Thanks
 
Hi,




Shell " notepad " & "c:\FileName.txt"


where FileName is the concatenation of tnumber & lname, as required, such
as:


Shell " notepad " & "c:\" & tnumber & trim(lname) & ".txt"


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top