[Cialug] Access

[David Stout]

--0-882791777-1109970787=:26682
Content-Type: text/plain; charset=us-ascii

What does the Me. represent in front of the field name?

"Kevin C. Smith" <kevin@linuxsmith.com> wrote:
> I know this is not a forum for this type of post however I have exhausted
> all other forums and documentation to find my answer. So I have resorted
> to taking a chance at getting yelled at.
>
> Here goes:
>
> At work I am creating an Access2003 Database I have a form with a field
> called Determined Not Reportable By and a field called Status. The
> Determined Not reportable is only required if Status = "Not Reportable".
> How do I create validation to make the field Determined Not Reportable By
> when Status = "Not Reportable"?
>
> Thank you in advance
>
I'm not sure I understand the question.

"How do I create validation to make the field Determined Not Reportable By
when Status = "Not Reportable"?"

You can set the field to be not visible on the form, and then if "Status"
= "Not Reportable" use VB to set the field to visible.

On "Determined Not Reportable" set visible to "No" (under Format)
On "Status" field in Event "After Update" enter an Event Procedure:
Something like:

If Me.Status = "Not Reportable" Then
Me.Determined Not Reportable.Visible = True
Else
Me.Determined Not Reportable.Visible = False
End If

You can have it check the "Status" field on form load also if needed.
Not sure I helped, but this may be a start.

-- 
Kevin C. Smith
_______________________________________________
Cialug mailing list
Cialug@cialug.org
http://cialug.org/mailman/listinfo/cialug



David Stout
Business Forms Analyst & Student
		
---------------------------------
Celebrate Yahoo!'s 10th Birthday! 
 Yahoo! Netrospective: 100 Moments of the Web 
--0-882791777-1109970787=:26682
Content-Type: text/html; charset=us-ascii

<DIV>What does the Me. represent in front of the field name?<BR><BR><B><I>"Kevin C. Smith" &lt;kevin@linuxsmith.com&gt;</I></B> wrote:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>&gt; I know this is not a forum for this type of post however I have exhausted<BR>&gt; all other forums and documentation to find my answer. So I have resorted<BR>&gt; to taking a chance at getting yelled at.<BR>&gt;<BR>&gt; Here goes:<BR>&gt;<BR>&gt; At work I am creating an Access2003 Database I have a form with a field<BR>&gt; called Determined Not Reportable By and a field called Status. The<BR>&gt; Determined Not reportable is only required if Status = "Not Reportable".<BR>&gt; How do I create validation to make the field Determined Not Reportable By<BR>&gt; when Status = "Not Reportable"?<BR>&gt;<BR>&gt; Thank you in advance<BR>&gt;<BR>I'm not sure I understand the question.<BR><BR>"How do I create validation to make the field Determined Not Reportable By<BR>when Status = "Not Reportable"?"<BR><BR>You can set the field to be not visible on the form, and then if "Status"<BR>=
 "Not Reportable" use VB to set the field to visible.<BR><BR>On "Determined Not Reportable" set visible to "No" (under Format)<BR>On "Status" field in Event "After Update" enter an Event Procedure:<BR>Something like:<BR><BR>If Me.Status = "Not Reportable" Then<BR>Me.Determined Not Reportable.Visible = True<BR>Else<BR>Me.Determined Not Reportable.Visible = False<BR>End If<BR><BR>You can have it check the "Status" field on form load also if needed.<BR>Not sure I helped, but this may be a start.<BR><BR>-- <BR>Kevin C. Smith<BR>_______________________________________________<BR>Cialug mailing list<BR>Cialug@cialug.org<BR>http://cialug.org/mailman/listinfo/cialug<BR></BLOCKQUOTE></DIV><BR><BR>David Stout<br>Business Forms Analyst &amp; Student<p>
		<hr size=1>Celebrate Yahoo!'s 10th Birthday! <br> 
<a href="http://birthday.yahoo.com/netrospective/">Yahoo! Netrospective: 100 Moments of the Web</a> 
--0-882791777-1109970787=:26682--