#Name? Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing a database and simple functions such as Left$([Field],1) that work on my PC's display the error #Name? on all the customers PC's.
I have re-installed Office 2000 (including running Office eraser) this has made no difference.
They are running a Server based network but can not understand how that would be relevant.
I have checked that Msowcf.dll (as suggested in Help) is in the Office directory.
The customer runs a variety of OS including 98 & XP.
Thanks in advance John
 
You are mispelling the name of the field. If the fieldname has spaces, it
must be enclosed in brackets [].

--
Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk
Reply Only To The Newsgroup


John said:
I am developing a database and simple functions such as Left$([Field],1)
Click to expand...
that work on my PC's display the error #Name? on all the customers PC's.
 
No sorry, the expression works on most PC's so it is spelt correctly.

John
Jesse Aviles said:
You are mispelling the name of the field. If the fieldname has spaces, it
must be enclosed in brackets [].

--
Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk
Reply Only To The Newsgroup


John said:
I am developing a database and simple functions such as Left$([Field],1)
Click to expand...
that work on my PC's display the error #Name? on all the customers PC's.
I have re-installed Office 2000 (including running Office eraser) this
Click to expand...
has
made no difference.
They are running a Server based network but can not understand how that would be relevant.
I have checked that Msowcf.dll (as suggested in Help) is in the Office directory.
The customer runs a variety of OS including 98 & XP.
Thanks in advance John
Click to expand...
Click to expand...
 
John,

I believe the std response here is ' check the References'.
Losing standard built-in functions is often a symptom of broken references.
In the VBA editor, Tools | References, anything showing up as MISSING ?

CD

John said:
I am developing a database and simple functions such as Left$([Field],1)
Click to expand...
that work on my PC's display the error #Name? on all the customers PC's.
 
Check the data source (in the properties window) and make sure that it
points to the correct field and the form has the correct data source
(sometimes it points to a broken link specially if you install a front end
to various computers).

--
Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk
Reply Only To The Newsgroup


John said:
I am developing a database and simple functions such as Left$([Field],1)
Click to expand...
that work on my PC's display the error #Name? on all the customers PC's.
 
Thank you for yur ideas, problem now solved.
The error was that an 'Active X' component I use on my system was showing as
MISSING, remove this reference and all is well!
Thanks again
Jesse Aviles said:
Check the data source (in the properties window) and make sure that it
points to the correct field and the form has the correct data source
(sometimes it points to a broken link specially if you install a front end
to various computers).

--
Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk
Reply Only To The Newsgroup


John said:
I am developing a database and simple functions such as Left$([Field],1)
Click to expand...
that work on my PC's display the error #Name? on all the customers PC's.
I have re-installed Office 2000 (including running Office eraser) this
Click to expand...
has
made no difference.
They are running a Server based network but can not understand how that would be relevant.
I have checked that Msowcf.dll (as suggested in Help) is in the Office directory.
The customer runs a variety of OS including 98 & XP.
Thanks in advance John
Click to expand...
Click to expand...
 
Back
Top