Closed

Truck tracker

MS Access or Intranet based database to track a variety parts shipped via several trucks to a vendor or to the construction site.

The original system was built using a DOS database many years ago in a couple of days and was used until a while back when the computers were replaced.

We need to collect the following information for each Job: job name{15}, customer{25}, start date{date}, target completion date{date}, ship-to-address

Section I

1. Drawing #{10}, [Item{10} (lookup1), description{60}, weight{#}], quantity{number}, source{15} (lookup2), comment{60}, origin{15} (lookup3)

2. Die #{10}, Length{number} (feet and inches to 11.375). finish{15}(lookup4), quantity{number} and comment{60}

3. Set a job active or inactive.

Add all of the entries together so the total number required is accumulated for each item and stored when changed.

## Deliverables

Section II

Collect information about a given delivery truck:

1. Source{15}(lookup2), destination{25}(lookup5), shipper{25}(lookup6), date shipped{date}

Section III

Load items on a truck:

1. Select from the items from Section I, view the quantity to be shipped, enter the quantity shipped, deduct that from the total number store the new total number.

Reports to see:

All items for a job, all jobs in the system, all trucks for a job, all items on a truck, items to be shipped for a job, all items to be shipped. Total weight of a truck, for an individual item all drawing #s that apply, for an individual item all jobs that apply, for an individual item and job, which truck is it on, We want to colorize the report by source so it is easily visible. On reports relating to items from Lookup 3, display the appropriate color background for the first or second column of the report.

This will be a working system, used by professionals who are familiar with the data and perhaps data entry people, so the ability to use the system with speed such as a spreadsheet data entry where the passable items are visible and only the numbers need to be entered for each can be 123, tab or down arrow, 123. In addition to a record by record entry form.

Access 2003 and an Intranet are available so it could be web based. The number of users could be as many as 7 at the same time, but more often 1-2.

The number inside the {}s are estimated field length to hold what we need as I know it at the moment.

Lookup Details:

1. Extract from Inventory database, items can be added on the fly.

2. A small number of locations GT and other sources of material.

3. 4 Items right now, Fabricated(Blue), inventory{yellow}, Direct Ship(green), Outsourced item(Orange)

4. 5 items right now, Mill, Painted, Anodized, Abraided, Galvanized

5. Job site names (perhaps from the Jobs table and some vendors sites when items sent to be galvanized on the way to the job.)

6. Name of shipping companies used (perhaps a small table with particulars phone, contact person, comments about the shipper)

Version 1.c dated 6/6/08 9:28 AM

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Friday Jun 20, 2008 7:22:49 AM:

Additional information: We have MS Windows Server 2003 for Small Business Server with Service Pack 2 that is primarily used for file sharing. We would be willing to add software to support local processing. Our website is capable of MySQL. The only data we expect to import will be a "one-time" of the existing inventory, from Access.

## Platform

Windowqs Xp and Up on MS Access 2003 and Up.

Skills: PHP

See more: windows phone jobs, which jobs hire at 15, where can i hire data entry person, what jobs hire at 15, what jobs are available, what is direct data entry, what is data entry speed, what companies hire at 15, what can be outsourced, what are some jobs that hire at 15, what are some business jobs, what are jobs that hire at 15, website where people bid on jobs, website to hire professionals, website customer service jobs, web customer service jobs, vendor database ms access, u.s. jobs data, under the table jobs, trucks for hire, truck jobs, truck hire, truck for hire, time tracker desktop, target item number lookup

About the Employer:
( 0 reviews ) Riverview, United States

Project ID: #3002510

50 freelancers are bidding on average $593 for this job

itgurussoftware

See private message.

$470.05 USD in 14 days
(139 Reviews)
8.4
fastudiovw

See private message.

$552.5 USD in 14 days
(731 Reviews)
7.5
evisionisfvw

See private message.

$765 USD in 14 days
(27 Reviews)
7.4
techfirstvw

See private message.

$680 USD in 14 days
(179 Reviews)
7.2
asselsolutions

See private message.

$595 USD in 14 days
(65 Reviews)
7.1
tjlTOM

See private message.

$765 USD in 14 days
(266 Reviews)
6.7
suthernsoftware

See private message.

$637.5 USD in 14 days
(62 Reviews)
6.6
ritzdigitals

See private message.

$765 USD in 14 days
(89 Reviews)
6.5
Premshanks

See private message.

$722.5 USD in 14 days
(355 Reviews)
6.5
branislavm

See private message.

$552.5 USD in 14 days
(259 Reviews)
6.5
SaneliteTechnolo

See private message.

$612 USD in 14 days
(116 Reviews)
6.1
AliQ

See private message.

$765 USD in 14 days
(52 Reviews)
6.0
urmate

See private message.

$680 USD in 14 days
(92 Reviews)
5.9
softncode

See private message.

$765 USD in 14 days
(64 Reviews)
6.0
zeesoft

See private message.

$743.75 USD in 14 days
(197 Reviews)
6.0
coderTariq

See private message.

$764.15 USD in 14 days
(34 Reviews)
5.7
tusharjohri

See private message.

$634.95 USD in 14 days
(82 Reviews)
5.6
mdsoftsl

See private message.

$510 USD in 14 days
(10 Reviews)
5.0
peteoconnor

See private message.

$680 USD in 14 days
(14 Reviews)
5.0
geniussoftwvw

See private message.

$425 USD in 14 days
(20 Reviews)
4.8