Smethurst, Ryan
ryan.smethurst at bromley.gov.uk
Tue May 6 04:58:01 CDT 2003
---- London Borough of Bromley E-Mail Disclaimer ---- "For information about Bromley Council visit our web site www.bromley.gov.uk" "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." ---- End of Disclaimer ---- Ok, Error found. I was calling a sub and not a function...seems to work now. Thanks for the help. RyanS -----Original Message----- From: A.D.Tejpal [mailto:ad_tp at hotmail.com] Sent: 06 May 2003 08:16 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Eval not working? ---- London Borough of Bromley Security Notice ---- "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." ---- End of Notice ---- Ryan, 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. 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) Regards, A.D.Tejpal ----------------------- ----- Original Message ----- From: Andy Lacey <mailto:andy at minstersystems.co.uk> To: accessd at databaseadvisors.com <mailto:accessd at databaseadvisors.com> Sent: Sunday, May 04, 2003 23:12 Subject: RE: [AccessD] Eval not working? 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? Andy Lacey http://www.minstersystems.co.uk <http://www.minstersystems.co.uk> -----Original Message----- From: accessd-bounces at databaseadvisors.com <mailto:accessd-bounces at databaseadvisors.com> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Smethurst, Ryan Sent: 02 May 2003 17:24 To: 'accessd at databaseadvisors.com' Subject: [AccessD] Eval not working? ---- London Borough of Bromley E-Mail Disclaimer ---- "For information about Bromley Council visit our web site www.bromley.gov.uk" "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." ---- End of Disclaimer ---- Hi All, I have a series of functions that need to be run one after the other. 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. But when I use: strname = First then Second then Third etc etc (example) Eval("Update_" & strName & "()") although I get no error, the function isn't called? Does anyone know why? TIA RyanS _____ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030506/12051c94/attachment-0001.html>