Handling Outgoing Calls; Handling Incoming Calls - Toshiba Strata DK40 Installation & Maintenance Manual

Handling Outgoing Calls

Using StrataLink with Access '97
Access '97 is a general development tool for producing database applications. It can be used
to create a contact management application. This application can then be used in conjunction
with StrataLink.
The production of a contact management database requires knowledge of Microsoft's Visual
Basic for Applications (VBA), Microsoft Access' exposed object model and the Jet Data
Access Object (DAO) and is beyond the scope of this document.
This application's bulletin provides ideas for linking Access '97 to the Strata DK system, but
always consult your Access manuals when customising Access for your application. This
bulletin only supplies ideas and set-up parameters to create an interface for linking the
telephone network information with the Access database. For more in-depth information on
the features, capabilities and settings for Access you should consult the supplier or
manufacturer of the software.
Handling Outgoing Calls
Telephone numbers can be stored in the database with DK Access Codes or without. If the
access code for the number is not stored with the telephone number, then the access code can
be added by the application or by Stratalink.
To have StrataLink add the access code, StrataLink Preferences must be configured from the
"Preferences" item in the "Setup" menu.
To dial the telephone number, Microsoft Access must use the StrataLink 'Dial' action. An
example of how to do this is below.
On Error GoTo Err_StrataLinkdial
lngStrataLinkChannel = Application.DDEInitiate("stratlnk", "System")
On Error GoTo 0
Application.DDEExecute lngStrataLinkChannel, "[Dial, " & """" & strtodial & """]"
Application.DDETerminate lngStrataLinkChannel
Err_StrataLinkdial:
Exit Sub

Handling Incoming Calls

Simple Cases
For simple applications, the DDE command itself can be used to perform the incoming
function. In this case either use the RunSQL DDE command or the OpenForm (with filter)
DDE command.
Stratalink ships with an example of a RunSQL action.
For OpenForm use the filter parameter to make the form go to the first record with the correct
phone number.
[OpenForm "Form Name",,,"[Contact.PhoneNumber]=&P"]
Strata DK40 I&M Manual Spring 1999
Refer to the Strata DK40 Programming Manual or DK Library CD-Rom for more details.
Computer Telephony Integration
8-53