VBA基础
未公开的SysCmd功能
2009-10-12 08:37:44
  功能与API ActivateKeyboardLayout 一样,操作更为方便 

11.获得指定线程的活动键盘布局

  用法: SysCmd(711)

  返回当前应用程序的InputLocaleID

12.判断当前access对象是否有在设计视图模式

  用法: SysCmd(714)

  返回一个布尔值(true/false) True: 如果 窗体,报表,宏,模块 目前在设计模式打开 返回True

 

13.access 编译版本

   SysCmd(acSysCmdAccessVer) = 9  -> access 2000

        SysCmd(715) = 2719 ' access 2000 No Service Pack

        SysCmd(715) = 3822 ' access 2000 SP1

        SysCmd(715) = 4506 ' access 2000 SP2

        SysCmd(715) = 6620 ' access 2000 SP3

    SysCmd(acSysCmdAccessVer) = 10  -> access 2002

        SysCmd(715) = 2627 ' access 2002(XP) No Service Pack

        SysCmd(715) = 3409 ' access 2002(XP) SP1

        SysCmd(715) = 4302 ' access 2002(XP) SP2

        SysCmd(715) = 6501 ' access 2002(XP) SP3

    SysCmd(acSysCmdAccessVer) = 11  -> access 2003

        SysCmd(715) = 5614 ' access 2003 No Service Pack

        SysCmd(715) = 6355 ' access 2003 SP1

        SysCmd(715) = 6566 ' access 2003 SP2