system time

[iccsi]

I would like to have my system time on the report in French, but in
English Windows system.

I know that when I have now( ) function that Windows give us system
time base on Windows language for example English.

I would like to know is it possible to overwrite it base on user
select language in the applicaiton and print out different language,
but using English Windows.


Your help is great appreciated,

 

[Stefan Hoffmann]

hi,

I would like to have my system time on the report in French, but in
English Windows system.

Change your locales.

I know that when I have now( ) function that Windows give us system
time base on Windows language for example English.

Otherwise use Format().

mfG
--> stefan <--

 

[iccsi]

hi,


Change your locales.


Otherwise use Format().

mfG
--> stefan <--

Thanks for the information,

 

[iccsi]

hi,


Change your locales.


Otherwise use Format().

mfG
--> stefan <--

Thanks again,
Format gives English result,
I just wonder can I configure system Windows Region at run time and
set it back to original setting that can makes report print French
data and time in English enviroment?

If it is, are ther any sample code for this?

Your help is great appreciated,

 

[John Spencer]

Unfortunately, I think your only option might be to use a translation table
and roll your own date string based on that. If you only needed to do it for
one or two instances you might use an expression like the following.

Day(SomeDate) & " " &
DLookup("FrenchMonthName","TranslateTable","MonthNumber=" & Month(SomeDate) &
" " & Year(SomeDate)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[iccsi]

Unfortunately, I think your only option might be to use a translation table
and roll your own date string based on that.  If you only needed to do it for
one or two instances you might use an expression like the following.

Day(SomeDate) & " " &
DLookup("FrenchMonthName","TranslateTable","MonthNumber=" & Month(SomeDate) &
" " & Year(SomeDate)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County







- Show quoted text -

Thanks millions for helping,