PC Review


Reply
Thread Tools Rate Thread

Australian dates in access

 
 
MR EDDD
Guest
Posts: n/a
 
      6th Jun 2010
Hey all,

I have a control box in my form that asks the user to enter a date. It then
takes the date and turns it into the default date so that it will show up on
the next record. It accepts the date and saves it to the table in the
correct format (dd/mm/yyyy) but then when it copies it over to the next form
it converts the date into american format (mm/dd/yyyy). I have worked out it
must be something to do with the code. This is what I currently have in the
relevant section of coding.

Private Sub DateFirstSession_AfterUpdate()
DateFirstSession.DefaultValue = "#" & DateFirstSession.Value & "#"
End Sub

Any assistance as to how I should code it so that it accepts the correct
date format would be greatly appreciated. I have my regional settings in
Windows correctly set to Australia and am using Access 2003.

--
cheers
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Australian Editors? Aalaan Microsoft Word New Users 5 27th Mar 2007 02:30 AM
Excel Dates to Access Dates (Julian) Michael Kintner Microsoft Access 3 28th Sep 2005 02:01 PM
How can I use a US Access file on an Australian Computer? =?Utf-8?B?YXViZHJlYW1zYmln?= Microsoft Access 7 20th May 2005 06:40 AM
Australian clients Stephen Microsoft Frontpage 2 11th Apr 2005 09:53 AM
import in australian dates =?Utf-8?B?RGFtbw==?= Microsoft Excel Misc 0 31st Mar 2005 08:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:40 PM.