#Name, what reference to install?

  • Thread starter Thread starter Gregorio
  • Start date Start date
G

Gregorio

My users are encountering "#Name" on forms where I have formulas that create
dates displayed. As I know not all will have their .dll's in the same
location, what should I have them install to get this fixed?

Thanks in advance.
 
Gregorio,
It would have been helpful to include the calculation that fails (exactly
as it is on the form)... but...
This is most probably caused your calculation calling for a field value
that doesn't exist.
Price * Qty * TaxRte would cause a #Name? error because of the
misspelling of TaxRate.

Also, if you call for external values... like a value on another open
form...
=Forms!frmMyOtherForm!Price
if that form is not open at the time, you'll get a #Name?

Whatever field generates the Name error, one of those calculation values
is not available. I'm guessing that... because it works sometimes, and
other times not, that it might be an "external" problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top