Help on variables

D

david d

I have two fields tnumber and lname. I want to call either MSWORD or Notepad
with tnumber+lname as the filename. I cannot get the call command to see the
value of tnumber+lname. Any Help
 
D

david d

Here is a sample of the code that I am trying
Call Shell("NOTEPAD.EXE TrnName", 1) in place of TrnName I want to put the
value of tnumber+lname
 
D

Douglas J. Steele

Call Shell("NOTEPAD.EXE " & tnumber + lname, 1)

If tnumber + lname will have embedded blanks, you'll need quotes around it:

Call Shell("NOTEPAD.EXE " & Chr(34) & tnumber + lname & Chr(34), 1)

Chr(34) equates to "
 
Top