Here's a little problem that is really bugging me, I hope someone has had it before.
I'm using a data enviroment with one or more commands as the source for data reports, it all works fine until I try to set the connection string of the DEconnection and the command text of the DEcommand programatically. This generates an error "method 'item' of object 'commands' failed". If I use the on error resume next and repeat the command text it works ok - but it's not very elegant. Hope one of you gurus out there can help.