Please help. Visual Basic problem

[Nancy]

Hello to all. I have a database in which in the form there are two fields
"TK" and "City". So when specific data is entered in the field TK, other
data it is autoentered in the field CITY. (After update....If Me![TK] Like
"111" Then Me![CITY] = "something"). It works fine in all computers the
database is working. But in a computer in which XP PRO was installed a few
weeks ago and Office 2003 PRO it does not work. I get the error message (I
have to translate it from Greek, I'll do my best): "The after update
function caused an error. There was a problem with the communication of
Microsoft Office Access with the OLE server or with the ActiveX control".
When I create a new database and I click on the after update section of the
properties I get the message "Microsoft Access can not create the Visual
Basic macro" (or at least something like that, as I told you it is in
Greek).
I will try to give you additional information:
I have downloaded all windows and office updates and service packs.
I have uninstalled and reinstalled Office 2003 pro.
I have done a repair of Office 2003.
I have put the safety of Access in LOW.
I have the latest Microsoft Jet 4.0 service pack (I have MSjet40.dll version
4.0.8618.0, which I read is the latest for WinXP).
The code is correct since the same database works in all other computers.

I just do not know what else to do.
Pleas help me.
Thank You
Nancy

 

[Guest]

This sounds like a Reference problem. Office 2003 uses some different DLLs
than 2000. Open your VBA Editor, Click on Tools->References. Look for any
library references that say Missing. You probably have to select the newer
version of the library and recompile.

 

[Alex Dybenko]

Hi,
as you mentioned Greek - perhaps could be a localization problem, see:
http://alexdyb.blogspot.com/2005/04/localized-access-version-problem.html

 

[Nancy]

Thanks for your reply Klatuu.
Unfortunately that wasn't it. There is no library missing.
One more thing is that through the network the database of this computer
works fine from another pc. So it has something to do with Windows and
Office or Access on this machine. But I have no idea what to look at. I just
do not know what to do.
Thanks
Nancy

This sounds like a Reference problem. Office 2003 uses some different
DLLs
than 2000. Open your VBA Editor, Click on Tools->References. Look for
any
library references that say Missing. You probably have to select the
newer
version of the library and recompile.

Hello to all. I have a database in which in the form there are two fields
"TK" and "City". So when specific data is entered in the field TK, other
data it is autoentered in the field CITY. (After update....If Me![TK]
Like
"111" Then Me![CITY] = "something"). It works fine in all computers the
database is working. But in a computer in which XP PRO was installed a
few
weeks ago and Office 2003 PRO it does not work. I get the error message
(I
have to translate it from Greek, I'll do my best): "The after update
function caused an error. There was a problem with the communication of
Microsoft Office Access with the OLE server or with the ActiveX control".
When I create a new database and I click on the after update section of
the
properties I get the message "Microsoft Access can not create the Visual
Basic macro" (or at least something like that, as I told you it is in
Greek).
I will try to give you additional information:
I have downloaded all windows and office updates and service packs.
I have uninstalled and reinstalled Office 2003 pro.
I have done a repair of Office 2003.
I have put the safety of Access in LOW.
I have the latest Microsoft Jet 4.0 service pack (I have MSjet40.dll
version
4.0.8618.0, which I read is the latest for WinXP).
The code is correct since the same database works in all other computers.

I just do not know what else to do.
Pleas help me.
Thank You
Nancy

 

[Nancy]

Thanks Alex for your answer.
I followed your link and your advice, I changed the language from: Control
panel-Regional and Language options-Advanced and set “Select a language to
match the language version of the non-Unicode program you want to use” to
Greek.
The code works fine now. But office doesn't wright Greek anymore! We have to
enter Greek data. So what can I do. At least we know the problem had to do
with the regional/language settings. But my Office 2003 is a greek edition.
So now what?
In my regional options of control panel Greek is selected, Location Greece,
default input language English(usa) and now the advanced language for
non-unicode programs Greek. So is there anything I can do now?
Thank You
Nancy

Hi,
as you mentioned Greek - perhaps could be a localization problem, see:
http://alexdyb.blogspot.com/2005/04/localized-access-version-problem.html

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Hello to all. I have a database in which in the form there are two fields
"TK" and "City". So when specific data is entered in the field TK, other
data it is autoentered in the field CITY. (After update....If Me![TK]
Like "111" Then Me![CITY] = "something"). It works fine in all computers
the database is working. But in a computer in which XP PRO was installed
a few weeks ago and Office 2003 PRO it does not work. I get the error
message (I have to translate it from Greek, I'll do my best): "The after
update function caused an error. There was a problem with the
communication of Microsoft Office Access with the OLE server or with the
ActiveX control".
When I create a new database and I click on the after update section of
the properties I get the message "Microsoft Access can not create the
Visual Basic macro" (or at least something like that, as I told you it is
in Greek).
I will try to give you additional information:
I have downloaded all windows and office updates and service packs.
I have uninstalled and reinstalled Office 2003 pro.
I have done a repair of Office 2003.
I have put the safety of Access in LOW.
I have the latest Microsoft Jet 4.0 service pack (I have MSjet40.dll
version 4.0.8618.0, which I read is the latest for WinXP).
The code is correct since the same database works in all other computers.

I just do not know what else to do.
Pleas help me.
Thank You
Nancy

 

[Alex Dybenko]

Hi Nancy,
i think you built your application on Greek version of access, that is why
it does not run on non-greek enviroment. if this is ok for you - then you
have to say all users that that should set language for non-Unicode programs
to Greek.
if not - then you have to replace all greek characters in object names and
code to english.

As for your code If Me![TK] Like "111" Then Me![CITY] = "GREEK WORD") -
try to companct mdb, once you changed language for non-Unicode programs to
Greek
HTH

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Thanks Alex for your answer.
I followed your link and your advice, I changed the language from: Control
panel-Regional and Language options-Advanced and set “Select a language to
match the language version of the non-Unicode program you want to use” to
Greek.
The code works fine now. But office doesn't wright Greek anymore! We have
to enter Greek data. So what can I do. At least we know the problem had to
do with the regional/language settings. But my Office 2003 is a greek
edition. So now what?
In my regional options of control panel Greek is selected, Location
Greece, default input language English(usa) and now the advanced language
for non-unicode programs Greek. So is there anything I can do now?
Thank You
Nancy

Hi,
as you mentioned Greek - perhaps could be a localization problem, see:
http://alexdyb.blogspot.com/2005/04/localized-access-version-problem.html

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Hello to all. I have a database in which in the form there are two
fields
"TK" and "City". So when specific data is entered in the field TK, other
data it is autoentered in the field CITY. (After update....If Me![TK]
Like "111" Then Me![CITY] = "something"). It works fine in all
computers
the database is working. But in a computer in which XP PRO was
installed
a few weeks ago and Office 2003 PRO it does not work. I get the error
message (I have to translate it from Greek, I'll do my best): "The after
update function caused an error. There was a problem with the
communication of Microsoft Office Access with the OLE server or with the
ActiveX control".
When I create a new database and I click on the after update section of
the properties I get the message "Microsoft Access can not create the
Visual Basic macro" (or at least something like that, as I told you it
is
in Greek).
I will try to give you additional information:
I have downloaded all windows and office updates and service packs.
I have uninstalled and reinstalled Office 2003 pro.
I have done a repair of Office 2003.
I have put the safety of Access in LOW.
I have the latest Microsoft Jet 4.0 service pack (I have MSjet40.dll
version 4.0.8618.0, which I read is the latest for WinXP).
The code is correct since the same database works in all other
computers.

I just do not know what else to do.
Pleas help me.
Thank You
Nancy

 

[ÐìÊÀÐË]

Hello to all. I have a database in which in the form there are two fields
"TK" and "City". So when specific data is entered in the field TK, other
data it is autoentered in the field CITY. (After update....If Me![TK] Like
"111" Then Me![CITY] = "something"). It works fine in all computers the
database is working. But in a computer in which XP PRO was installed a few
weeks ago and Office 2003 PRO it does not work. I get the error message (I
have to translate it from Greek, I'll do my best): "The after update
function caused an error. There was a problem with the communication of
Microsoft Office Access with the OLE server or with the ActiveX control".
When I create a new database and I click on the after update section of the
properties I get the message "Microsoft Access can not create the Visual
Basic macro" (or at least something like that, as I told you it is in
Greek).
I will try to give you additional information:
I have downloaded all windows and office updates and service packs.
I have uninstalled and reinstalled Office 2003 pro.
I have done a repair of Office 2003.
I have put the safety of Access in LOW.
I have the latest Microsoft Jet 4.0 service pack (I have MSjet40.dll version
4.0.8618.0, which I read is the latest for WinXP).
The code is correct since the same database works in all other computers.

I just do not know what else to do.
Pleas help me.
Thank You
Nancy


ÎÒϲ»¶°¡

 

[penglinhui]

Hello to all. I have a database in which in the form there are two fields
"TK" and "City". So when specific data is entered in the field TK, other
data it is autoentered in the field CITY. (After update....If Me![TK] Like
"111" Then Me![CITY] = "something"). It works fine in all computers the
database is working. But in a computer in which XP PRO was installed a
few weeks ago and Office 2003 PRO it does not work. I get the error
message (I have to translate it from Greek, I'll do my best): "The after
update function caused an error. There was a problem with the
communication of Microsoft Office Access with the OLE server or with the
ActiveX control".
When I create a new database and I click on the after update section of
the properties I get the message "Microsoft Access can not create the
Visual Basic macro" (or at least something like that, as I told you it is
in Greek).
I will try to give you additional information:
I have downloaded all windows and office updates and service packs.
I have uninstalled and reinstalled Office 2003 pro.
I have done a repair of Office 2003.
I have put the safety of Access in LOW.
I have the latest Microsoft Jet 4.0 service pack (I have MSjet40.dll
version 4.0.8618.0, which I read is the latest for WinXP).
The code is correct since the same database works in all other computers.

I just do not know what else to do.
Pleas help me.
Thank You
Nancy

 

[ze]

Hello to all. I have a database in which in the form there are two fields
"TK" and "City". So when specific data is entered in the field TK, other
data it is autoentered in the field CITY. (After update....If Me![TK] Like
"111" Then Me![CITY] = "something"). It works fine in all computers the
database is working. But in a computer in which XP PRO was installed a few
weeks ago and Office 2003 PRO it does not work. I get the error message (I
have to translate it from Greek, I'll do my best): "The after update
function caused an error. There was a problem with the communication of
Microsoft Office Access with the OLE server or with the ActiveX control".
When I create a new database and I click on the after update section of the
properties I get the message "Microsoft Access can not create the Visual
Basic macro" (or at least something like that, as I told you it is in
Greek).
I will try to give you additional information:
I have downloaded all windows and office updates and service packs.
I have uninstalled and reinstalled Office 2003 pro.
I have done a repair of Office 2003.
I have put the safety of Access in LOW.
I have the latest Microsoft Jet 4.0 service pack (I have MSjet40.dll version
4.0.8618.0, which I read is the latest for WinXP).
The code is correct since the same database works in all other computers.

I just do not know what else to do.
Pleas help me.
Thank You
Nancy