i need help big time:S

[bobbymcsteels]

ok a bit of a noob when it come to access and not sure if this is even possible but here it goes..... I am trying to make paypal "add to basket" html, using the information i have in the datasheet I have already made without doing it 1 at a time from the paypal website. There are 1859 items i need to do this for but only need the info from 3 of the columns. eg. order code, product title, price.
If any1 can help me out with this, you will be put to the top of my xmas list


MS access 2002 and I'm running windows xp pro if this is any help.

Thanx
Bobby

 

[snakeyes2002]

eh?

r u trying to add x items into paypal?

-or-

r u trying to recreate the idea of adding items selected into a 'basket'

the first - not my field - is this legal?

the second - i would think about designing the tables and queries and forms etc then looking at update queries thereafter - could you expand a bit on your query?

 

[WayneRyan]

Bobby,

Need a whole lot more info here ...

Is it just a problem of traversing a ListBox and doing:

DoCmd.RunSQL "Insert Into Table ..."

Are you having trouble knowing which items in the ListBox are selected?
Do you know that the subscripts for the columns start at 0?

Wayne

 

[bobbymcsteels]

For example..... If Im selling a bikes and i have 10 to sell...... I have the bike order number, name, description, dimentions and price all in seperate collumns.... And i want to setup a paypal add to basket(see below for html).... is there a way to setup a template html code which will apply to all rows but automatically adds the order number, name and price???


<form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="image" src="https://www.paypal.com/en_GB/i/btn/x-click-but22.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
<input type="hidden" name="add" value="1">
<input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="business" value="myemailaddress@forbes.com">
<input type="hidden" name="item_name" value="Bike name">
<input type="hidden" name="item_number" value="bikesordernumber">
<input type="hidden" name="amount" value="15.00">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="currency_code" value="GBP">
<input type="hidden" name="lc" value="GB">
</form>