Ado and Expression, How to "marry" them....

[dominicgingras]

I have an ADO piece of code that take the date from data from a table and export it to outlook contact on a public folder.

My problem is the following:

I want to take 3 fields from my table and merge then into one to export to the body part of an outlook contact. Usualy, in a query, I use the expression builder([XXXX]& &[yyyy]. How would you acheive the same result using ADO. I have try to base my recorset on a query that contain expresion and I got an error message.

I dont know If this is clear, my english is not perfect....


Dominic Gingras

 

[Darrylles]

Hiya,

In VBA, you would use:

x = form1!txtX
y = form1!txtY
z = form1!txtZ

W = x + y + z

If W was defined as a string, then W would be a concatenated string of characters.
If W was a number (and x,y and z were defined as numbers) then W would be an addition of those numbers.

If any of W,x,y or z were different types then there would be an error.

Are you sure that the table 'types' are correct?

Regards,

Darrylle




"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[dominicgingras]

Thank you!!!

 

[Darrylles]

That's why I do this - that thankyou with maybe one exclamation mark - but 3!

(We still hold our breath for the ....ah but.... response, lol).

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."