Reading sShortDate value from registry

[beatZin]

I simply want to get this value into a variable in an access module.

Knowledge is power
Power is Mon£y

 

[rdodge]

You can get the code from:

http://www.mvps.org/vbnet/code/locale/localedates.htm

Once you get the code, you could then use the following code:

Dim LCID as Long, DateSep as String

LCID = GetSystemDefaultLCID()
DateSep = GetUserLocaleInfo(LCID, LOCALE_SDATE)

The code from the above web site should be in a standard module all to itself, which then you would use the code that I typed in within the same module that you are needed to use it for.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

 

[beatZin]

Great worked fine but had to change LOCALE_SDATE to LOCALE_SSHORTDATE to get the value i really wanted.

Cheers

Knowledge is power
Power is Mon£y

 

[rdodge]

Glad to be of assistance in pointing you to the source that would help.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000