M
Mishanya
I've built a DB with a few tables and forms using Access 2003 (MS OFFICE
SYSTEM PROFESSIONAL 2003 SP2 Russian Version) for some friend.
He has MS OFFICE SYSTEM PROFESSIONAL V2003 (English) with Russian and Hebrew
Multilingual User Interface Packs.
No form containing VBA code (On Open, On Load events etc') won't open in his
computer. No buttons (Exit etc') won't work. And the same error-msg shows:
"The expression On Load (On Open, On Click etc') you entered as the event
property setting produced the following error: A problem occured while MS
Access was communicating with the OLE server or ActiveX control"
Moreover, when I've tried to add some button (like Exit) to the non-working
form using his computer, the new button wouldn't work too (same exclaim). But
everything is fine, when building a new DB in his computer - all the VBA
procedures work.
I blame it on some language incompatibility between two Access-programs
(Russian vs English). But then, I used only English for tables and forms'
names and field-names and Hebrew only for its captions. The caption-names of
the form-controls ,though, have been automatically assigned names as
"ControlName_CaptionAutonum" where the "ControlName" is same as the name of
its Control (English), word "Caption" is in Russian and Autonumber is
appended. Only English was used for VBA, naturally. But, since the captions
are not used for any references, this must not be an issue.
So, before I re-wright the whole thing in his computer, maybe someone can
advise me how to overcome such a misfortune.
SYSTEM PROFESSIONAL 2003 SP2 Russian Version) for some friend.
He has MS OFFICE SYSTEM PROFESSIONAL V2003 (English) with Russian and Hebrew
Multilingual User Interface Packs.
No form containing VBA code (On Open, On Load events etc') won't open in his
computer. No buttons (Exit etc') won't work. And the same error-msg shows:
"The expression On Load (On Open, On Click etc') you entered as the event
property setting produced the following error: A problem occured while MS
Access was communicating with the OLE server or ActiveX control"
Moreover, when I've tried to add some button (like Exit) to the non-working
form using his computer, the new button wouldn't work too (same exclaim). But
everything is fine, when building a new DB in his computer - all the VBA
procedures work.
I blame it on some language incompatibility between two Access-programs
(Russian vs English). But then, I used only English for tables and forms'
names and field-names and Hebrew only for its captions. The caption-names of
the form-controls ,though, have been automatically assigned names as
"ControlName_CaptionAutonum" where the "ControlName" is same as the name of
its Control (English), word "Caption" is in Russian and Autonumber is
appended. Only English was used for VBA, naturally. But, since the captions
are not used for any references, this must not be an issue.
So, before I re-wright the whole thing in his computer, maybe someone can
advise me how to overcome such a misfortune.