467,858 Members | 1,699 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,858 developers. It's quick & easy.

Paypal link in Report from Form Table Invoice

gcoaster
100+
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
  • viewed: 1696
Share:
1 Reply
Expert 256MB
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.

Similar topics

2 posts views Thread by gleave | last post: by
reply views Thread by PayPal Security Measures! | last post: by
3 posts views Thread by ykhamitkar | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.