By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Paypal link in Report from Form Table Invoice

gcoaster
P: 91
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..

Expand|Select|Wrap|Line Numbers
  1. https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=email@email.com&amount=100.00&item_name=Project+Name+Here+would+Be+Cool&currency_code=USD&no_shipping=1&pbtype=general&bn
  2.  
I need to get txtProjectName into the url here "Project+Name+Here+would+Be+Cool"

Email from field txtClientEmail here
"cmd=_xclick&business=email@email.com&amount"

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

Is this possible?

Thank you soo very much!


gCoaster!
Dec 13 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
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.
Jan 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.