ASP data entry page & script to add records to MS Access DB
$100-150 USD
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.
Project ID: #2879800