By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Date Returns #Name

P: n/a
Friends,
I have created a database in Access 97 based on two splitted files.
This application has been running and used by a couple of hundreds of
users in different Offices around the World. I have just been informed
that in two cases users are having problems in viewing date fields.
What they are seeing is #Name instead of the Date function I have
written behind several fields.

Please note that none of my fields (all text boxes) are named DATE.
They all start with txt and then followed by the name of the function
I need.
For example txtFirstDayOfMonth.

What is strange is that the program is used on a LAN and only one user
out of 20 is having the problem.

All Date and Regional settings are correct and just cannot find the
problem.

I have looked up Google database and found various tips on this.

All users are working on Windows NT, Office 97 and all reference are
correct.
THere are no missing references to map to.

Please, does any one have any idea?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Paolo, you say the references are correct, but I think it's worth
double-checking that:

1) The path to each reference is correct, e.g.:
? Dir(Application.References(3).FullPath)

2) There are no other dlls with the same name anywhere on path or in the
Access program folder. Duplicate dlls were a source of failure, esp. in A97
and earlier.

3) The specified dll is the correct version for each reference. (At the same
time, check the service pack of the machines where it fails).
It's less likely that it is a date formatting problem, but today is the
13th. There is still the chance that these workstations are interpreting the
date entries incorrectly and failing because there is no 13th month. If
these text boxes are unbound, setting their Format property to General Date
defines the data type. If they are based on calculated query fields,
wrapping the calculation in CVDate() helps. If they the query has a
parameter, explicitly declare the parameter.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Paolo" <jp***@tin.it> wrote in message
news:9f**************************@posting.google.c om...
Friends,
I have created a database in Access 97 based on two splitted files.
This application has been running and used by a couple of hundreds of
users in different Offices around the World. I have just been informed
that in two cases users are having problems in viewing date fields.
What they are seeing is #Name instead of the Date function I have
written behind several fields.

Please note that none of my fields (all text boxes) are named DATE.
They all start with txt and then followed by the name of the function
I need.
For example txtFirstDayOfMonth.

What is strange is that the program is used on a LAN and only one user
out of 20 is having the problem.

All Date and Regional settings are correct and just cannot find the
problem.

I have looked up Google database and found various tips on this.

All users are working on Windows NT, Office 97 and all reference are
correct.
THere are no missing references to map to.

Please, does any one have any idea?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.