If Then Expressions?

[FoxMan250]

Hey guys,

I'm new to this forum and also extremely new to Access. We currently use Access to have our employees look up Lockout Tagout safety procedures at our plant. I was put in charge of updating it, and since I didn't design it, I'm a bit overwhelmed and need some help.

I've worked with Excel and C# a bit so I'm ok with some understanding of programming, but not much so I may need things dumbed down.

Here's what I'm trying to do (bear with me since this is tough to explain):

- We have a table that holds all the pieces of equipment with their name and number
- We have a second table of equipment numbers and procedures that is linked to the numbers in the first table. When an employee types in the equipment number in the user interface (linked to the first table), the second table populates the below section of the interface by showing the procedures to use.
- Then we have a third and fourth table labelled "Upstream" and "Downstream". These tables have 2 columns for numbers. The first column is for the main equipment number and the second column is for either the upstream or downstream equipment number. These populate the upstream and downstream section of the interface.

Here's what the interface looks like when done:


What I want to do is have a phrase appear in the "Unusual Precautions" section ONLY when certain equipment numbers are in the top section and not have the phrase appear when that same piece of equipment appears in the upstream and downstream sections.

Sorry for the lengthy explanation but any notes on how to do an "IF/Then" expression by cell in access or something along those lines would really help.



Thanks in advance

[burrina]

Edit to suit your needs for Criteria.

If Me.EquipmentNumber = 1 Then
Me.lblSomeLabel.Caption = "Say Something"
Else
Me.lblSomeLabel.Caption = ""
End If

HTH

[June7]

I see field caption "Unusual Cautions" but not "Unusual Precautions". Where exactly to you want the message to appear - in each record of each subform or only in the header of main form?

[FoxMan250]

I see field caption "Unusual Cautions" but not "Unusual Precautions". Where exactly to you want the message to appear - in each record of each subform or only in the header of main form?

Sorry, i meant "Unusual Cautions". I'd like the message to only appear in that cell for the equipment when it is the main equipment (first row), and have it not appear if that same piece of equipment were to show up as an upstream or downstream for a different main piece of equipment.

[June7]

This message would show ONLY in the first record of first subform?
For the posted example, message should show for 0-02-11 record?
But if 0-02-11 was listed in either Upstream or Downstream, do not show message?

[FoxMan250]

This message would show ONLY in the first record of first subform?
For the posted example, message should show for 0-02-11 record?
But if 0-02-11 was listed in either Upstream or Downstream, do not show message?

Exactly! That's what I'm trying to accomplish.

[June7]

Sounds veeeeerrrrry difficult. I think too complicated for a textbox expression and a custom function will be needed.

1. First complication is making the message show in only the first record of the top form.

2. Then must search records of the other forms to determine if the value is in any record.
Maybe DLookup or DCount on the tables with appropriate filter criteria.
Or maybe opening DAO recordset objects of the other two form RecordSources and use FindFirst method.

[FoxMan250]

Sounds veeeeerrrrry difficult. I think too complicated for a textbox expression and a custom function will be needed.

1. First complication is making the message show in only the first record of the top form.

2. Then must search records of the other forms to determine if the value is in any record.
Maybe DLookup or DCount on the tables with appropriate filter criteria.
Or maybe opening DAO recordset objects of the other two form RecordSources and use FindFirst method.

I was afraid this would get difficult. Is there a way to set the print field perhaps? Maybe I could create a print button that would exclude the upstream and downstream sections from the print field?

[June7]

What is the 'print' field?

Excluding records is the same issue. Need to do determine same parameters as for displaying message.

[FoxMan250]

What is the 'print' field?

Excluding records is the same issue. Need to do determine same parameters as for displaying message.

I was thinking similar to excel where you can set certain groups of cells to be printed while excluding other surrounding cells. Well shoot, I'm at a loss for ideas here.

[June7]

Anything can be done with enough code. This is just a bit unusual requirement and will require somewhat advanced programming skill.

[FoxMan250]

Advance being what would hold me back with my lack of skills with this program... :/

What if I added another cell to each piece of equipment that the message could be written in, but then only make that cell show up in the main section and not the others. That way I'm only restricting what cells are in view rather than text?

[June7]

Including or excluding a field in form is simple. You would then manually edit the field for the first record depending on your direct analysis of the displayed records? That does seem to be an option.

[FoxMan250]

Yeah that might be the best way to go here, or try to at least.

I'm trying to add in a special circumstances statement basically.

I wanted to have the description:

FOR EXTERNAL WORK
(No Exposure to Inside of Housing)
Only this piece of equipment needs locked out.
No Upstream or Downstream locking required.

So If I added another cell next to "Unusual Cautions" for all pieces of equipment, but then wanted to hide or exclude that cell for just the Upstream and Downstream areas, how would I go about doing that?

[June7]

Rethink your terminology. It's not a 'cell', its a control (textbox, combobox, label, etc).

Aren't these three subforms? If you don't want this field to display on form then don't include it in form design.