[AccessD] Function references produce #Name? error

Stuart McLachlan stuart at lexacorp.com.pg
Wed Mar 28 18:20:44 CDT 2007


SOunds like a missing reference. In the VBE, go to Tools-References 
and look for one with an X beside it.  

On 28 Mar 2007 at 11:09, John Porter wrote:

> When I installed an Access 2003 application on a client's machine, I
> found that, if the control source of a text box is an expression
> including a function reference (e.g. Ucase('a')) the text box displays a
> #Name? error. This happens even if I choose to 'unblock unsafe
> expressions' when opening the app., or set macro security to low.
> 
> Functions evaluate correctly in VBA code. In a new app. created on the
> client's machine, function refs. work OK in a text box, and if I import
> the objects from the problem app., everything works fine.
> 
> I'd be really grateful if anyone could suggest an explanation or
> solution of this problem.
> 
> Regards,    
> 
> 
> John R. Porter
> IT Services
> University of Strathclyde
> Jordanhill Campus
> 86 Southbrae Drive
> Glasgow
> G13 1PP
> e-mail: j.r.porter at strath.ac.uk
> Tel.: 0141 950 3289
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list