Group:  Microsoft Access » microsoft.public.access.activexcontrol
Thread: Please help. Visual Basic problem

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Re: Please help. Visual Basic problem
"heying" <heying06222[ at ]126.com> 06.01.2004 21:32:40

"Nancy" <interpack[ at ]internet.gr> дÈëÏûÏ¢ÐÂÎÅ:uJdG2YU2FHA.476[ at ]TK2MSFTNGP15.phx.gbl...
[Quoted Text]
> 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
>
>
>


Please help. Visual Basic problem
"Nancy" <interpack[ at ]internet.gr> 25.10.2005 09:26:44
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



RE: Please help. Visual Basic problem
Klatuu 25.10.2005 12:28:05
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.

"Nancy" wrote:

[Quoted Text]
> 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
>
>
>
>
Re: Please help. Visual Basic problem
"Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 25.10.2005 13:32:10
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


"Nancy" <interpack[ at ]internet.gr> wrote in message
news:uJdG2YU2FHA.476[ at ]TK2MSFTNGP15.phx.gbl...
[Quoted Text]
> 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
>
>
>


Re: Please help. Visual Basic problem
"Nancy" <interpack[ at ]internet.gr> 25.10.2005 13:48:05
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

"Klatuu" <Klatuu[ at ]discussions.microsoft.com> wrote in message
news:A56748FB-6C38-4C9D-AF94-9BF421193C3E[ at ]microsoft.com...
[Quoted Text]
> 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.
>
> "Nancy" wrote:
>
>> 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
>>
>>
>>
>>


Re: Please help. Visual Basic problem
"Nancy" <interpack[ at ]internet.gr> 25.10.2005 14:19:08
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


"Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> wrote in message
news:edjNTiW2FHA.4008[ at ]tk2msftngp13.phx.gbl...
[Quoted Text]
> 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
>
>
> "Nancy" <interpack[ at ]internet.gr> wrote in message
> news:uJdG2YU2FHA.476[ at ]TK2MSFTNGP15.phx.gbl...
>> 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
>>
>>
>>
>
>



Re: Please help. Visual Basic problem
"Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 25.10.2005 15:23:23
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



"Nancy" <interpack[ at ]internet.gr> wrote in message
news:O8acGBX2FHA.1468[ at ]TK2MSFTNGP10.phx.gbl...
[Quoted Text]
> 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
>
>
> "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> wrote in message
> news:edjNTiW2FHA.4008[ at ]tk2msftngp13.phx.gbl...
>> 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
>>
>>
>> "Nancy" <interpack[ at ]internet.gr> wrote in message
>> news:uJdG2YU2FHA.476[ at ]TK2MSFTNGP15.phx.gbl...
>>> 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
>>>
>>>
>>>
>>
>>
>
>
>


Re: Please help. Visual Basic problem
"ÐìÊÀÐË" <shibyby_1896[ at ]163.com> 16.12.2005 14:05:56

"Nancy" <interpack[ at ]internet.gr> дÈëÏûÏ¢ÐÂÎÅ
:uJdG2YU2FHA.476[ at ]TK2MSFTNGP15.phx.gbl...
[Quoted Text]
> 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
>
>
> ÎÒϲ»¶°¡


Re: Please help. Visual Basic problem
"penglinhui" <penghui6666666[ at ]163.com> 17.12.2005 08:08:33

"Nancy" <interpack[ at ]internet.gr> дÈëÏûÏ¢ÐÂÎÅ:uJdG2YU2FHA.476[ at ]TK2MSFTNGP15.phx.gbl...
[Quoted Text]
> 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
>
>
>


Re: Please help. Visual Basic problem
"ze" <hotpescas[ at ]hotmail.com> 23.12.2005 18:31:28

"Nancy" <interpack[ at ]internet.gr> escreveu na mensagem
news:uJdG2YU2FHA.476[ at ]TK2MSFTNGP15.phx.gbl...
[Quoted Text]
> 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
>
>
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net