Calling Error

[drunkenneo]

I have a database on which if i click on the call button it takes the number as it was when the opening of the database, Please help:



Private Sub Command54_Click()
On Error GoTo Err_Dial_Click

contact_number.SetFocus
Call Shell("C:\Program Files\Excel Dialer Pro\phoneex.exe", vbNormalFocus)
On Error GoTo Err_Dial_Click

Exit_Dial_Click:
Exit Sub
Err_Dial_Click:
MsgBox Err.Description
Resume Exit_Dial_Click

[June7]

I have no idea what you are doing. What is this procedure supposed to accomplish?

[drunkenneo]

June Long time...i hve been away from project

on ckicking on phone button which i have made, calls exe which needs to call for the specific person contact number, but it does not tahes any value for calling even i have setup focus on the current contact number. I am posting the db also so u can know what are other doubts left.MDB.zip

[June7]

Sorry, I don't have phoneex.exe so can't really test. However, I don't see how just setting focus to a textbox will pass phone number to the phoneex program.

[drunkenneo]

Then what way i can keep current contact number in memory, lets just not take phone exe normal calling through modem does also requires same condition. as i am not getting particular all over the forum.

[June7]

I don't know any way Access can pass a value directly to a program opened by Shell. The opened program is not an object that Access can manipulate.

Access can copy text to the Windows clipboard but I don't know how you could have phoneex automatically retrieve the text from the clipboard.

I Binged for phoneex.exe but did not get any hits.

[mrojas]

I think what you need to do is grab the phone number from wherever is it, form, table, etc. and pass this to the Phoneexe application.
Simply shifting the focus to a field is not sufficient. Do something with its value, such as store in a variable, pass this variable to your phone app.