Paypal link in Report from Form Table Invoice

[gcoaster]

Hello "thescripts" gurus!

I have threw many grueling hours/days/months created a awesome database application for my business and have learned much from this website. thank you. I am stuck on one of the last parts and wondering if anyone can offer help.

one component is invoicing

I would like to add a paypal link in report where client can just click and the link whisks them to paypal and done!

what I need is to find out if I can with vba add values from table into url.
and one value with + between each character.
in other words "project name here" would be "project+name+here"

here is the link..

https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=[e-mail]&amount=100.00&item_name=Project+Name+Here+would+Be+Cool&currency_code=USD&no_shipping=1&pbtype=general&bn
 

I need to get txtProjectName into the url here "Project+Name+Here+would+Be+Cool"

Email from field txtClientEmail here
"cmd=_xclick&business=[e-mail]&amount"

and GrandTotal into " amount=100.00 " part of the url

Is this possible?

Thank you soo very much!


gCoaster!

[PianoMan64]

Hey gCoaster,

I have one question before i can answer your question, is the report that you're sending going via email, or is it simply being sent by snapshot or some other format?

Can you let me know?

Thanks,

Joe P.