Modify ASP/Access Project .. UPDATED!

Completed Posted Feb 4, 2005 Paid on delivery
Completed Paid on delivery

Hello - I have posted this project before and have now updated the description to be more clear. Also, the current code and database with junk data is included.

This is an ASP/Access project. The current system is running and works fine, but needs a few added features.

The basic system is a method for two people, one in Japan and one in the UK, to share information about items that are bought in Japan and sold in the UK. The current system tracks the items from the point that they are bought through transit to the uk through sale in the UK. It is very straight forward.

I have already modified the MS-Access database for the code modifications for you to do. What you need to do is to write the code to:

1. Support Item "Categories." There is a simple item categories table. You do not need to add an add/edit category screen--this does not change often, so I am happy to edit this manually in Access. What you need to do is to add the ability for the item category to be selected when it is put into the system and then, on the "view unsold in UK" and "view sold items" screens for the views to be sorted / filtered by category. very simple, actually.

2. Better support customers. Currently we only have one line for "Sale" (Sale Info). This is to be replaced with a customer record. To accomplish this, I have put in a Customers table with all the standard info (name, email, etc). Your job is to make this work - both allow us to specify a customer (perhaps from a pop-up window or something--a drop-down would have too many names) when an item is sold and also provide a customer management screen allowing us to add/edit customer data, see the full record for what a customer has purchased, and so forth. Again, this is very straightforward if you look at the DB.

(CONTINUED BELOW)

## Deliverables

3. Support for "Requested Items." Occasionally a customer requests something from Japan from us. You will need to add screens to support this. Basically, what this means is adding a screen called "Add new Requested Item" where a customer and item are selected. Then, when the requested item is found in Japan, it is entered into the system there and tracked as it makes its way to the UK. Again, please look at the database/existing code and you should see that this is quite straightforward

Basically you are adding support in for the tables in the database: CUSTOMERS, CATEGORIES, and REQUESTEDITEMS.

You may need to add some menu items to do #1, #2 ,and #3.

All the work is in ASP/Access. Work to be completed within one week. If you have questions, please ask! I am here to help and know the code!

You can do the work on your own development server / PWS. I expect the code back. The data you are getting is junk, so that can be ignored. Once it works on your junk data, we will migrate it to the real thing.

Thank you for your work!

1. .asp files, working as per spec.

2. all the code, data, and database structure belongs to me. You must delete it after you are finished with it.

3. all communication must be via RAC.

## Platform

1. ASP (classic) + MS-Access

ASP Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #3550785

About the project

21 proposals Remote project Active Feb 10, 2005

Awarded to:

tempor2001

See private message.

$34 USD in 17 days
(13 Reviews)
3.8

21 freelancers are bidding on average $35 for this job

icodeinvb

See private message.

$42.5 USD in 17 days
(316 Reviews)
7.1
amadel

See private message.

$25.5 USD in 17 days
(170 Reviews)
5.5
baylisssoftware

See private message.

$42.5 USD in 17 days
(13 Reviews)
4.3
ItIndia20c

See private message.

$42.5 USD in 17 days
(9 Reviews)
4.1
mohamedelzahaby

See private message.

$25.5 USD in 17 days
(22 Reviews)
4.4
navimel

See private message.

$42.5 USD in 17 days
(6 Reviews)
3.9
donofdons

See private message.

$42.5 USD in 17 days
(13 Reviews)
3.4
faisy2

See private message.

$17 USD in 17 days
(16 Reviews)
3.1
mullai

See private message.

$34 USD in 17 days
(8 Reviews)
2.4
webmeachines

See private message.

$40.8 USD in 17 days
(5 Reviews)
2.2
muraliaruna

See private message.

$29.75 USD in 17 days
(2 Reviews)
0.9
ismatvw

See private message.

$42.5 USD in 17 days
(2 Reviews)
0.8
codepundit

See private message.

$34 USD in 17 days
(2 Reviews)
0.3
toitemoie

See private message.

$8.5 USD in 17 days
(1 Review)
0.0
vw1450757vw

See private message.

$25.5 USD in 17 days
(1 Review)
0.0
ianrossi

See private message.

$34 USD in 17 days
(0 Reviews)
2.7
anonapps

See private message.

$42.5 USD in 17 days
(0 Reviews)
0.0
ashokkumarvw

See private message.

$34 USD in 17 days
(0 Reviews)
0.0
jhapinc

See private message.

$42.5 USD in 17 days
(0 Reviews)
0.0
vins78vw

See private message.

$42.5 USD in 17 days
(0 Reviews)
0.0