Re: getting errors from Europe

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jezebel (dwarves_at_heaven.com.kr)
Date: 07/25/04 

Date: Mon, 26 Jul 2004 07:10:48 +1000

Regional settings are likely the problem. Apart from making sure your app
doesn't assume mm/dd/yy as a date format, common problems relate to --

- date functions that assume the day and month names will be in English
- number formatting that assumes the decimal point and thousands separator
will be period and comma respectively
- currency formatting that assumes the currency symbol is a single character
prefixed to the number

In any case, you shouldn't need to be writing sub-routines to 'fix the date
problem': let the operating system do the work for you, following whatever
settings the user has chosen on that particular machine. Otherwise you're
always trying to second-guess what's going on, and sometimes (as,
apparently, in the current situation) you'll guess wrongly.

"Mark Saville" <msaville@tbaytel.net> wrote in message
news:u8iMV1ncEHA.2408@tk2msftngp13.phx.gbl...
> Hi,
>
> Seems that some people in Europe are having trouble
> accessing the database in my application.
> Anyone have any information on this?
> The entry in the access database shows up in the DB itself
> but not in the grid in my application. Serching from the app
> brings up 'no such entry'
> We put a subroutine in to fix the date format.
>
> Thanks,
> Mark
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: isbn
    ... Control Panel on the computer. ... well that doesn't conform to the Regional settings as there is no 23rd ... So Access is being 'helpful' and spins around your entry until it does find ... The format you've chosen is good, as it shows an unambiguous format ...
    (microsoft.public.access.gettingstarted)
  • Re: Regional settings cause runtime crash
    ... Thanks for the info and link, that's a very useful thread. ... > etc. using CInt or CDbl would crash my app. ... >>> format, i.e. date values in DateTime variables etc. ... To present data to the user, use the regional settings that are ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Reginal Setting of short date
    ... regional settings to accomodate your app, you don't know the "moralities" of ... Being able to Localize the regional setting to my app only would be ... use the Date data type and controls like the DTPicker and MonthView and date ... reason to mess around with a user's regional date format settings. ...
    (microsoft.public.vb.general.discussion)
  • Re: Newbie: Saving as Word doc
    ... I've inherited a VB app that experts here say is poorly written. ... Merely changing a file's extension does NOT "convert" that ... application has to support the file's format). ... > goes back into the folder, opens every doc, and resaves it as a Word doc. ...
    (microsoft.public.vb.general.discussion)
  • Re: Output to text files or a database?
    ... This software has to do with the retrieval and processing of travel ... With plain text files being the universally loved file format, ... Another small app would read these text files, ... from the database, after all. ...
    (comp.unix.programmer)