Access-form as DDE client

  • Thread starter Thread starter Klaus Spithost
  • Start date Start date
K

Klaus Spithost

I'm trying to get a textbox on a Access 2000 form as a DDE-
client for a DDE-serverprogram that had a hot-link running.
It's a Caller-ID program that makes available the number
and name as two DDE-"variables" available to DDE-clients.
It's no problem to get the (changing) data visible in
Excel 2000 the way it's supposed to.
Here I paste: '=CAPIMONITOR|ddecapimonitorserver!
ddenummer' into a cell and immidiately the number appears.

In Access it SHOULD be very easy as well. Create a form,
create a textbox on it and set the controlproperty to: =DDE
("CAPIMONITOR","ddecapimonitorserver","ddenummer") and
save the form.
Then open the form and the data SHOULD appear. But it
doesn't. I tried "fighting" with the example in the help-
file with the setup to an Excel spreadsheet to make
visible the content of the cell R1C1 from Sheet1 in Excel.
(I had to use some other strings because of the Dutch
version but that shouldn't matter. There I've got the same
results i.e. it doesn't work.
If this example DOES work with others it COULD be because
I use a Dutch version of Office 2000 but then why does the
DDE-client in Excel pick up the data....
I tried putting the program-name in lower instead of caps
but that didn't work as well.

Does anyone have any suggestions? Please reply. Bye,
 
Basically you cannot DDE to a form:

As a DDE server, Microsoft Access supports the following topics:
a.. The System topic
b.. The name of a database (database topic)
c.. The name of a table (tablename topic)
d.. The name of a query (queryname topic)
e.. A Microsoft Access SQL string (sqlstring topic)


If you do the DDE to a table, make sure the Settinsg allows DDE requests as
there is a setting to ignore them.


Best of luck
 
Back
Top