实用程序参考在Access 2013中无效...为什么？ [英] Utility reference not working in Access 2013 ... Why?
问题描述
我搜索过有关此内容的信息，但似乎缺乏此信息。我在2010年开发了一个数据库。在我的办公室，我们有2010年和2013年的用户。我引用了一个名为"utility"的库。所以我可以在内置的Access缩放框中更改字体
的类型和大小。我从这里得到了这个想法：
https://bytes.com /topic/access/answers/9473...nd-accmdzoombox
我的代码如下（比上面的文章简单）：< br $>
Private Sub NewEntryCalc_DblClick（取消为整数）
On Error Resume Next
utility.zoom_stFontName =" Arial" ;
$
utility.zoom_iFontSize = 10
RunCommand acCmdZoomBox
结束子
这适用于我所有的2010用户，但对于我的2013用户，他们都会收到有关缺少对"Utility.accda"的引用的错误。当我取消选中实用程序引用并删除与其相关的代码（以上面的"实用程序"开头的行）时，
它再次适用于2013用户。那么，我猜测微软在2013年停止使用此功能？但我找不到任何证实这一事实的文章。
有人可以证实吗？或者，如果此实用程序库/功能在2013年仍然可用，我该如何使其工作？
我不明白的是我找到了实用程序我机器上的.accda：
C：\程序文件（x86）\ Microsoft Office \ Office14 \ ACCWIZ
我去了一台只有Office 2013的机器，我在下面找到了Utility.accda：
C：\Program Files（x86）\ Microsoft Office \ Office15 \ ACCWIZ
我认为对于所有库引用，它知道转换为2013用户（即更改引用Office 15库的路径）。 我引用了Outlook和Excel库，我想这些文件夹也略有不同。 没有问题
与2013年用户的这些库。
I have searched for information about this, but seems there is a lack of it. I developed a database in 2010. In my office, we have both 2010 and 2013 users. I referenced a library called "utility" so I could change the type and size of the font
in the built-in Access zoom box. I got the idea from here:
https://bytes.com/topic/access/answers/9473...nd-accmdzoombox
My code is as follows (simpler than what the article above has):
Private Sub NewEntryCalc_DblClick(Cancel As Integer)
On Error Resume Next
utility.zoom_stFontName = "Arial"
utility.zoom_iFontSize = 10
RunCommand acCmdZoomBox
End Sub
This works great for all my 2010 users, but for my 2013 users, they all get an error about a missing reference to "Utility.accda". When I uncheck the utility reference and remove code related to it (the lines starting with "utility" above),
it works fine again for 2013 users. So, I'm guessing Microsoft discontinued this feature in 2013? But I can't find any articles confirming this fact.
Can someone confirm this? Or, if this utility library / feature is still available in 2013, how do I make it work?
The thing I don’t understand is that I found the Utility.accda on my machine under:
C:\Program Files (x86)\Microsoft Office\Office14\ACCWIZ
I went to a machine here that has Office 2013 only and I found Utility.accda under:
C:\Program Files (x86)\Microsoft Office\Office15\ACCWIZ
I thought that for all library references, it knows to convert up for 2013 users (i.e. change the path to reference Office 15 libraries). I reference Outlook and Excel libraries and I imagine those folders are slightly different as well. No issues
with those libraries for 2013 users.
推荐答案
嗨Traci，
Hi Traci,
Don我引用了这个，但我认为Access将自动转换为仅适用于Office产品的更高库版本。由于Utility不是Office产品（至少我认为不是），因此您必须自己手动调整引用。您可以尝试查看是否可以在Utility库上使用后期绑定来避免错误。
Don't quote me on this but I think Access will auto convert to a higher library version only for Office products. And since Utility is not an Office product (at least I don't think it is), then you'll have to manually adjust the reference yourself. You might try seeing if you can use late binding on the Utility library to avoid the error.
只是想一想......
Just a thought...
这篇关于实用程序参考在Access 2013中无效...为什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
