[AccessD] An International Consideration

Mmm, I'll try that Shamil, thanks.

-- Andy Lacey
http://www.minstersystems.co.uk 

>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com 
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
>Shamil Salakhetdinov
>Sent: 10 April 2008 14:35
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] An International Consideration
>
>
><<<
>if [Forms] is used would that be ok in the French
>version?
>>>>
>Hi Andy,
>
>Yes, it will be OK.
>
>What MS Access version do you use?
>If you set Regional Settings' to French then [Formulaires] in 
>SQL expression could also work OK, although you might need to 
>install French version of VBA typelib (I have never tried that 
>latter)...
>
>--
>Shamil
> 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
>Sent: Thursday, April 10, 2008 12:31 PM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] An International Consideration
>
>Hi everyone
>
>Here's a funny thing that's arisen because of running an 
>Access system written in French on an English version of 
>Access. I thought those of you involved in systems around the 
>globe might be interested in this.
>
>I found that when I open a form whose data is based upon a 
>selection made on the previous form Access pops up the 
>parameter entry dialog and asks me to enter the value which it 
>ought to be just reading from the earlier form. So say I'm in 
>form A. There's a prompt for a week number and then a button 
>to open the production plan for that week. In France, where 
>the system was written, that week's plan would appear. Here in 
>the UK Access pops up a dialog asking for the week number and 
>only when I enter it there does the plan appear. This 
>behaviour occurs all over the systems. What it is, I'm sure, 
>is that the recordsource for the planning screen is:
>
>SELECT *
>FROM [Préparation planning]
>WHERE [Préparation planning].Semaine=[Formulaires]![Semaine
>planning]![Semaine]
>
>If you look at the WHERE statement the keyword Formulaires is 
>not being recognised in English Access (it would be Forms here 
>of course) so 
>[Formulaires]![Semaine planning]![Semaine] is being treated as 
>an unknown parameter and Access asks for user input.
>
>Interesting eh? Of course what I could do is get hold of a 
>French version of Access but I'd need to install that on 
>another machine as it would be sure to get in the way of the 
>English version. A case for Virtual PC, I know. Anyway this 
>post is not about solving this (unless someone has a great 
>idea of course), more about pointing out yet another potential 
>pratfall when you cross national/language borders. I'd be 
>interested to know if Access handles the reverse ok, ie if 
>[Forms] is used would that be ok in the French version?
>
>--
>Andy Lacey
>http://www.minstersystems.co.uk
>
>
>________________________________________________
>Message sent using UebiMiau 2.7.2
>
>-- 
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>-- 
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>