473,382 Members | 1,238 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Auto fleet manager

Anyone got -know of a databsae designed to track the company vehicle
fleet. Repairs etc.... No sence writing it if their is free bee out
there. I have better things to do with my time, but I was asked to
come up with one. Does anyone know of a site/ group whatever for
sharing this type of work? I would certainly contribute...Or is this
opensource approach a no no.?
Nov 12 '05 #1
8 1394
On 10 Dec 2003 22:28:18 -0800, bg***@yahoo.com (Nairb) wrote:

My company is maintaining such software for a few dealers in town.
There is several man-months of work in it. Seems unrealistic to me
that one company would pay several tenthousand dollars to have this
developed, and than give it away to the rest of the world in the
spirit of sharing...
This is still a capitalist society; with a few idealists.

-Tom.
Anyone got -know of a databsae designed to track the company vehicle
fleet. Repairs etc.... No sence writing it if their is free bee out
there. I have better things to do with my time, but I was asked to
come up with one. Does anyone know of a site/ group whatever for
sharing this type of work? I would certainly contribute...Or is this
opensource approach a no no.?


Nov 12 '05 #2
bg***@yahoo.com (Nairb) wrote:
Anyone got -know of a databsae designed to track the company vehicle
fleet. Repairs etc.... No sence writing it if their is free bee out
there.


I've built such which I am selling but it's not free.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #3
Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<jo********************************@4ax.com>. ..
On 10 Dec 2003 22:28:18 -0800, bg***@yahoo.com (Nairb) wrote:

My company is maintaining such software for a few dealers in town.
There is several man-months of work in it. Seems unrealistic to me
that one company would pay several tenthousand dollars to have this
developed, and than give it away to the rest of the world in the
spirit of sharing...
This is still a capitalist society; with a few idealists.

-Tom.
Anyone got -know of a databsae designed to track the company vehicle
fleet. Repairs etc.... No sence writing it if their is free bee out
there. I have better things to do with my time, but I was asked to
come up with one. Does anyone know of a site/ group whatever for
sharing this type of work? I would certainly contribute...Or is this
opensource approach a no no.?


True,perhaps fleet is bad term, I was thinking on a much smaller
scale. Not dealership, small company with 25 vehicles. Just a basic
record keeping and tracking of when and what and who got repairs and
the cost of said repairs. There MUST be many, many acceptable designs
in place all over. Perhaps if there were some mechanism in place where
people shared this type of work, we could then spend time on new and
challenging things(like something someone would pay those kind of
figure$ for) rather than being stuck in a perpetual loop as we are
separatley so to speak. But then I'm not an MVP just a rookie who
didn't want to waste a half a day on something I suspect is very
common.

Just out of curiousity with my basic description of what I need above
what would that be worth? Being underpaid as I am here in small town
america, which I enjoy living in, the company will get it for about
$100 wages from me. What would you charge?
Nov 12 '05 #4
bg***@yahoo.com (Nairb) wrote:
True,perhaps fleet is bad term, I was thinking on a much smaller
scale. Not dealership, small company with 25 vehicles. Just a basic
record keeping and tracking of when and what and who got repairs and
the cost of said repairs. There MUST be many, many acceptable designs
in place all over. Perhaps if there were some mechanism in place where
people shared this type of work, we could then spend time on new and
challenging things(like something someone would pay those kind of
figure$ for) rather than being stuck in a perpetual loop as we are
separatley so to speak. But then I'm not an MVP just a rookie who
didn't want to waste a half a day on something I suspect is very
common.


However the system I've worked on, while it appears simple, still has several hundred
hours of time invested in it. For which I figure I've now made about $3 per hour.
<smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #5
"Nairb" wrote
But then I'm not an MVP just a
rookie who didn't want to waste
a half a day on something I suspect
is very common.


Anything you can develop in half a day, whether you are a rookie or highly
experienced Access developer, is going to be very, very simple. It's
ridiculously easy to spend 'way more time than that just gathering the
_requirements_ for an application, much less documenting them, and getting
the users to review and approve them before you even begin designing what
you are going to implement.

I'd suggest you don't _commit_ in advance to a half-day development effort
for this application.

Nov 12 '05 #6
On Sat, 13 Dec 2003 01:38:26 GMT, "Larry Linson"
<bo*****@localhost.not> wrote:

Amen.
-Tom.

"Nairb" wrote
But then I'm not an MVP just a
rookie who didn't want to waste
a half a day on something I suspect
is very common.


Anything you can develop in half a day, whether you are a rookie or highly
experienced Access developer, is going to be very, very simple. It's
ridiculously easy to spend 'way more time than that just gathering the
_requirements_ for an application, much less documenting them, and getting
the users to review and approve them before you even begin designing what
you are going to implement.

I'd suggest you don't _commit_ in advance to a half-day development effort
for this application.


Nov 12 '05 #7
NB
> "Nairb" wrote
> But then I'm not an MVP just a
> rookie who didn't want to waste
> a half a day on something I suspect
> is very common.

I really think you've never developed a serious (though maybe simple) app.
Think of half a month or even half a year instead.

NB
Nov 12 '05 #8
DFS
"Nairb" <bg***@yahoo.com> wrote in message
news:33**************************@posting.google.c om...
Anyone got -know of a databsae designed to track the company vehicle
fleet. Repairs etc.... No sence writing it if their is free bee out
there. I have better things to do with my time, but I was asked to
come up with one. Does anyone know of a site/ group whatever for
sharing this type of work? I would certainly contribute...Or is this
opensource approach a no no.?

Nairb,

It'll probably be easier for you to do it yourself than hunt around and try
to find one for free.

Here's a simple set of tables to get you started:
VEHICLES
-------------------
* VIN (text field)
VehicleMake (text)
VehicleModel (text)
VehicleModelYear (integer)
VehicleColor (text)
VehicleAcquiredYear (integer)
VehicleDisposedYear (integer)
.....
other attributes of the vehicle

REPAIRS
------------------
* VIN
* RepairDate
* RepairType
RepairDescription
RepairResults
RepairCost
RepairMgr
.....
other attributes of the repair

FLEET_USAGE
---------------------------
* VIN
* UsageType (delivery, personal, etc)
* CheckOutDate
CheckInDate
CheckOutCondition
CheckInCondition
CheckOutMileage
CheckInMileage
Driver
DriverComments
JobNbr (this would tie back to a table of Jobs or Work Orders)
....
other attributes of the Vehicle Usage


Nov 12 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Nischal Topno | last post by:
Hi, Is there any way to auto load/instantiate a new class of a servlet into the JVM (with shutting the web server) after replacing the old class with new one? For e.g., after a servlet is...
22
by: Jim Moe | last post by:
Hello, Is there a way to have a div size itself to the width of its contents? "width:auto" does not work. The div contains a UL and I want the div to fit the longest line in the list. The div is...
2
by: Earl Anderson | last post by:
In A97, WXP, I have an employee form which, among other things, has a textbox for that employee's assigned access card number . The form also has two (2) Yes/No checkboxes. One checkbox is to...
8
by: John | last post by:
Hi, I am developing an application using VB.Net and hope that the textbox can process features which are similar to auto-complete features in Window. For example, when user types "ap" in a...
9
by: Beowulf | last post by:
I was having this problem: http://groups.google.com/group/microsoft.public.sqlserver.server/msg/e36e423972323378?dmode=source with it taking an inordinate amount of time to enumerate the...
3
by: TS | last post by:
I am using IE 7. I have a website running on my local machine (localhost) and auto complete doesnt work for any of the textboxes, but going to web sites on the internet does support this so i know...
3
by: =?Utf-8?B?Um9nZXIgVHJhbmNoZXo=?= | last post by:
The problem I'm coming across now is that I can't update such a column, because I have set the auto generated value to true, and LINQ won't let me change such a value, a la...
6
by: Peter | last post by:
I have a APS.NET 3.5 webpage which calls a web service. What I need is to update this page automatically when a value changes in the webservice, does anyone have an example? Thank You ...
1
by: jonny27wakey | last post by:
I am in the process of developing an Ideas management database for the company which I work for. I require an email facility driven by a Submit button from a form on Access, my problem is the...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.