Recent content by fleetman

Much of the development of my program during the last year has been done by me on a learn as you go basis. I bought Microsoft office Professional2007 $450.00,took a 2 day class on Access $300.00 bought several books $300.00 My time amounts to 600 hours "probono" but for my efforts I Setup all...

Thanks for the follow-up... Since the post, I have done a little more research. It seem like most of the process is thought through before the tables are built and linked. The process I was thinking about was more like finding a missing piece while using a " lookup table" to a new record...

I too am working on a new data base. I have no formal training so there could be hugh gaps in my knowledge. I think the process of Normalizing the data is simply to use your data base, discovering missing data in varoius fields and populating the fields is the normalizing process. Is there...

Well the book arrived. VBA Programming for Microsoft Office Project. The 1st ninty pages I think I can use. I am not sure about the other 360 pages though. Rod Gill is the author. After my nap I will begin reading it. I'll figure this out one way or the other.

Hi James: All work orders are in the same table. The closed work order button is a yes know field. I have two different menu buttons 1 that opens only open workorders y/n=n and a second that opens only closed workorders y/n=y This saves time processing open work orders. old DB has 21000...

Thanks for the assistance. Simple is better. I have done a couple of subforms, so I may give this a try. Anything I can learn to do that works is just what I need to do for now. I have ordered a book on VBA and when it comes in, I would like to something about code. JC

Dear D&C, The mileage or hour meter data changes with every workorder. Only Preventive Maintenance data is calculated from the values. in my old DOS application I entered the miles and hour meter data in the vehicle master and then in the workorder. Since I have to enter the data on everywork...

I have a database that contains a [UNITS] table, with {miles and hours} fields. This data base also has a [WORKORDERS] table that contains {miles and hours} fields. A workorders form is used to open new workorders where current {miles and hours} fields are populated. A [CLOSED WORKORDER]...

Thanks for the advise. I am so new, I'll have figure out what you mean and then figure out how to write/test it.:o

Hi, all: I am new to Access2007 and I need some guidance on a data integrity and time saving idea. I have a 120 day old data base that I use to track fleet maintenance. There are tables for Vendors, Parts, Vehicles and workorders. Currently I am updating field manually in each table. after...

Hi Everyone: I am John, a fleet man with 28 years of experience. In 1994 I learn a little programmming in a program called TEAM-UP. The fleet management applications I put together served me for the next 16 years I am currently redeveloping the system in Access2007. I took a two day class last...