Date Returns #Name - Microsoft Access / VBA

Paolo

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 txtFirstDayOfMo nth.

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

Subscribe Reply

10218

Allen Browne

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.goo gle.com...

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 txtFirstDayOfMo nth.

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

Similar topics

7107

Date Time Picker and empty databases

by: Adrian Parker | last post by:

Hi. I have a date time picker in my program which uses ADO to read from an Access database. It works perfectly, unless the database is empty (no records) when opened. When you try to open an empty database, the date time picker returns error 545. Any attempts to progmatically add new records after the empty database has been opened returns, or to use the DTP and set a new date for those added records, "Field not updateable, Bound...

Visual Basic 4 / 5 / 6

4566

Creating Report Date

by: Chris Curtis | last post by:

We have a program which is used to upload data to our website. A report file is saved each time and is supposed to reflect the date! Not being a java programmer I think the following code is used to create the report name. try { copy("C:\\MDSPROXY\\REPORT\\eventLog.txt", "C:\\MDSPROXY\\REPORT\\"+ new java.util.Date().getYear() + new java.util.Date().getMonth() + new java.util.Date().getDay() + new java.util.Date().getHours() + new...

Java

9449

PEP 321: Date/Time Parsing and Formatting

by: Gerrit Holl | last post by:

Posted with permission from the author. I have some comments on this PEP, see the (coming) followup to this message. PEP: 321 Title: Date/Time Parsing and Formatting Version: $Revision: 1.3 $ Last-Modified: $Date: 2003/10/28 19:48:44 $ Author: A.M. Kuchling <amk@amk.ca> Status: Draft Type: Standards Track

Python

11705

Date Validation - Disallow Past Dates

by: Dale | last post by:

Hi Everyone, I've got a form that provides a pop-up calendar for users to select dates for requesting jobs to be completed. The calendar works great, but it unfortunately allows users to select dates earlier than today (which they should't be allowed to do). I've started coding some validation scripts, but I'm stuck now and my approach doesn't seem to be working. I've Googled all morning looking for an answer and couldn't find one and

Javascript

4851

validation of date and set focus problem

by: MickG | last post by:

Hi, I am trying to validate these values, this seems to work fine for the phone number and name but I am trying to get the program to fail to submit and set the focus on the date when 2006 is selected and submitted. Thanks in advance for any help.

Javascript

3693

Cannot parse an en-US date on a non-en-US system!

by: Jon Davis | last post by:

I have put my users through so much crap with this bug it is an absolute shame. I have a product that reads/writes RSS 2.0 documents, among other things. The RSS 2.0 spec mandates an en-US style of date formatting (RFC 822). I have been using a variation of RFC 1123 (just change the time zone to an offset, i.e. "-0800"). It seems to be writing okay, but it's failing to parse. I've tried changing the regional & language settings in my...

C# / C Sharp

10578

Date format

by: shsandeep | last post by:

I used the following query to retrieve the date in dd-mon-yyyy format. db2 => SELECT RTRIM(CHAR(DAY(COVG_TYP_STRT_DT))) || '-' || RTRIM(MONTHNAME(COVG_TYP_STRT_DT)) || '-' || RTRIM(CHAR(YEAR(COVG_TYP_STRT_DT))) FROM twd_coverage_type 1 ---------------------------------------------------------------------------------------------------------------------------- 6-May-2006 1 record(s) selected.

DB2 Database

12948

Converting Date Time Format

by: Alok yadav | last post by:

i am using a webservice in which a method is serach. i use this method which accept a argument of date type in dd/MM/yyyy formate. i have a textbox which accept the date from the user, when i convert textbox data into Datatime formate it converted into MM/dd/yyyy formate, but i have a requirement in dd/MM/yyyy formate. please help me, i am using c#.

ASP.NET

3956

Need help with date output program

by: erekose666 | last post by:

I need a java prog to do the following: Create class Date with the following capabilities: a) Output the date in multiple formats, such as: MM/DD/YYYY June 14, 2005 DDD YYYY b) Use overloaded constructors to create Date objects initialized with dates of the formats in part (a). In the first case the constructor should receive three integer values. In the second case it should receive a String and two integer values. In the third...

Java

1839

Query mutiple tables with date input.

by: wevans | last post by:

I have 3 tables, Customer, Offsite Service and service. I need to create a sales report/query based on the results of the user input, which is a date range. I've got it working great with two of the tables, but not the third. Here's the code for the working one I have now. SELECT ., ., First(.Date) AS , Sum(.Price) AS Price FROM INNER JOIN ON .ID = .ID GROUP BY ., ., . HAVING (((First(.Date))>= And (First(.Date))<)) ORDER BY .; Now...

Microsoft Access / VBA

10309

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10289

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9119

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6840

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5496

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5625

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4274

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3795

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2968

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General