Quote:


Your code above did not provide for the spacee.

Vreturn = @shell(@chr(34) + "C:\Program Files\sesame\utilities\dialer.exe" + @Chr(34) + Home)

is missing a space, it should be

Vreturn = @shell(@chr(34) + "C:\Program Files\sesame\utilities\dialer.exe" + @Chr(34) + " " + Home)

Renaming the Dial.exe to Dialer.exe could be the part of the problem, since Dial.exe works through the Dialer.exe, it might be pointing to the same executable file.

Bharat -

I do not think that renaming Dial.exe to Dialer.exe presented any problem because as I said, for certain area codes it was working just fine.

Nevertheless your thoughts about it make perfectly good sense and I have gone ahead and renamed it back to Dial.exe (and, of course, changed my programming accordingly).

Something is really 'funny' about the 'space' issue.  I never had it in the portion of code for dialing area codes (813) and (727) and it presented no problem.

So naturally, I simply 'copied' that portion of the code to the portion for all other area codes. For some reason (unclear to me - but that doesn't matter), it does need the space when adding the '1' to the number .... so I put it in (but only for long distance calls).

And, guess what?
                                 

So,  BLESS YOU, BLESS YOU, BLESS YOU!!!!

Now, I can hardly wait to try your other suggested code for being able to dial the number using the focused element.  Guess what I am going to do .....

lol

Thanks, so much for all the help.  Will be back later (I hope) with my 'final' code.

Spencer:

You may be setting yourself up for a future problem, or a problem on another system by renaming dial.exe to dialer.exe.

I don't remember the source, but I seem to recall being cautioned about that very thing.  Appareantly Windows (some versions?) include dialer.exe as a normal file.  Many modem packages will remove the file named dialer, and replace it with its own.

I would suggest that before you rename dial.exe to dialer.exe, that:
1.  If it exists, make a copy of existing dialer.exe as win_dialer.exe.
2.  Keep another copy of your dial.exe, maybe a copy as my_dialer.exe.

That way, if you need to install/update some modem/fax drivers/files, if they delete dialer.exe you will have a copy of the file you need readily available.

------------------------------------------------------
I am curious, why bother to rename dial.exe at all?  Why not keep it as that name?

Bharat -

I am:     ECSTATIC!!!!

You have absolutely come up with THE definitive solution I was looking for.   As most people can tell from the previous posts, I have been playing with this for the past couple of weeks and for the past couple of days have worked on practically nothing but this.  What is ironic, is that the solution is extremely simple, the programming code is minimal and the results are phenomenal.

To summarize, here's what I did and here's my 'final' code.

First, I downloaded Dial.exe from the link you provided as  [url]http://www.pcplus.co.uk/tips/default.asp?pagetypeid=2&articleid=5545 &subsectionid=390 [/url] and I installed it in the Utilities folder of my Sesame program files.  (It still 'bugs' me because I know that this utility is included in Windows XP and I just don't know how to access it).

Before I provide the code, please remember that I have six separate phone fields. Here, see for yourself:



Also, while most people need to dial local numbers without an area code and long-distance prefixed with 1, I had one additional need.  When I call St. Petersburg (727) I have to dial the area code but cannot use the 1 prefix.  (This seems to be coming more common for 'regional' call dialing).

Based on your suggested code which you posted in another section of the forum ...  http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display... ....
I simply placed the following code in my global code element:

var vPhonenumber as String

Subroutine DialPhone ( )
var VSuccess as Int
var vAreacode as string = "813"
var vName as String = Mail Name  
var vPath as String = "C:\program files\sesame\utilities\"  
  
  
vPhonenumber = @num (vPhonenumber)
  
If @len (vPhonenumber) = 10 then
 {
  If @left (vPhonenumber, 3) = vAreacode then
  {  
   vPhonenumber = @Right (vPhonenumber, 7)
  }
  Else
  If @left (vPhonenumber, 3) = "727" then
  {  
   vPhonenumber = (vPhonenumber)
  }
  Else
  {
   vphonenumber = 1 + vPhonenumber
  }
 }
  
vsuccess = @Shell(@Chr(34) + vPath + "dial.exe" + @Chr(34) + " " + vPhonenumber  + " [" + vName +"]")  
  
If not vSuccess = 0 then
 {
  @msgbox ("Problem!!! Dialer did not work.", "", "")
  
 }  
end subroutine  

Next, I placed the - incredibly simple and consistent code - in each of my six phone field elements in the On Element Entry event:

vPhonenumber = ThisElement 

The last thing I did was  place the following code in the Command Button (Place Call) in the On Element Entry event:

DialPhone ( ) 

That's it - that's all there is to it.  Now, all I have to do to dial a call is click on the appropriate phone number (any one of the six) and click on Place Call.  The call is placed and here's what I get:



I simply wait until I hear the modem dialing, pick up the receiver, and click on 'disconnect' and both of the extra windows disappear.  (As an aside, I always thought that 'disconnect' was a poor choice of words, because I thought that if I clicked on it, I would disconnect the call. All you are disconnecting is the MODEM, so that you don't get background noise).

This works EXACTLY as it worked in MS Access so I am both familiar and very comfortabale with it.

As I said before, thanks to Bharat, we now have the definitive answer (in my opinion, anyhow) to the issue of having a phone dialer in Sesame.

BRAVO!!!!!

Hi -

Well, it turns out that it was my modem after all.  A new modem did the trick.

Now, however, my programming is not working in any of my databases, both old and those I converted.

I'll give Ray a call and hope that he'll have "mercy."  

And if someone could tell me how I could properly "thank" Ray - other than just in words - I would really appreciate it.

I was on the phone yesterday with MicroSoft for at least 4 hours and I got absolutely nowhere.

Within a very short time, Ray figured it out, solved it, and got me up and running.  We are truly lucky to have him.  I'm so happy to have my dialer back that I'm calling people "just for the heck of it."  lol

BOBSCOTT wrote on Jul 13^th, 2007 at 5:24am:




Robert if I recieve a Frank Zappa CD I'm gonna cut you off from support. 

-Ray