vehicle maintenance template

[jason]

I just downloaded the template for vehicle maintenance and for the most part,
I love it. There's one thing, though, that I wish I could change but I'm not
sure how...Instead of all vehicles being in one form, I would like to make it
so that there's a differant tab for each vehicle so I can keep their forms
separate. Can anyone tell me how to do this?
Thanks

 

[Klatuu]

I think you are misunderstanding forms. Forms do not contain any data. Only
tables contain data. Forms are only an organized way to enter, view, and
manipulate data.
What you propose is not practical. Vehicles come and go, You may have more
now than earlier or dispose of one and replace it. It doesn't make sense to
create a form for each vehicle.

The only thing that should change is the data. The form is static, you just
select the vehicle you want to see in the form.

 

[John W. Vinson]

I just downloaded the template for vehicle maintenance and for the most part,
I love it. There's one thing, though, that I wish I could change but I'm not
sure how...Instead of all vehicles being in one form, I would like to make it
so that there's a differant tab for each vehicle so I can keep their forms
separate. Can anyone tell me how to do this?
Thanks

You're mistaking how Forms work. Data is not stored in forms; it's stored in
the Table, and only in the table.

A Form is JUST A WINDOW. You can display the data for any vehicle in a common
form; you would certainly not want to need to create a new form (or even a new
tab page) whenever you add a vehicle to the fleet.

You can put a Listbox or Combo Box on the header of the form to select which
vehicle you're looking at; the visual effect for the user will be very much
the same - they'll see the name of the vehicle at the top of the screen and
the data for that vehicle on the screen.

 

[Tony Toews [MVP]]

I just downloaded the template for vehicle maintenance and for the most part,
I love it.

If you ever outgrow that database see my Fleet Management system at
http://www.granite.ab.ca/fleet/.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[jason]

I'm sorry, I guess I used the wrong terminology...I've never used Access till
now. Here's what my situation basically is. Right now, I'm using Excell for
my vehicle records. I've created a differant file for each of my vehicles so
I can open whichever vehicle I want and view only the information for that
vehicle. It has worked fine until I decided that I also wanted to click on a
particular service and have another window pop up to put more detailed
descriptions for that service. To my knowledge, there's no way to do that in
Excell. Thats when I stumbled upon the vehicle template for Access and
realized that I can click on a particular service and add more details in
another window. But, like I said, it looks as though I have to put all my
vehicles in one list of services. I don't want that. I want to be able to
click on whichever vehicle I want and see only the list of services and total
cost for that vehicle alone. I hope this makes more sense as to what I'm
shooting for.

 

[John W. Vinson]

But, like I said, it looks as though I have to put all my
vehicles in one list of services. I don't want that. I want to be able to
click on whichever vehicle I want and see only the list of services and total
cost for that vehicle alone.

In a properly normalized database with properly designed forms, this is very
straightforward in Access - using only one table for vehicles related
one-to-many to a second table of service activities.

You do NOT need multiple files or multiple tables. You may need to set aside
some of your assumptions from Excel about "how things are always done" though!
Sometimes "unlearning" the techniques suitable for Excel is as much work as
learning the relational approach!