Same url-different text

[diegomarino]

thanks you very much vlad.


The real problem are letters like "à" and "ò" and some more.
Check the two queriesso you can see that the url in "messages" has the correct letters (à,ò) but the "connections" has not. i deleted every guy except the problematic one (there are more)

because of that i was thinking to extract the name-surname in connections (that is the same of "to" in messages) and add the last part of url is there is one

[Info@MsAccess.nl]

Do you open a private tab with vba code?

[Gicu]

Hi Diego,
Please review it now, I have added two versions of URL encode\decode functions in a new module and used that to decode the extracted URL_ID in qryConnections1 query.
Cheers,

[diegomarino]

thank you very much vlad, it is was i expected.
so it's needed to make a function to decode an url, it's a really good one. I don't even need more to extract the URL_ID, cause the url decodified is good as it is. thanks

[Gicu]