ACC: Sample Function to Determine Language Version

SUMMARY

Microsoft Access ships in several languages, including English, Spanish, Portuguese, French, and German. However, there is no built-in command in Microsoft Access to determine which language version of Microsoft Access your application is running. This article shows you how to create a sample function that you can use to determine which language version of Microsoft Access is running.

This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to your version of the "Building Applications with Microsoft Access" manual.

NOTE: Visual Basic for Applications is called Access Basic in Microsoft Access versions 1.x and 2.0. For more information about Access Basic, please refer to the "Introduction to Programming" manual in Microsoft Access version 1.x or the "Building Applications" manual in Microsoft Access version 2.0

   Function Language ()
      Select Case Error$(3)
         Case "Return without GoSub":
            Language = "English"
         Case "Return sans GoSub":
            Language = "French"
         Case "'Return' ohne 'GoSub'":
            Language = "German"
         Case "Return sem GoSub":
            Language = "Portuguese"
         Case "Return sin GoSub":
            Language = "Spanish"
      End Select
   End Function