I like the idea of a parts database too.
I have added a couple things to the database posted. A comments field for
notations and a Maintenance due in the next 3000 miles report. The new
database is on my web site. Maybe one of you database gurus can suggest
instructions for people to move their data from the database I had posted
yesterday to the one posted today (or subsequently in the future). I have
played with Access from time to time, but never distributed anything or had
to worry about importing data from one iteration to another.
Jim Altman jaltman@altlaw.com Illigitimi non Carborundum
http://www.altlaw.com/metro/triumph.html 69-TR6#CC28754L W4UCK
-----Original Message-----
From: owner-triumphs@autox.team.net
[mailto:owner-triumphs@autox.team.net]On Behalf Of David Moag
Sent: Sunday, October 18, 1998 3:27 PM
To: 'Andy'; 'Joe Curry'
Cc: 'Brian Sanborn'; Jim Altman; 'Triumphs'
Subject: RE: Access Maintenance Database
Andy,
I think Joe's idea is a very good one. I'm sure nearly everyone on the list
would like to have a place to go for buying/selling of parts. So count this
as my vote towards enough demand!
Dave Moag
77 Spitfire
62 TR3B (needing LOTS of parts)
> -----Original Message-----
> From: owner-triumphs@autox.team.net
> [mailto:owner-triumphs@autox.team.net]On Behalf Of Andy
> Sent: Sunday, October 18, 1998 10:57 AM
> To: Joe Curry
> Cc: Brian Sanborn; jaltman@altlaw.com; Triumphs
> Subject: Re: Access Maintenance Database
>
>
>
> You guys may have aught me at just the right time.
> Not that I have much time on my hands but I like the Idea.
> It's time for me to renew (one of) my web pages. I could
> devote it to this
> database/classifieds and put the info on there.
> Enough demand and I'll do it.
> Andy D.
>
> On 10/18/98 10:04 AM Joe Curry said...
> >
> >Brian (and all)
> >
> >While we are on the parts database issue, I have been
> thinking about the
> >need for a, "parts clearinghouse" database. The way it
> would work is,
> >those who have parts that they don't need (either new or
> used) can send
> >their information to the manager of the database and they
> will be listed
> >on-line by vehicle and location. It will help both the selling and
> >buying parties locate those parts that are needed to make repairs or
> >finish that restoration project.
> >
> >I can envision the database as a free service if somebody
> has the time
> >to sped on such a project. Otherwise, maybe a small listing
> fee could
> >be paid by the seller when the part is sold.
> >
> >I'm interested to know what the consensus is on this idea.
> Comments are
> >welcome.
> >
> >Joe
> >
> >Brian Sanborn wrote:
> >>
> >> Jim,
> >>
> >> Thanks... Looks nice.... I have been working on a TR Parts control
> system in
> >> Access 97 which I plan to share with the list and anybody
> else that
> cares.
> >>
> >> It's not finished but will be soon. The idea is to have
> a place to keep
> >> control of the parts you buy or acquire, the parts you
> identify as need in
> >> the future but can't yet afford( so you know what to order
> when things go
> on
> >> sale), the cost of the part and where the part is( future purchase,
> >> inventory and where stored or installed on car). I have
> it linked to the
> >> TRF database for price and description. So far it is
> fancy enough to be
> >> forms based but needs more work to make it shareable.
> >>
> >> I want to enter all the parts I have bought from TRF and
> Moss and all the
> >> parts on little buckslips in my catalogs for futures. I
> wish that Moss had
> >> a database.
> >>
> >> Brian Sanborn
> >> 62 TR4 CT16260L - Groton, MA
> >> sanborn@net1plus.com
> >> -----Original Message-----
> >> From: jaltman@altlaw.com <jaltman@altlaw.com>
> >> To: 'Triumph List' <triumphs@autox.team.net>
> >> Date: Saturday, October 17, 1998 9:24 PM
> >> Subject: Access Maintenance Database
> >>
> >> >
> >> >I have put together a little Access Database to record maintenance
> >> >information. There is a copy posted to my web site at
> >> >http://www.altlaw.com/metro/triumph.htm. Its written in
> Access 97 and
> >> having
> >> >that is required. A friend of mine is going to convert it
> to a Visual Basic
> >> >routine and compile it so that its a free standing
> program. You're
> welcome
> >> >to download and play with it. Comments and suggestions welcome.
> >> >
> >> >Lest you think I am driving a new car, add 175,000 to get
> my actual
> >> mileage.
> >> >At 181,000 I replaced the speedo with one that read 6,000.
> >> >
> >> >
> >> >
> >> >Jim Altman jaltman@altlaw.com Illigitimi non Carborundum
> >> >http://www.altlaw.com/metro/jaltman.html 69-TR6#CC28754L W4UCK
> >> >
> >> >
> >> >
> >
> >--
> >"If you can't excel with talent, triumph with effort."
> >
> > -- Dave Weinbaum in National Enquirer
>
|