Show Bid Request
final project adv vb
Bid Request Id: 50974
|
|
|
|
Posted by: |
Casper23 (10 ratings)
(Software buyer rating 8.9 )
|
|
Non-action Ratio: |
Very Good - 10.00%
|
|
Posted: |
Mar 3, 2003
11:05:41 AM EDT
|
|
Bidding Closes: |
Mar 8, 2003
11:14:33 AM EDT
|
|
Viewed (by coders): |
261 times
|
|
Deadline: |
3/9/2003
TIME EXPIRED
|
|
|
|
|
Description:
Final Project Specifications
You will be designing and developing a simple Order form for Water Sports, Inc. a company that sells a small line of handcrafted water sports equipment.
1)Create an Access database with one table as follows:
Table Name: Product
Field Name DataType Size
ProductID integer n/a
Description text 20
ItemPrice currency n/a
Add 5 rows to the table as follows:
ProductID Description ItemPrice
1 single kayak 300
2 double kayak 400
3 canoe 250
4 paddles 75
5 life vest 50
2)Design and code the Order form as follows:
Note: the screen shot is just a guideline - you can come up with your own (better) design.
Add three text boxes to the form corresponding to each of the three fields in the Product table. Add a fourth text box into which the user can enter a number which is the quantity of each item he wishes to purchase.
Add two command buttons which are used to scroll through all 5 rows in the table. (The buttons should have ‘Next Item&' and ‘Previous Item&' as text.).
When the user finds an item he wants and enters a quantity, he clicks the Buy button.
The code for the Buy button should write information to 2 arrays. The description should go into a string array, and the purchase price should go into a currency array. (These are each one-dimensional arrays). The purchase price should be ItemPrice times Quantity). The user can buy as many items as desired.
When the Items Purchased button is clicked, read from the 2 arrays and display the information in a list box.
For example:
Single Kayak, 600
Paddles, 75
Canoe, 500
This list box just shows us what&'s been ordered and how much we&'re spending.
Finally, when the user clicks the Order Total button:
Figure out the order total (I would get this information from the array, not the list box if I were you ) and if it is $1000 or greater, give the customer a 10% discount. If the order total is $3000 or greater, give the customer a 15% discount.
Then you need to get the user to tell you what state he lives in so you can figure out the sales tax. Do this any way you wish.
Here are the sales tax rates:
MA - 5%
CT - 6%
RI - 7%
VT - 5%
All other states - 0%
Add in the sales tax amount and display the result.
Proper use of the ADO control, arrays, looping, scope of variables, and basic programming logic and skills is important.
Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
Platform:
vb 6
Must be 100% finished and received by buyer on:
Mar 9, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$12 (USD)
|
Mar 4, 2003
4:22:25 AM EDT
|
10
(Excellent)
|
|
|
Hello,
We specialize in Visual Basic Applications.
We have gone through your requirements and have made a demo.
If you want we can add more functionality to it.
We can send you the code within 1 day after our bid is accepted.
Looking forward for a positive reply.
Thanks,
Vinay,
GSS.
|
|
|
Attached File
|
|
|
|
|
|
