How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
Course Of The Month
4 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Script to Change Format
Posted on 2012-12-20
Hi Experts,
Is it possible to write a VBA Code to check if the system's Short Date format is mm/dd/yyyy, and change it if isnt?
Thank you
Is it possible to write a VBA Code to check if the system's Short Date format is mm/dd/yyyy, and change it if isnt?
Thank you
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4
3
2- +3
13 Comments
Active today
Just a comment - as opposed to a solution.
Seems doing so could really piss off a user(s) who wants that Format.
Instead, why not hard code the format you want to display in a Control's Format property and/or in code. This will override the Windows whatever format.
This is what I do ... as I prefer mm-dd-yyyy
mx
Seems doing so could really piss off a user(s) who wants that Format.
Instead, why not hard code the format you want to display in a Control's Format property and/or in code. This will override the Windows whatever format.
This is what I do ... as I prefer mm-dd-yyyy
mx
Active 1 day ago
pissing off the user would be a bonus :)
the application is huge, and dates are used in literaly 100s of places, so my solution above is most economical.
the application is huge, and dates are used in literaly 100s of places, so my solution above is most economical.
Active 7 days ago
<the application is huge, and dates are used in literaly 100s of places, so my solution above is most economical. >
By "100s of places", ...do you mean geographic locations?
(different countries)
Because changing this for all computers in all countries may cause problems...
There may be some utilities installed on some machines that need a different date setting...
Is there a specific issue you are having...?
Like MX, I am just a bit wary of just blowing though and making this change for all computers...
...When a change to the date format in Access may be all that is really needed...
In any event, a link to investigate:
http://en.allexperts.com/q/Excel-1059/2010/9/change-Regional-Setting-short.htm
JeffCoachman
By "100s of places", ...do you mean geographic locations?
(different countries)
Because changing this for all computers in all countries may cause problems...
There may be some utilities installed on some machines that need a different date setting...
Is there a specific issue you are having...?
Like MX, I am just a bit wary of just blowing though and making this change for all computers...
...When a change to the date format in Access may be all that is really needed...
In any event, a link to investigate:
http://en.allexperts.com/q/Excel-1059/2010/9/change-Regional-Setting-short.htm
JeffCoachman
Active 1 day ago
Because changing this for all computers in all countries may cause problems...
WOW. It's one office, 300 sqft with 7-10 PCs.
What i meant by 100 places was, something like 30 forms + 50 sub routines + 20 queries = 100 places
Active today
Just curious ... does the Format really matter since it has not bearing on how the date is actually stored in a table internally ?
Active 7 days ago
MX,
I'll leave this to you...
I gotta get started on the Holiday stuff...
;-)
Jeff
I'll leave this to you...
I gotta get started on the Holiday stuff...
;-)
Jeff
Hi, I guess it's up to you whether you want to make your system more robust, or just force the change of the "short date format" by using this code:
Regards,
Rob.
Set objShell = CreateObject("WScript.Shell")
sDateFormat = objShell.RegRead("HKCU\Control Panel\International\sShortDate")
If sDateFormat <> "mm/dd/yyyy" Then objShell.RegWrite "HKCU\Control Panel\International\sShortDate", "mm/dd/yyyy", "REG_SZ"
Regards,
Rob.
Active today
You have to deal with possible different Windows settings for the users, as in a properly set up environment, users will not have been granted permission to change the date and time settings.
The method is simple; whenever a date/time is displayed, set the Format property of the textbox to: mm/dd/yyyy
/gustav
The method is simple; whenever a date/time is displayed, set the Format property of the textbox to: mm/dd/yyyy
/gustav
Private Const LOCALE_SSHORTDATE = &H1F
Private Const WM_SETTINGCHANGE = &H1A
Private Const HWND_BROADCAST = &HFFFF&
Private Declare Function SetLocaleInfo Lib "kernel32" Alias _
"SetLocaleInfoA" ( _
ByVal Locale As Long, _
ByVal LCType As Long, _
ByVal lpLCData As String) As Boolean
Private Declare Function PostMessage Lib "user32" Alias _
"PostMessageA" ( _
ByVal hwnd As Long, _
ByVal wMsg As Long, _
ByVal wParam As Long, _
ByVal lParam As Long) As Long
Private Declare Function GetSystemDefaultLCID Lib "kernel32" () As Long
Sub chgDate()
Dim dwLCID As Long
Dim myDate As String
dwLCID = GetSystemDefaultLCID()
If SetLocaleInfo(dwLCID, LOCALE_SSHORTDATE, "dd/MM/yyyy") = False Then
MsgBox "Failed"
Exit Sub
End If
PostMessage HWND_BROADCAST, WM_SETTINGCHANGE, 0, 0
End Sub
Private Const WM_SETTINGCHANGE = &H1A
Private Const HWND_BROADCAST = &HFFFF&
Private Declare Function SetLocaleInfo Lib "kernel32" Alias _
"SetLocaleInfoA" ( _
ByVal Locale As Long, _
ByVal LCType As Long, _
ByVal lpLCData As String) As Boolean
Private Declare Function PostMessage Lib "user32" Alias _
"PostMessageA" ( _
ByVal hwnd As Long, _
ByVal wMsg As Long, _
ByVal wParam As Long, _
ByVal lParam As Long) As Long
Private Declare Function GetSystemDefaultLCID Lib "kernel32" () As Long
Sub chgDate()
Dim dwLCID As Long
Dim myDate As String
dwLCID = GetSystemDefaultLCID()
If SetLocaleInfo(dwLCID, LOCALE_SSHORTDATE, "dd/MM/yyyy") = False Then
MsgBox "Failed"
Exit Sub
End If
PostMessage HWND_BROADCAST, WM_SETTINGCHANGE, 0, 0
End Sub
Active today
"as in a properly set up environment, users will not have been granted permission to change the date and time settings."
Especially at our LARGE company now that Win7 is being deployed ... total lock down ... barely can write to Registry at all.
mx
Especially at our LARGE company now that Win7 is being deployed ... total lock down ... barely can write to Registry at all.
mx
Active today
Yeah, same goes for changing screen resolution - popular in the days of CRT monitors - a big no-no.
/gustav
/gustav
Active today
Well .. users here can manually change screen res of course ... many still use 800x600 on 24" dual monitors! Can you say" I cant' see' !
Featured Post
Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Course of the Month4 days, 1 hour left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.