International Dates and Fonts

[Jim Bunton]

Access 2000 win 2k

I have an aplication runnin ok on computers with a UK set up.

On one in Thailand the dates entry is proving a problem
e.g "27/09/05" > "37/05/31"

and 'some' text appears in Thai.

Is there any solution other than adjusting the Windows international
settings?

Jim Bunton

 

[Guest]

You do realize Thailand uses a different callendar. The 37 is probably the
year 2537 in their calendar.

 

[Jim Bunton]

Well thanks for that Karl - no it hadn't crossed my mind that Thailand uses
a different callender. But, there again I hadn't imagined that the
application was going to be used on a machine set up for the Thai callender
either!

Jim

 

[Jim Bunton]

Any suggestions about how to solve the problem without recourse to altering
the windows settings will be appreciated

Jim B

 

[Guest]

I am assuming you tried changing the formating.

Did you check the data to verify my comment about a different calendar? Did
you check the numerical valuue of the date showing 37/5/1?
Date Numer
5/1/2037 50161
5/1/2537 232782

 

[Jim Bunton]

Thanks for the response Karl:

The data on the Thai machine is ONLY BEING VIEWED (neither edited or
inserted) - the data was entered on the 'English' machine.

All dates on all forms are formatted 'short date'. I can't find anything in
'format' which determins the language for display purposes.

So what it comes down to I guess is - is there any way of determining WITHIN
an Access application that the data [dates and is possible fonts] is assumed
to be 'English' despite what the Windows setting it is running on are.

 

[Guest]

You did not say if you had checked the numerical value of the date.

Open a query in design view and use this in a column --
Date Number: CVDate([YourDateField])

Click in the column and then on the menu VIEW select Properties. In the
Format put a # symbol.

Run the query. You should get the numerical value for the date.
Date Numer
5/1/2037 50161
5/1/2537 232782
10/7/5 38632

Thanks for the response Karl:

The data on the Thai machine is ONLY BEING VIEWED (neither edited or
inserted) - the data was entered on the 'English' machine.

All dates on all forms are formatted 'short date'. I can't find anything in
'format' which determins the language for display purposes.

So what it comes down to I guess is - is there any way of determining WITHIN
an Access application that the data [dates and is possible fonts] is assumed
to be 'English' despite what the Windows setting it is running on are.

I am assuming you tried changing the formating.

Did you check the data to verify my comment about a different calendar? Did
you check the numerical valuue of the date showing 37/5/1?
Date Numer
5/1/2037 50161
5/1/2537 232782

 

[Jim Bunton]

Thanks again for your reply Karl:-
I don't have the data!!! the users have that! One of them reported the
problem.

Only ONE instance of it is used for entering updating the data. This works
fine (the English set up machine). The data can be looked at only by others
but not edited. It's here that the problems has been reported. As it's non
updateable/editable I can only assume that on the editable version all is
ok - they haven't reported any problem.

Jim

You did not say if you had checked the numerical value of the date.

Open a query in design view and use this in a column --
Date Number: CVDate([YourDateField])

Click in the column and then on the menu VIEW select Properties. In the
Format put a # symbol.

Run the query. You should get the numerical value for the date.
Date Numer
5/1/2037 50161
5/1/2537 232782
10/7/5 38632

Thanks for the response Karl:

The data on the Thai machine is ONLY BEING VIEWED (neither edited or
inserted) - the data was entered on the 'English' machine.

All dates on all forms are formatted 'short date'. I can't find anything in
'format' which determins the language for display purposes.

So what it comes down to I guess is - is there any way of determining WITHIN
an Access application that the data [dates and is possible fonts] is assumed
to be 'English' despite what the Windows setting it is running on are.

I am assuming you tried changing the formating.

Did you check the data to verify my comment about a different

calendar?
Did

you check the numerical valuue of the date showing 37/5/1?
Date Numer
5/1/2037 50161
5/1/2537 232782

:

Any suggestions about how to solve the problem without recourse to altering
the windows settings will be appreciated

Jim B

Well thanks for that Karl - no it hadn't crossed my mind that Thailand
uses
a different callender. But, there again I hadn't imagined that the
application was going to be used on a machine set up for the Thai
callender
either!

Jim

You do realize Thailand uses a different callendar. The 37 is probably
the
year 2537 in their calendar.

:

Access 2000 win 2k

I have an aplication runnin ok on computers with a UK set up.

On one in Thailand the dates entry is proving a problem
e.g "27/09/05" > "37/05/31"

and 'some' text appears in Thai.

Is there any solution other than adjusting the Windows international
settings?

Jim Bunton