How To Implement Translation in ACCDE

[Bron]

(Added by NeoPa. With reference to Article - How to implement a multi-lingual database).

Thanks, this is a simple way to translate an application, however I have found that it does not work when you have compiled your application into an .accde file. The runtime enviornment does not allow the form and report properties to be changed at runtime. Does anyone have a work around to make it work in the .accde environment? I dont want to deliver my source code to users, and love the simplicity of this code.

[twinnyfo]

Bron,

I’m not sure I understand. VBA allows you to manipulate nearly every aspect of your forms, even in a compiled DB. This project is simply changing the captions on labels, etc., which is definitely something one can do via VBA. Perhaps you have found some specific circumstances in which this project does not work? If you could describe in greater detail we can look at it.

[Bron]

Hi twinnyfo

THanks for your reply - I was just about to edit my post. I have spent the past hour debugging my code, putting in message boxes for almost every step, saving as accde and trying it out.

What I discovered is that I had neglected to compile my code since putting the translation code in place.... Naughty me. Of course when I compiled the code it all worked beautifully when the application was saved as an accde

Feeling a bit stupid now, but at least the issue is solved.

[NeoPa]

Hi Bron.

You're new here so probably didn't realise that questions that ask for help, as opposed to helpful comments related to the subject of an article, are not allowed in article threads. You can easily see how soon they would become thoroughly useless as an article if they became cluttered up with every related question.

I've moved this one for you to a Question thread specifically for your question. Notice I was able to include a link in your question post to the original article so anyone reading it still knows what the question's about.

I'm glad to see you've already resolved your issue. Well done :-)