Localization Problem

  • Thread starter Thread starter Mario Howard
  • Start date Start date
M

Mario Howard

When setting a subforms SourceObject in code to a Query
the query name string must be prefixed with "Query":

Me.Subform.SourceObject = "Query.qryMyQuery"

This will only work in an English version of Access 2000.

In a German version the syntax required is:

Me.Subform.SourceObject = "Abfrage.qryMyQuery"

In a French version the syntax required is:

Me.Subform.SourceObject = "Requête.qryMyQuery"

Does anyone know if there is a way to find out the local
version of an object name.

I do not want to have to "hard code" the local version
used of an object name.

Thanks
 
I don't have Access here to check - grrrrrrrrr - but surely SourceObject is
the attribute of the subform >control< which gives the name of the >subform<
within that control?

Are you saying that you can load a >query< directly into a subform
control<?
Click to expand...

As I say, I don't have Access here to check, so maybe I am missing
something...

TC


When setting a subforms SourceObject in code to a Query
the query name string must be prefixed with "Query":

Me.Subform.SourceObject = "Query.qryMyQuery"

This will only work in an English version of Access 2000.

In a German version the syntax required is:

Me.Subform.SourceObject = "Abfrage.qryMyQuery"

In a French version the syntax required is:

Me.Subform.SourceObject = "Requête.qryMyQuery"

Does anyone know if there is a way to find out the local
version of an object name.

I do not want to have to "hard code" the local version
used of an object name.

Thanks
 
Yes you can since Access 2000.

When you open the Dropdown list on a Subforms SourceObject
Property you can also select a Query.

One can use this to display Subdatasheets on a Subform.

Read the Help topics on subdatasheet.

Mario
 
Ok, I don't have easy access to A2k+. It's certainly not in A97.

I thought that all VBA keywords were ok in English, even in fully localized
versions. In your context, "Query:" is maybe not a VBA keyword, but you'd
think that the same principle would be applied.

Would it be worth asking in a group for win32 internationalization? (even
though it's not really a win32 issue)

HTH,
TC


Yes you can since Access 2000.

When you open the Dropdown list on a Subforms SourceObject
Property you can also select a Query.

One can use this to display Subdatasheets on a Subform.

Read the Help topics on subdatasheet.

Mario
 
Back
Top