system time

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
hi,
I would like to have my system time on the report in French, but in
English Windows system.
Click to expand...
Change your locales.
I know that when I have now( ) function that Windows give us system
time base on Windows language for example English.
Click to expand...
Otherwise use Format().

mfG
--> stefan <--
 
hi,


Change your locales.


Otherwise use Format().

mfG
--> stefan <--
Click to expand...

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,
 
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
 
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 -
Click to expand...

Thanks millions for helping,
 
Back
Top