Downtime system

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

I'm trying to create a database using access 2000, this database will keep
track of equipment downtime,
I have several machine types each type of machine has several downtime
categories, I just don't know how to handle the downtime categories, 'cause
as I mentioned before each machine type has different downtime categories,
any help on how to start working on this will be greatly appreciated, thanks
to all.


Gerardo
 
I'm trying to create a database using access 2000, this database will keep
track of equipment downtime,
I have several machine types each type of machine has several downtime
categories, I just don't know how to handle the downtime categories, 'cause
as I mentioned before each machine type has different downtime categories,
any help on how to start working on this will be greatly appreciated, thanks
to all.


Gerardo
Click to expand...

You may need a Categories table with two fields: MachineType and
Category. This would let you use a customized set of categories for
each machinetype.

On your data entry form you could use a Combo Box based on a query of
this table referencing the selected machine type. Use a criterion of

=Forms![your-form-name]![cboMachineType]

where cboMachineType is the name of the combo box (or other control)
containing the machine type.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Form my experience, you may look into the access2000 tool
menu, find the extra menu, then click to open the slip
control. Then you may store each type of runtime.
 
Back
Top