Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sat Mar 10 11:09:48 CST 2007
Gustav: The English is in the table as well. What I pass is an argument that looks something like the English message but isn't just so the code becomes a bit more self-documenting. Like: MsgboxUni Me.hWnd, TranslateMsgbox("NoTagsToReportReportCancelled"), , vbExclamation Or MsgboxUni Me.hWnd, TranslateMsgbox("AccessKeyIncorrect"), , vbExclamation Or MsgboxUni Me.hWnd, TranslateMsgbox("ReadWriteAccessIsRequiredToRunCalculations"), , vbExclamation Where the argument is in the field call MessageID (not the PK). But with your approach how do I know the translation is missing? T&R Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Saturday, March 10, 2007 8:56 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Looking at lines of code in code Hi Rocky That's why I recommend to keep even the native language in the translation table. Then you can insert a programmer's sentence in the code like: 3210: Press OK to continue. or $$ Press OK to continue. and when you meet a messagebox or a control with that syntax you know a translation is missing. Also, it allows you to write the text in the code fast perhaps missing some finesse and leave the hard work to a skilled writer. /gustav >>> rockysmolin at bchacc.com 10-03-2007 17:29 >>> This is to check that each of the message boxes in the system appears in the language table where I store the multiple language translations. So, once I find the call to TranslateMessage in the module, then I have to look in another table - tblLanguage-Msgboxes - to see if the phrase to be translated, which is the function call's argument, is in the table. If not I want to add it. So searching for the phrase TranslateMessage would do it but each time I find it, I'd have to copy the argument, flip over to the table and do a search. Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM