yuzuri’s blog

MS Access database problem: unable to run event procedure from command button in certain PCs, but it works just fine on some other PCs
environment: Windows XP (SP version doesn’t matter), MS Office Access (2000/2003/2007)

error message:
The expression On Click you entered as the event property setting produced the following error:
There is an invalid use of the . (dot) or ! operator or invalid parentheses.
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.

Solution:
checked Help > About MS Office Access > System Info > Office Applications > MS Office Access > Summary
found missing reference MSComDlg
go to Tools > ActiveX Controls > register COMMON DIALOGS CONTROL from C:\WINDOWS\System32\COMDLG32.ocx
(if it doesn’t exist, copy the file from the working PC)

phew!

now that i found the root of the problem, i feel so stupid that i didn’t notice it earlier >_< ;
such a waste of time i spent hours trying to figure it out i re-installed Windows XP twice plus re-installed MS Office 2000, then MS Office 2003, and then MS Office 2007
i'm so happy that it's solved... but it's so aggravating! >_< ; GRAAAAAA<~
*sighs*

---updated 18-Feb-08---
okey so the On Click error was solved, but then i got a bunch of other On procedures error
this database needs more ActiveX components... so as last resort i installed Visual Basic 6.0 Enterprise with all its core ActiveX stuffs
and it worked -_-; *wobbles*
damn this case took away my precious weekend >_<;

—updated again—
or maybe i just needed to install Microsoft Script

Jakarta: In Dire Need of Improvement

menyedihkan…