[AccessD] Function references produce #Name? error

Or a different version of a dll on the client machine.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Wednesday, March 28, 2007 4:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Function references produce #Name? error

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com