Hi,
I don't know what happened, but all the MS Access dates in all tables,
queries, forms, and reports in all databases suddenly show on my
computer with the year as 4 digits (including network databases I
access on my computer). It used to always be 2 digits.
I have been changing the format of dates in all my databases tables,
queries, forms, and reports to mm/dd/yy and that was working for a
while. But today, the reports I made this change would no longer open
in design more or report mode.
Even when it works, this method is tedious and time-consuming.
If someone knows how to fix this, will they please let me know?
MHenry 5 1310
"MHenry" <MH****@NoSpam.net> wrote in message
news:sp********************************@4ax.com... Hi,
I don't know what happened, but all the MS Access dates in all tables, queries, forms, and reports in all databases suddenly show on my computer with the year as 4 digits (including network databases I access on my computer). It used to always be 2 digits.
I have been changing the format of dates in all my databases tables, queries, forms, and reports to mm/dd/yy and that was working for a while. But today, the reports I made this change would no longer open in design more or report mode.
Even when it works, this method is tedious and time-consuming.
If someone knows how to fix this, will they please let me know?
If you use a *named* format (short, medium, long, currency, etc.), then
Access uses the definitions of these as set in the Windows Regional
Settings of Control Panel. My guess is that your regional setting was
recently changed.
If you use a format property string (mm/dd/yy, yyyy-m-d, #0.00, etc.) then
they should always be honored regardless of regional settings.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
MHenry <MH****@NoSpam.net> wrote in news:sp3090png0ap1lqv7ot0grr0ek1shlhn9h@
4ax.com: I don't know what happened, but all the MS Access dates in all tables, queries, forms, and reports in all databases suddenly show on my computer with the year as 4 digits (including network databases I access on my computer). It used to always be 2 digits.
Give thanks!
I have been changing the format of dates in all my databases tables, queries, forms, and reports to mm/dd/yy and that was working for a while.
That's incredible.
But today, the reports I made this change would no longer open in design more or report mode.
Access is a just program.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Thank you, Rick.
I changed my short date to the way I wanted it in my Regional
Settings. All is well in Smallville again.
I have no idea how it got changed, but I guess it must have.
Maybe some program I recently installed did it?
Actually, I have updated a couple of programs. bit installed no new
programs.
Maybe it could have been a Windows Update?
If so, I guess some other people would have the same problem.
MHenry
On Wed, 28 Apr 2004 15:44:24 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote: "MHenry" <MH****@NoSpam.net> wrote in message news:sp********************************@4ax.com.. . Hi,
I don't know what happened, but all the MS Access dates in all tables, queries, forms, and reports in all databases suddenly show on my computer with the year as 4 digits (including network databases I access on my computer). It used to always be 2 digits.
I have been changing the format of dates in all my databases tables, queries, forms, and reports to mm/dd/yy and that was working for a while. But today, the reports I made this change would no longer open in design more or report mode.
Even when it works, this method is tedious and time-consuming.
If someone knows how to fix this, will they please let me know?
If you use a *named* format (short, medium, long, currency, etc.), then Access uses the definitions of these as set in the Windows Regional Settings of Control Panel. My guess is that your regional setting was recently changed.
If you use a format property string (mm/dd/yy, yyyy-m-d, #0.00, etc.) then they should always be honored regardless of regional settings.
"MHenry" <MH****@NoSpam.net> wrote in message
news:ln********************************@4ax.com... Thank you, Rick.
I changed my short date to the way I wanted it in my Regional Settings. All is well in Smallville again. I have no idea how it got changed, but I guess it must have. Maybe some program I recently installed did it? Actually, I have updated a couple of programs. bit installed no new programs. Maybe it could have been a Windows Update? If so, I guess some other people would have the same problem.
That's why if you really care you should avoid the named constants. If your
app is used by others the format will follow whatever their regional
settings are. Why would you want a 2 digit year anyway? Did you forget
about that mess a while back already :-)
On Wed, 28 Apr 2004 21:24:21 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote: "MHenry" <MH****@NoSpam.net> wrote in message news:ln********************************@4ax.com.. . Thank you, Rick.
I changed my short date to the way I wanted it in my Regional Settings. All is well in Smallville again. I have no idea how it got changed, but I guess it must have. Maybe some program I recently installed did it? Actually, I have updated a couple of programs. bit installed no new programs. Maybe it could have been a Windows Update? If so, I guess some other people would have the same problem. That's why if you really care you should avoid the named constants. If your app is used by others the format will follow whatever their regional settings are. Why would you want a 2 digit year anyway? Did you forget about that mess a while back already :-)
Hi, Rick,
I gave a passing thought to the Y2K hoopla as I muddled through this,
but my reasons for wanting 2 year display are for space and
consistency. I have many columns in my tables and subforms and I like
to see as many of the columns as possible without scrolling. I had to
increase my column widths to see the full date when it switched to
four digits. The chance for confusion in dates is slight as my
databases are rather small, limited to my clients and their financial
activities. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Orson |
last post by:
I have a page that uses the javascript Date() function to retrieve a date
from the client computer.
The date is then inserted into a note that is saved on a database. The date
is in the format...
|
by: koray |
last post by:
hi everyone,
in my form i have to take some date information in dd-mm-yy format.
but i don't want user to use tabs while typing. for example s/he
should simply type 280104 but 28/01/04 must...
|
by: Dr John Stockton |
last post by:
It has appeared that ancient sources give a method for Numeric Date
Validation that involves numerous tests to determine month length;
versions are often posted by incomers here. That sort of code...
|
by: sgershon |
last post by:
Hi.
I know this is should be a simple question.
I know server-side web-programming, and never needed to use client-side
scripting... until now :)
I have done so far a little number of scripts...
|
by: MHenry |
last post by:
Hi,
I don't know what happened, but all the MS Access dates in all tables,
queries, forms, and reports in all databases suddenly show on my
computer with the year as 4 digits (including network...
|
by: vgame64 |
last post by:
Hi, I have been struggling with writing a program for a few hours. The
requirements are that: """You will be writing a program which will
determine whether a date is valid in
terms of days in that...
|
by: mistral |
last post by:
Need help to remove list of days from date script. Need format "June
07, 2006"
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
// Get today's current date.
var now = new Date();
|
by: Bill |
last post by:
I have a 200 record database that includes a date/time field,
AnnivDate, for a wedding anniversary. AnnivDate has nulls and some
incorrect year data. I have been creating the Access database...
|
by: pradeepjain |
last post by:
<script language = "Javascript">
/**
* DHTML date validation script. Courtesy of SmartWebby.com (http://www.smartwebby.com/dhtml/)
*/
// Declaring valid date character, minimum year and maximum...
|
by: gubbachchi |
last post by:
Hi all,
In my application I need to display the data fetched from mysql database after the user selects date from javascript calender. I have written the code in which after the user selects the...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
|
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...
|
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,...
| |