[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 <dave@visionary.com></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&q=ms+access+newbies&btnG=Google+Search<BR><BR>-dc<BR><BR>David Stout wrote:<BR>> What does the Me. represent in front of the field name?<BR>> <BR>> "Kevin C. Smith" <KEVIN@LINUXSMITH.COM>wrote:<BR>> <BR>>>I know this is not a forum for this type of post however I have exhausted<BR>>>all other forums and documentation to find my answer. So I have resorted<BR>>>to taking a chance at getting yelled at.<BR>>><BR>>>Here goes:<BR>>><BR>>>At work I am creating an Access2003 Database I have a form with a field<BR>>>called Determined Not Reportable By and a field called Status. The<BR>>>Determined Not reportable is only required if Status = "Not Reportable".<BR>>>How do I create validation to make the field Determined Not Reportable By<BR>>>when Status = "Not
Reportable"?<BR>>><BR>>>Thank you in advance<BR>>><BR>> <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><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 & 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--