Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 18th, 2005, 08:01 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default DDE problem (Access calling CC:Mail)

Has anyone come across Access error (VBA):

"Microsoft Access Error 285: The other application can't perform the DDE function or retrieval you attempted." ?

I am calling CC:Mail from Access (VBA), with the code:
Channel = DDEInitiate("wmail", "SendMail")
Application.DDEExecute Channel, "NewMessage"

attempting to create a new message within CC:Mail, on NT4.0, CC:Mail v8.5.

(this worked fine with CC:Mail 6.5! Gggrrrr... ; )

Thanks in advance!,
Jon
__________________
Jon Buckham
 
Old March 2nd, 2005, 10:02 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dust..? anyone,.? ...no? .. Dust,..? .. anyone,.? ..no?

throw me a bone here (please)!
 
Old March 4th, 2005, 10:02 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

Go back to CC:Mail 6.5? :D

Make sure all of the libraries for CC:Mail 8.5 are properly installed and registered?

Contact the CC:Mail vendor to see if they changed the DDE message? :)

Use something other than DDE to create the CC:Mail message?

Use a different email transport, like FMS Total Access Emailer?

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
 
Old March 15th, 2005, 11:34 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your reply Mr Weers,

>Go back to CC:Mail 6.5?
Wish I could!

>Make sure all of the libraries for CC:Mail 8.5 are properly installed and registered?
Check.

>Contact the CC:Mail vendor to see if they changed the DDE message?
Our software suppliers tell me there is no longer any support for CC:Mail.

>Use something other than DDE to create the CC:Mail message?
Tried using MAPI/VIM without any success. (Reinstalled Access, with MAPIVIM.DLL reference win.ini file as per online instructions).

>Use a different email transport, like FMS Total Access Emailer?
Now looking at using a hybrid of Outlook Express, although there may be issues with coexisting CC:Mail/OL Exp.

Seems to be a long winded process for something which was originally 10 lines of code!

Thanks again.
 
Old March 20th, 2005, 08:07 AM
Authorized User
 
Join Date: Mar 2005
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Isn't it a reference problem? Have you tried that?

 
Old March 21st, 2005, 08:36 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I don't think you need to include a reference in order to get DDE to work with VBA. All the code seems to be inherent. There are no compile errors - and the original solution included no reference for DDE either.

The program itself actually creates the DDE session perfectly, and on running the "NewMessage" call, creates a blank CC:Mail message as expected, then immediately bombs out.

I also noticed that on the old machine, with old (working) software, there are some entries in win.ini related to CMC, eg an entry for CMCDLLNAME. support.microsoft.com has some info/steps to take, but these seem to be aimed toward Outlook.

Can anyone shed some light on these?

Would it be any easier to use Lotus Notes?

Thanks.
 
Old March 21st, 2005, 01:05 PM
Authorized User
 
Join Date: Mar 2005
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I operate with DDEML, which is fine. (find right here:
http://msdn.microsoft.com/library/de...plications.asp)
It might take you a few hours before you apply it, but will help you to track the error. Sorry if I cannot go into that presently.

 
Old March 28th, 2005, 04:33 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the link/advice Mario - I'll look into DDEML.

Are you using DDEML with CC:Mail/VBA?
 
Old March 28th, 2005, 12:30 PM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

It sounds as if the setup for creating new mail changed from one version to the next, and you are now not feeding the program what it needs.

Have you tried using Event Viewer to see if some log entry sheds some light on what is happening?

Have you checked to see if CC:Mail is maintaining an application log that might shed some light?

Perhaps a temp file needs to be created in a location where Create permission does not exist?
Perhaps a file needs to be read where Read permission does not exist?
 
Old April 13th, 2005, 08:44 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your reply Brian,

> It sounds as if the setup for creating new mail changed from one
> version to the next, and you are now not feeding the program what
> it needs.

I've checked the syntax, refering to the CC:Mail 8.5 documentation - and I am definately feeding CC:Mail the correct information.

I couldn't find any associated log files, either :-(

As far as I know - the application doesn't create temporary files when establishing the DDE connection. Besides, I have administrator rights, so permissions shouldn't be a problem.

I'm convinced there is something in the setup of the machine causing the problem.

Mario, I have looked at DDEML, but it seems a little convoluted - and I'm not sure it'll give a solution..?

It seems that the MAPI to VIM converter might be the best way forward, short of using Outlook/OL Express!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacement for DDE mackas.net VB.NET 2 July 20th, 2010 11:39 AM
DDE Connection weirdness jjk2 Beginning VB 6 0 January 5th, 2008 06:09 AM
DDE Access -> CC:Mail inthepipe555 VB.NET 1 February 18th, 2005 08:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.