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!!!
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!!!