Date problems in Access97 developed Apps

SnowsAngel

Hi Everyone,

I am a newbie to this forum but am at my wits end.

I have a problem with Dates in Access. It is happening in two seperate
applications.

I am in Australia and need to have the Date format as dd/mm/yy.

When a date is entered into a field it is displayed correctly ie.
06/08/02

when it is returned to me via a msgBox popup for troubleshooting it is
displayed as 08/06/02 (US Format).

when the date is after the 12th of the month it is all working fine. It
only reverts to US format if the date is before the 12th.

Thanks
--
Posted via http://dbforums.com

Nov 12 '05 #1

Subscribe Post Reply

1512

BrW

msgbox format(YourDate,"yy/mm/dd")
--> or just another format
SnowsAngel <me*********@dbforums.com> wrote in message news:<33****************@dbforums.com>...

Hi Everyone,

I am a newbie to this forum but am at my wits end.

I have a problem with Dates in Access. It is happening in two seperate
applications.

I am in Australia and need to have the Date format as dd/mm/yy.

When a date is entered into a field it is displayed correctly ie.
06/08/02

when it is returned to me via a msgBox popup for troubleshooting it is
displayed as 08/06/02 (US Format).

when the date is after the 12th of the month it is all working fine. It
only reverts to US format if the date is before the 12th.

Thanks

Nov 12 '05 #2

Similar topics

QT problems

by: stu7 | last post by:

+ I have some problems with QT. I know that it is supposed to be useful for compiling cross-platform versions of a program, and that it has something to do with C++ ...not a problem so far. ...

C / C++

date function in access97

by: Internet Arrow Limited | last post by:

Hi, I have an access application that uses the code: > Me!txtCreationDate = Format(Date, "Long Date") & " " & Format(Time, "hh:mm:ss") This works fine under access 2000 and access97 on...

Microsoft Access / VBA

Query Records from a specific Date Range

by: Terry | last post by:

I have a database that I would like to query for a specific date range. I want to create a report based on this query that will pull any records from the last 7 days. Is this possible? Can...

Microsoft Access / VBA

Highlight the date on the calendar control

by: JingleBEV | last post by:

Hi all, I have a masked text control that would return a date in string format via the mask property like: "9/23/2004" and i have a calendar control that would pop up when I click a command...

Microsoft Access / VBA

Upgrade issues from 97 to 2003 - references? DATE LEFT and FORMAT give compile errors

by: arthur-e | last post by:

A new Machine was set up by our IS department - it came with Office Pro 2003. Access97, Word97 and Excel 97 were added. I'm trying to update an Access 97database to 2003 but get weird compiling...

Microsoft Access / VBA

VB.net Access97

by: campbellbrian2001 | last post by:

I still use Access97 for countless legacy apps, and no later editions of Access due to writing some of my front-end interfaces written in VB 6.0, and still loyal to A97. I purchased VB.net 2003 and...

Microsoft Access / VBA

Uhmmm, problems with framework...

by: Sueffel | last post by:

Okay, I have Framwork v1.0 on my devel machine, VS.NET 2002. On my workstations, I have Framework v1.1 (Redistributable) installed. Everything runs fine on my test machine, and it does not run on...

Visual Basic .NET

Using Access97 with sql server 2005 - issues ?

by: lesperancer | last post by:

currently using access97 to link to sql7 tables sql7 is running on NT4 and terminal server 2000 in the process of upgrading hardware and software to latest stable versions citrix - windows 2003...

Microsoft Access / VBA

End-Of-Life Date for Classic ASP?

by: =?Utf-8?B?RHlsYW5TbWl0aA==?= | last post by:

Is there an end-of-support date for Classic ASP? For example, I know that VB6 standard support ended sometime around March 2005, and extended support was available until around March 2008. Is...

ASP / Active Server Pages

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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

C / C++