<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: [AccessD] Eval not working?</TITLE>
</HEAD>
<BODY>
<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>Gustav,</FONT>
</P>
<P><FONT SIZE=2>That's what confused me, but I see that the code I inherited had 'On Error resume next' hidden away...I think that clears it up!</FONT></P>
<P><FONT SIZE=2>Thanks again for hte help.</FONT>
</P>
<P><FONT SIZE=2>RyanS</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Gustav Brock [<A HREF="mailto:gustav@cactus.dk">mailto:gustav@cactus.dk</A>]</FONT>
<BR><FONT SIZE=2>Sent: 06 May 2003 11:26</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: Re: [AccessD] Eval not working?</FONT>
</P>
<BR>
<P><FONT SIZE=2>---- London Borough of Bromley Security Notice ---- </FONT>
<BR><FONT 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><FONT SIZE=2>---- End of Notice ----</FONT>
</P>
<P><FONT SIZE=2>Hi Ryan</FONT>
</P>
<P><FONT SIZE=2>> Error found.</FONT>
<BR><FONT SIZE=2>> I was calling a sub and not a function...seems to work now.</FONT>
</P>
<P><FONT SIZE=2>But why didn't that throw an 2425 error?</FONT>
</P>
<P><FONT SIZE=2>/gustav</FONT>
</P>
<BR>
<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>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>