<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<P><B><I><FONT SIZE=2 FACE="Arial">---- London Borough of Bromley E-Mail Disclaimer ----</FONT></I></B><I></I> </P>
<P><FONT SIZE=2 FACE="Arial">"For information about Bromley Council visit our web site www.bromley.gov.uk"</FONT> </P>
<BR>
<P><FONT SIZE=2 FACE="Arial">"The information contained in this message (including any attachments) is confidential in that it is intended solely for the use of the recipient to which it is addressed. If you are not the intended recipient, the use of the information by disclosure, copying or distribution is prohibited and may be unlawful." </FONT></P>
<P><B><I><FONT SIZE=2 FACE="Arial">---- End of Disclaimer ---- </FONT></I></B></P>
<BR>
<DIV><SPAN class=394074309-06052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></DIV>
<DIV><FONT face=Tahoma><SPAN class=394074309-06052003></SPAN><FONT
face=Arial><FONT color=#0000ff><FONT size=2>O<SPAN
class=394074309-06052003>k, </SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=394074309-06052003></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=394074309-06052003>Error found.</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=394074309-06052003></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=394074309-06052003>I was calling a sub and not a function...seems to work
now.</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=394074309-06052003></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=394074309-06052003>Thanks for the
help.</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=394074309-06052003></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=394074309-06052003>RyanS</SPAN></FONT></FONT></FONT></DIV>
<DIV><BR> </DIV>
<DIV><FONT size=2><SPAN class=394074309-06052003> </SPAN>-----Original
Message-----<BR><B>From:</B> A.D.Tejpal
[mailto:ad_tp@hotmail.com]<BR><B>Sent:</B> 06 May 2003 08:16<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Eval not
working?<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><B><I><FONT face="Courier New" size=2>---- London Borough of Bromley
Security Notice ----</FONT></I></B><I></I> </P>
<P><FONT face="Courier New" size=2>"Please treat all e-mail with caution. Only
open attachments from trusted business sources whose material you are sure is
safe. Refer to the Council's e-mail and internet users Code of Conduct for
further guidance on the correct use of the e-mail system."</FONT></P>
<P><B><I><FONT face="Courier New" size=2>---- End of Notice
----</FONT></I></B></P><BR>
<DIV><STRONG>Ryan,</STRONG></DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV> Could you kindly post the particulars of each label
(name & caption) as well as the exact code used by you. If the
functions are user-defined (i.e. not inbuilt ones), the code for each such
function may also pl be given. </DIV>
<DIV> It is presumed that you have test checked
each function to work properly when used in a normal manner(i.e. not by Eval()
method)</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>-----------------------</STRONG></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=andy@minstersystems.co.uk
href="mailto:andy@minstersystems.co.uk">Andy Lacey</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, May 04, 2003 23:12</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Eval not
working?</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=740464117-04052003><FONT face=Arial color=#0000ff
size=2>Sounds odd Ryan. It should work as you have it, and I'd certainly
expect Access to fail if the function name was incorrect. Have you stepped
through it in debug?</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk">http://www.minstersystems.co.uk</A><BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A>
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of
</B>Smethurst, Ryan<BR><B>Sent:</B> 02 May 2003 17:24<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD] Eval not
working?<BR><BR></FONT></DIV>
<P><B><I><FONT size=2>---- London Borough of Bromley E-Mail Disclaimer
----</FONT></I></B><I></I> <BR><FONT size=2>"For information about Bromley
Council visit our web site www.bromley.gov.uk"</FONT> </P>
<P><FONT size=2>"The information contained in this message (including any
attachments) is confidential in that it is intended solely for the use of
the recipient to which it is addressed. If you are not the intended
recipient, the use of the information by disclosure, copying or
distribution is prohibited and may be unlawful." </FONT></P>
<P><B><I><FONT size=2>---- End of Disclaimer ---- </FONT></I></B></P>
<P><FONT size=2>Hi All,</FONT> </P>
<P><FONT size=2>I have a series of functions that need to be run one after
the other.</FONT> </P>
<P><FONT size=2>They are all prefixed with the "Update_" and I was hoping
to simply loop through labels on a form to complete the names and
voila.</FONT></P>
<P><FONT size=2>But when I use:</FONT> </P>
<P><FONT size=2>strname = First then Second then Third etc etc
(example)</FONT> </P>
<P><FONT size=2>Eval("Update_" & strName & "()")</FONT> </P>
<P><FONT size=2>although I get no error, the function isn't called?</FONT>
</P>
<P><FONT size=2>Does anyone know why?</FONT> </P>
<P><FONT size=2>TIA</FONT> <BR><FONT size=2>RyanS</FONT> </P></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P></P></BLOCKQUOTE></BODY></HTML>