WhoCalls support forum    


Welcome to the WhoCalls support forum.
Before entering a query/request please search the forum to see if someone else has asked the question before.
Please feel also free to respond to queries from other users if you have experienced the same type of problem and found a solution to it. 
Our support team will monitor this forum and endeavour to provide answers to the queries posted.
Please make sure to post your query to the right forum as there is a separate forum for each application provided by MAW Software.
Show messages for: Last 7 days Last 30 days All (Digest of all)

Back to the forum

On Tuesday , the 08.17.2010, MAW Support wrote at 08:36:44 :

>DDE and missing fields

Hi Kydo

DDE should only be used for older systems.
For newer systems you should use a VBS script to call MsAcces through ActiveX.
Please find below a VBS that works with MsAccess.
Just create a MsAcces DB C:\CallLog.mdb and there a table T_Calls with the string fields
Date, Time, CallerID, CallerName and Port
The create a new enty in WhoCalls, call it "VBS for MsAccess" and paste the code below.

Rds
TL

>>
Dim AccApp, dbs, rst
Dim Result

Set AccApp= CreateObject("Access.Application")
AccApp.OpenCurrentDatabase("C:\CallLog.mdb")

Set dbs = AccApp.CurrentDb

Set rst = dbs.OpenTable("T_Calls")
rst.AddNew

rst.Date ="@DATE" 'Set Time
rst.Time ="@TIME" 'Set Date
rst.CallerID ="@CID" 'Set CallerID
rst.CallerName ="@CIN" 'Set CallerID Name
rst.Port ="@PORT" 'Set Port

rst.Update

'Clean up
rst.Close
dbs.Close
set rst = Nothing
set dbs = Nothing
AccApp.Quit
set AccApp = Nothing






Post reply:

Name:
E-Mail:
Subject:
Message:
SPAM code displayed
next to this:

CGIForum (C) Markus Triska

Home to