Counting uses

[Kathy Z]

I have constructed a DB that is used for tracking Required
maintenance of Machines used. It consists of a Table Named
machine Id with machine ID as the primary key and all
things related to that machine such as PM No, name,
location serial no, etc
Another table named Tasks that has all tasks needed to be
performed on the machine. with machine ID as the foreign
key and task ID as primary key. Machine Id is a one to
many to Tasks. there are 2 ore tables that contain the
machine ondays (a date each time a machine is turned on)
and one for task dates ( for tasks that have specific
dates) like every 6 months or annually. My problem is that
there are some tasks that are due every 5 uses or every 30
uses. Machine are not used every day so I don't have a
date to work from. I need somehow to count the uses and
have a pop-up type box to inform the operator when the
machine has been turned on 5, 30, etc. times and that a
certain task is due. Any help from anyone would be greatly
appreciated. I am very weak in visual basic..can this be
done with a macro or query. Thanks, a befuddled newbie.

 

[Kathy z]

-----Original Message-----
What type of machines? For instance if you were talking

about a lathe, I doubt if Access could somehow detect that
a lathe has been turned on. Also just because a machine
has been turned on, does that mean it has been 'used'? It
would be better to have 'an average uses per week' column
or something like that, then flag it for maintenance after
that period has elapsed.

.

It is machine tools, ovens, balancer,etc. but I am not
looking for access to record on time, the operator will do
that.
The powers that be do not want averages and yes if the
machine is turned on it is used.

 

[Kathy Z]

The machines are lathes, ovens, balancers,etc. I have a
table of machine ondays with machine ID and onday dates
that are entered by the operator when the machine is
turned on. But how do I count uses?

-----Original Message-----
Sound to me like you need a Table of Uses, linked to Machines by MachineID.

Then I guess you have to get the Machine USERS to log on

to the DB and enter data (perhaps just a click of a single
button,) each time they use the machine. that adds a
record to the Table of Uses with MachineID and date.

then a query can then count uses with dates greater than

last service date. (ie MaxOfServiceDate)

 

[Kathy Z]

BLM, can you give me an example of a query that counts uses
(ie MaxOfServiceDate)
Thanks

-----Original Message-----
Sound to me like you need a Table of Uses, linked to Machines by MachineID.

Then I guess you have to get the Machine USERS to log on

to the DB and enter data (perhaps just a click of a single
button,) each time they use the machine. that adds a
record to the Table of Uses with MachineID and date.

then a query can then count uses with dates greater than

last service date. (ie MaxOfServiceDate)