Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sending command to Access using DDE

Status
Not open for further replies.
elziko

elziko

Programmer
Nov 7, 2000
486
GB
I have a command in Access inside a module which works just fine:

DoCmd.OpenForm "Section38 Current", acNormal, "", "[Section38 Current]![Road Name Rd1]=""Oberon Road""", , acNormal

I then write the correct code to send the same as a DDE command as a string:

"[OpenForm "Section38 Current", acNormal, "", "[Section38 Current]![Road Name Rd1]=""Oberon Road""", , acNormal]"

which doesnt work and gives a "Foreign Application Wont Perform DDE Method Or operation" error in the application that issues the DDE command. (Visual Basic 5 app that I'm TRYING to write). I'm definitely innitiating the dde conversation correctly because I'm able to run macros and do other things.

Thanks for ANY help

elziko
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
656
strongm
strongm
sal21
  • Locked
  • Question
ARRANGE this Access coe to vb6
Replies
4
Views
290
strongm
strongm
IcarusHallsorts
  • Locked
  • Question
Sending bulk emails with Outlook365
Replies
1
Views
518
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
how to send SMS via free API or other service
Replies
2
Views
386
strongm
strongm
Andrzejek
  • Locked
  • Question
Graphical command button 2
Replies
2
Views
188
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top