dear all;
am trying to open an Access Database, it gives me the following message:
"The expression On load you entered as the event property setting produced the following error:
A problem occured while Ms. Office Access was communicating with the OLE server or ActiveX control"
and that message appears every click, resize, close...
Am using Access 2003, i also tried XP and 200.
As 4 the access database, am new to VBA (my 1st task in it) it is a complete access application (forms, queries...etc) i tried opening it on another computer, the same error msgbox appears...i took another version from my boss, which he showed me its working, and run it from my computer.........again......the problem remains.
i have win xp sp1, access 2003 with all features installed, vb6 with sp5, and .Net framework!
Could it be that the "On load" procedure should be "OnLoad"?
So "On load" is not a custom property you added to the
database? Could you post some relevant code? the other
computers that it doesnt run on are running what version of
Access and Windows? Do you have any code referencing any
other databases or COM object references?
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Thank you for your interest;
The problem is that am not able to open the code, i tried XP and 2000, i was told that it runs normally under these platforms, i also tried access 2003 and XP, but still the same problem!
Its not only the load event, its in every click of the application, resize....etc........i tried everything...what could be the problem?
by the way.....nice MCP logo........i got my MCP in c#.net two days ago (980/1000)
Thanks, and congrats to you too on a great scrore. I got 928/1000 VB6 70-176.
You need to determine where the issue is buy narrowing down
the possibilities. Can you step through code where you think the
problem may be. Start with the first form that is giving you
problems. Open it in design mode and check the property "On
Load". What does it say and what does the procedure look like?
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Sounds to me that the comp where the database was build on had an ActiveX compinent installed which was used in the database, so if you run it on an comp without that ActiveX it gives this error.
Since we can not see your forms and code, all I can say is if you
can check on one of the systems where it does run, to go into
design view and see if you added any external controls to the
forms. Did you click on the toolbox - more controls ? If you did
then it could be possible that you added an external control from
there.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
There's no new controls, or anything special!
Could it be am unable to run macros? or anything else?
am going crazy here.......it doesn't make any sense
Originally posted by FiDz There's no new controls, or anything special!
Could it be am unable to run macros? or anything else?
am going crazy here.......it doesn't make any sense
WHy not post the database somewhere and let others check
Reply With Quote
