[AccessD] Function references produce #Name? error

There were no missing references, but adding or deleting a reference
(any reference, it appears) fixed the problem. This wasn't just because
the change caused decompilation, because a trivial change to the code
had no effect.

My thanks to all who contributed suggestions.

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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: 29 March 2007 00:21
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