ASP data entry page & script to add records to MS Access DB

Completed Posted Oct 28, 2002 Paid on delivery
Completed Paid on delivery

I need an ASP data entry page & script written to enter this data into a MS Access database on our website. For the sake of simplicity lets say the database name is RobDB and there is a table called RobTBL.

? In this table there are 4 fields named: code1, code2, code3, & date.

? The data entry form has the following input fields: event#, start_sequence#, end_sequence#, employee#, & date.

The ASP script would add records to the database using the following format:

Code1 field in the database = event#employee#lastdigitofsequence#

Code2 field in the database = sequence#

Code3 field in the database = employee#

Date field in the database = date

For example:

Form Entry: event#: 333 Start_sequence#: 10000 End_sequence#: 10500 Employee#: 01 Date: 10-28-2002

Records added to database:

Code1 Code2 Code3 Date

333010 10000 01 10-28-2002

333011 10001 01 10-28-2002

333012 10002 01 10-28-2002

333013 10003 01 10-28-2002

333014 10004 01 10-28-2002

333015 10005 01 10-28-2002

333016 10006 01 10-28-2002

333017 10007 01 10-28-2002

333018 10008 01 10-28-2002

333019 10009 01 10-28-2002

333010 10010 01 10-28-2002

333011 10011 01 10-28-2002

Do until Code2 reaches end_sequnce# from form entry.

I hope this makes sense and can be done easily in asp script.

Server platform is Windows 2000.

I prefer VBscript ASP page.

## 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.

3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Windows 2000 server

MS Access database but will want to convert to SQL Server soon.

Works with IE & Netscape.

## Deadline information

If possible I would like by Nov 1, 2002.

You can deliver by email.

ASP Database Administration Engineering Microsoft MySQL PHP Software Architecture Software Testing SQL Visual Basic Windows Desktop

Project ID: #2879800

About the project

45 proposals Remote project Active Oct 29, 2002

Awarded to:

relement

See private message.

$85 USD in 14 days
(10 Reviews)
4.7

45 freelancers are bidding on average $89 for this job

gravityjackinc

See private message.

$85 USD in 14 days
(45 Reviews)
9.0
progwriter

See private message.

$102 USD in 14 days
(611 Reviews)
7.7
oleg21

See private message.

$85 USD in 14 days
(137 Reviews)
7.0
terrysu

See private message.

$106.25 USD in 14 days
(96 Reviews)
7.0
aplimovil

See private message.

$85 USD in 14 days
(106 Reviews)
6.7
grandtulba

See private message.

$85 USD in 14 days
(133 Reviews)
6.4
robert2008

See private message.

$85 USD in 14 days
(84 Reviews)
5.9
Quadville

See private message.

$102 USD in 14 days
(192 Reviews)
5.5
DrumLin

See private message.

$85 USD in 14 days
(34 Reviews)
5.4
acumenvw

See private message.

$85 USD in 14 days
(23 Reviews)
5.3
cdware

See private message.

$85 USD in 14 days
(35 Reviews)
5.1
sarderhasnut

See private message.

$127.5 USD in 14 days
(53 Reviews)
4.7
novasoft

See private message.

$85 USD in 14 days
(22 Reviews)
4.5
cjntechnologies

See private message.

$85 USD in 14 days
(11 Reviews)
4.6
eeevren

See private message.

$85 USD in 14 days
(27 Reviews)
4.4
networkingbevw

See private message.

$85 USD in 14 days
(31 Reviews)
4.4
jefferycrooks

See private message.

$85 USD in 14 days
(14 Reviews)
4.0
pyesoft

See private message.

$85 USD in 14 days
(18 Reviews)
4.0
misterlvw

See private message.

$85 USD in 14 days
(22 Reviews)
4.0
bemasvw

See private message.

$93.5 USD in 14 days
(45 Reviews)
3.7