Help on variables

  • 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
with tnumber+lname as the filename. I cannot get the call command to see the
value of tnumber+lname. Any Help
 
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
 
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 "
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code to call an application with a field name. 1
INSERT INTO not inserting anything into anything :-( ! 1
Transaction Record 2
access - how do i print detail lines multiple times? 8
Help with this code please. 2
Assigning Field Name in continuous form from form label 2
Form won't remember last value 7
Disable selection of Text Box 5

Back
Top