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
Microsoft AccessVisual Basic ClassicVB Script
Last Comment
Gustav Brock
8/22/2022 - Mon
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
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
APD Toronto
ASKER
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.
Jeffrey Coachman
<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...
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
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
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
"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.
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