将系统日期自动改为YYYY.MM.DD的代码

最新推荐文章于 2021-06-05 02:00:33 发布

Accessoft-麥田

最新推荐文章于 2021-06-05 02:00:33 发布

阅读量710

点赞数

分类专栏： Access函数代码文章标签： function string

本文链接：https://blog.csdn.net/chuyuchun/article/details/7610544

版权

Access函数代码专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Option Compare Database
Option Explicit

Public Declare Function GetUserDefaultLCID Lib "kernel32" () As Long
Public Declare Function GetLocaleInfo Lib "kernel32" Alias "GetLocaleInfoA" (ByVal Locale As Long, ByVal LCType As Long, ByVal lpLCData As String, ByVal cchData As Long) As Long
Public Declare Function SetLocaleInfo Lib "kernel32" Alias "SetLocaleInfoA" (ByVal Locale As Long, ByVal LCType As Long, ByVal lpLCData As String) As Long
'设置短日期格式
Public Const LOCALE_SSHORTDATE = &H1F
Public Const LOCALE_SDATE = &H1D

'下面的过程可以帮你达到目的

Sub setshortdate()

    Dim llocal As Long
    Dim sa     As String
    Dim lOk    As Long
    Dim setlocalinfo As Variant
    On Error GoTo ErrShow
    sa = Space(20)
    llocal = GetUserDefaultLCID()
    lOk = GetLocaleInfo(llocal, LOCALE_SSHORTDATE, ByVal sa, 20)
    If Trim(sa) <> "yyyy-MM-dd" Then
        MsgBox "您的系统日期不是(YYYY-MM-DD)格式,点击确定,自动更改格式"
        'If MsgBox("您的系统日期不是(YYYY-MM-DD)格式，强烈建议您将它修改成该格式," & Chr(10) _
         & "否则软件可能会出现运行障碍！" _
         & Chr(10) & Chr(10) & "点击'是'将自动为您修改。", vbQuestion + vbYesNo, "忠告") = vbYes Then
        sa = "yyyy-MM-dd"
        llocal = GetUserDefaultLCID()
        SetLocaleInfo llocal, LOCALE_SSHORTDATE, ByVal sa
        'End If
    End If
    sa = Space(2)
    lOk = GetLocaleInfo(llocal, LOCALE_SDATE, ByVal sa, 2)
    If Trim(sa) <> "-" Then
        sa = "-"
        lOk = SetLocaleInfo(llocal, LOCALE_SDATE, ByVal sa)
    End If
    setlocalinfo = True
    Exit Sub
ErrShow:
    MsgBox "系统日期不能自动设置为（2002-01-01）的格式" & vbCrLf & "请用手工先把系统日期改为如（2002-01-01）的格式，再运行本系统！"
End Sub