[Cialug] Access

David Stout cialug@cialug.org
Fri, 4 Mar 2005 13:57:15 -0800 (PST)


--0-2051470763-1109973435=:31971
Content-Type: text/plain; charset=us-ascii

Thank you David and Kevin

David Champion <dave@visionary.com> wrote:http://www.google.com/search?hl=en&q=ms+access+newbies&btnG=Google+Search

-dc

David Stout wrote:
> What does the Me. represent in front of the field name?
> 
> "Kevin C. Smith" 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.
> 


_______________________________________________
Cialug mailing list
Cialug@cialug.org
http://cialug.org/mailman/listinfo/cialug



David Stout
Business Forms Analyst & Student
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--0-2051470763-1109973435=:31971
Content-Type: text/html; charset=us-ascii

<DIV>Thank you David and Kevin<BR><BR><B><I>David Champion &lt;dave@visionary.com&gt;</I></B> wrote:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">http://www.google.com/search?hl=en&amp;q=ms+access+newbies&amp;btnG=Google+Search<BR><BR>-dc<BR><BR>David Stout wrote:<BR>&gt; What does the Me. represent in front of the field name?<BR>&gt; <BR>&gt; "Kevin C. Smith" <KEVIN@LINUXSMITH.COM>wrote:<BR>&gt; <BR>&gt;&gt;I know this is not a forum for this type of post however I have exhausted<BR>&gt;&gt;all other forums and documentation to find my answer. So I have resorted<BR>&gt;&gt;to taking a chance at getting yelled at.<BR>&gt;&gt;<BR>&gt;&gt;Here goes:<BR>&gt;&gt;<BR>&gt;&gt;At work I am creating an Access2003 Database I have a form with a field<BR>&gt;&gt;called Determined Not Reportable By and a field called Status. The<BR>&gt;&gt;Determined Not reportable is only required if Status = "Not Reportable".<BR>&gt;&gt;How do I create validation to make the field Determined Not Reportable By<BR>&gt;&gt;when Status = "Not
 Reportable"?<BR>&gt;&gt;<BR>&gt;&gt;Thank you in advance<BR>&gt;&gt;<BR>&gt; <BR>&gt; I'm not sure I understand the question.<BR>&gt; <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; You can set the field to be not visible on the form, and then if "Status"<BR>&gt; = "Not Reportable" use VB to set the field to visible.<BR>&gt; <BR>&gt; On "Determined Not Reportable" set visible to "No" (under Format)<BR>&gt; On "Status" field in Event "After Update" enter an Event Procedure:<BR>&gt; Something like:<BR>&gt; <BR>&gt; If Me.Status = "Not Reportable" Then<BR>&gt; Me.Determined Not Reportable.Visible = True<BR>&gt; Else<BR>&gt; Me.Determined Not Reportable.Visible = False<BR>&gt; End If<BR>&gt; <BR>&gt; You can have it check the "Status" field on form load also if needed.<BR>&gt; Not sure I helped, but this may be a start.<BR>&gt;
 <BR><BR><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>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-2051470763-1109973435=:31971--