The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
So, my complete moron of a teacher has once again messed up our schedule, and refuses to help us on anything. I've actually written a letter of complaint, but the deadline's in 4 days. Here's the spreadsheet:
[URL]http://www.koolpages.com/asdasta/testc.zip[/URL]
Here's what I need help on. Basically, if you could open the sheet and actually apply it, that'd be cool, but if you just wanna tell me or give any advice, that's cool too, and thanks again:
1) INPUT (MEMBER) = At the moment, you can only order one item, and it automatically appears in the OUTPUT sheet as soon as selected on the box. I want it so that they select the item, platform and quantity, and then they have to click the add to cart button, or it doesn't add to the OUTPUT sheet.
Also, I want the clear cart button to actually work, so it clears and items added to the OUTPUT sheet.
I also want a stock management system. When an item and its quantities are selected, I want it to display under "thanks for shopping here!", the stock left once it's been added to the cart - e.g. "MGS3 has 193 stock remaining." Also, it needs an auto-refill level, so that as soon as the stock drops below 50, it re-fills to 1000.
2) OUTPUT (MEMBER) = I want the output sheet to display the price of the game next to the title and quantity - e.g. You have purchased: MGS3 for the PS2 (100), for £399.99.
I want the output sheet to be able to display multiple games ordered, with multiple quantities and prices, so the there can be a total at the bottom of all of the games ordered. This might require the adjustment of the rows or columns or something.
Many thanks again to anyone who can help. I wouldn't usually ask for stuff like this, but my teacher is an incompetent of the highest order.
[URL]http://www.koolpages.com/asdasta/testc.zip[/URL]
Here's what I need help on. Basically, if you could open the sheet and actually apply it, that'd be cool, but if you just wanna tell me or give any advice, that's cool too, and thanks again:
1) INPUT (MEMBER) = At the moment, you can only order one item, and it automatically appears in the OUTPUT sheet as soon as selected on the box. I want it so that they select the item, platform and quantity, and then they have to click the add to cart button, or it doesn't add to the OUTPUT sheet.
Also, I want the clear cart button to actually work, so it clears and items added to the OUTPUT sheet.
I also want a stock management system. When an item and its quantities are selected, I want it to display under "thanks for shopping here!", the stock left once it's been added to the cart - e.g. "MGS3 has 193 stock remaining." Also, it needs an auto-refill level, so that as soon as the stock drops below 50, it re-fills to 1000.
2) OUTPUT (MEMBER) = I want the output sheet to display the price of the game next to the title and quantity - e.g. You have purchased: MGS3 for the PS2 (100), for £399.99.
I want the output sheet to be able to display multiple games ordered, with multiple quantities and prices, so the there can be a total at the bottom of all of the games ordered. This might require the adjustment of the rows or columns or something.
Many thanks again to anyone who can help. I wouldn't usually ask for stuff like this, but my teacher is an incompetent of the highest order.
Loads of people seem to get a 404 error, yet some people get it to work. It's weird.
And MM, I wouldn't usually ask, but our teacher's left us with no resources, and he's basically sent us off blind to do it.
And MM, I wouldn't usually ask, but our teacher's left us with no resources, and he's basically sent us off blind to do it.
Yeah, I'd love to do your homework...
I get a 404 on the file. Is it hosted properly?
Cheers mate. It's due in on Thursday, and I'm panicking, quite frankly.
Sorry about not being able to help you, but our class seems to be in the same situation with our Access coursework. Our teacher hasnt got a clue how to use VB and so is no help at all. I hope you get it sorted.
So, my complete moron of a teacher has once again messed up our schedule, and refuses to help us on anything. I've actually written a letter of complaint, but the deadline's in 4 days. Here's the spreadsheet:
[URL]http://www.koolpages.com/asdasta/testc.zip[/URL]
Here's what I need help on. Basically, if you could open the sheet and actually apply it, that'd be cool, but if you just wanna tell me or give any advice, that's cool too, and thanks again:
1) INPUT (MEMBER) = At the moment, you can only order one item, and it automatically appears in the OUTPUT sheet as soon as selected on the box. I want it so that they select the item, platform and quantity, and then they have to click the add to cart button, or it doesn't add to the OUTPUT sheet.
Also, I want the clear cart button to actually work, so it clears and items added to the OUTPUT sheet.
I also want a stock management system. When an item and its quantities are selected, I want it to display under "thanks for shopping here!", the stock left once it's been added to the cart - e.g. "MGS3 has 193 stock remaining." Also, it needs an auto-refill level, so that as soon as the stock drops below 50, it re-fills to 1000.
2) OUTPUT (MEMBER) = I want the output sheet to display the price of the game next to the title and quantity - e.g. You have purchased: MGS3 for the PS2 (100), for £399.99.
I want the output sheet to be able to display multiple games ordered, with multiple quantities and prices, so the there can be a total at the bottom of all of the games ordered. This might require the adjustment of the rows or columns or something.
Many thanks again to anyone who can help. I wouldn't usually ask for stuff like this, but my teacher is an incompetent of the highest order.
[URL]http://www.koolpages.com/asdasta/testc.zip[/URL]
Here's what I need help on. Basically, if you could open the sheet and actually apply it, that'd be cool, but if you just wanna tell me or give any advice, that's cool too, and thanks again:
1) INPUT (MEMBER) = At the moment, you can only order one item, and it automatically appears in the OUTPUT sheet as soon as selected on the box. I want it so that they select the item, platform and quantity, and then they have to click the add to cart button, or it doesn't add to the OUTPUT sheet.
Also, I want the clear cart button to actually work, so it clears and items added to the OUTPUT sheet.
I also want a stock management system. When an item and its quantities are selected, I want it to display under "thanks for shopping here!", the stock left once it's been added to the cart - e.g. "MGS3 has 193 stock remaining." Also, it needs an auto-refill level, so that as soon as the stock drops below 50, it re-fills to 1000.
2) OUTPUT (MEMBER) = I want the output sheet to display the price of the game next to the title and quantity - e.g. You have purchased: MGS3 for the PS2 (100), for £399.99.
I want the output sheet to be able to display multiple games ordered, with multiple quantities and prices, so the there can be a total at the bottom of all of the games ordered. This might require the adjustment of the rows or columns or something.
Many thanks again to anyone who can help. I wouldn't usually ask for stuff like this, but my teacher is an incompetent of the highest order.