Charlotte Foust
cfoust at infostatsystems.com
Thu Apr 10 10:20:01 CDT 2008
The simplest way to avoid that contretemps is not to embed form references in the SQL. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Thursday, April 10, 2008 1:31 AM 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