Lock Out Tag Out db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Holden - 24 Jul 2007 19:06 GMT

I have a Lock Out Tag Out db for doing maintenance at a power plant. This db
puts equipment ID and status on a list so that maintenance can be performed
safely. Some maintenance is repetative, so we build many similar tagouts.
How can I store sample tagouts so that I can develop a standard tagout?

Analogous to a standard customer / product sales mix. Perhaps each customer
would buy the same 12 items to start being a customer and you wanted to speed
data entry.

Reply to this Message

Arvin Meyer [MVP] - 24 Jul 2007 19:59 GMT

You can build a table with the values, then use a recordset to retrieve
those values or do a lookup from a combo box to fill in the values.

Have the combo box look up the specific tagout, then populate the form in
the combo's afterupdate event. The combo's column property (which uses a
zero based index) would be used like:

Sub cboTagout_AfterUpdate()
Me.txt1 = Me.cboTagout.Column(2)
Me.txt2 = Me.cboTagout.Column(3)
Me.txt3 = Me.cboTagout.Column(4)
Me.txt4 = Me.cboTagout.Column(5)
End Sub

Adding all the data to the combo's columns is really only feasible if you
have no more than 3 or 4 dozen entries. After that, it may be more efficient
to look up with a recordset.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I have a Lock Out Tag Out db for doing maintenance at a power plant. This
>db
[quoted text clipped - 8 lines]
> speed
> data entry.

Reply to this Message