DDE function in ControlSource property: error !!!

snorkyller

New member
Local time
Today, 17:17
Joined
Jul 6, 2001
Messages
7
I have problem in using a DDE communication between an Access97 database and a another application (insql server or something else: it does not matter...).

I want to use the DDE function that you can put into the ControlSource property of a textbox:

DDE(application, topic, item)

So, this textbox is suppose to take his value by the result of the DDE function...

I tried first with a Excel sheet by putting the following in the textbox ControlSource property:
=DDE("Excel","Sheet1","R1C1")
The Excel application (with a sheet name "Sheet1") is open when i put this DDE function but I got a message error which tell me that there's a syntax error.
But I'm sure that the syntax is correct because if I try with the sames string in VB by the LinkTopic and LinkItem property:

LinkTopic=Excel|Sheet1
LinkItem=R1C1

It work!!!

I also tryied to communicate with an another Access97 Database with the following DDE function:
=DDE("MSACCESS","DB.mdb;SQL SELECT Field1 FROM Table1;","Data")

But I got the same syntax error message

Again, it work in VB if when I set a textbos like this!!!:

LinkTopic=MSACCESS|DB.mdb;SQL SELECT Field1 FROM Table1;
LinkItem=Data

SO, CAN SOMEONE TELL ME WHAT IS THE PROBLEM WITH THE DDE FUNCTION OF ACCESS97 ?????? PLEASE!!!
 

Users who are viewing this thread

Back
Top Bottom