Different global settings for non-Unicode programs causes VBA erro

M

Martin Fontan

I'm unable to find any help or suggestion over the internet.
I knew that it is caused by the global setting "regional and language
option" -> advanced -> Language for non-Unicode programs.
If you add any VB code (in my case in MS Access) into the document and save
it and then you change this option to something different (I swap between
English and Czech or Slovak) then VB code won't run and you'll receive error
saying something like "Communication problems with OLE server or ActiveX".
However I'm not using anything special in my code and it happens even if you
add only a empty code for some control event like:
Sub Button_OK_Click()
End Sub
Workaround is to set language settings for non-Unicode programs back to
previous value but the main problem is that if you have two documents
developed using different settings you are able just to run one of them.
I'm really puzzled and I would appreciate any suggestion.
Does anybody have any idea?
Thanks a lot
Martin Fontan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top