用VBA关闭名称自动更正？ [英] Turn off Name AutoCorrect with VBA?

问题描述

关于报告更改边距和方向的问题，我遇到了A2K名称自动更正错误。我知道你可以在创建对象时关闭此功能，但我猜测（我希望不正确）这只会为我的电脑解决这个问题。


如果这确实是如果用户打开数据库（通过vba模块或其他东西），有没有人知道是否可以关闭自动更正？


谢谢！


Brad。

解决方案

下面的文章介绍了如何手动将其关闭，如果你需要使用VBA让我们知道我是确定我可以满足您的需求。


从Access中的名称自动更正中解脱出来。

http://office.microsoft.com/en-us/ac...345661033.aspx

以下文章介绍了如何在需要时手动将其关闭e VBA让我们知道我确信我可以满足您的需求。


在Access中取出名称自动更正的神秘面纱。

http://office.microsoft.com/en-us/交流... 345661033.aspx

__________________________________________________ ________________

看起来您发送的链接不再有效（或者仅仅是网站）。


我手动关闭名称自动更正没有问题。我只需要知道你是否在创建Access对象之前手动关闭它，这会转换为使用网络版数据库的其他用户PC吗？


如果不是......我做确实需要一些关于如何使用VBA关闭名称自动更正的建议。


非常感谢！

我相信这是一个开启和关闭每个数据库类型的项目。因此，如果有人使用该数据库，那么它也应该为它们设置。

我确实需要一些关于如何使用VBA转向的建议关名称自动更正。

如果您或其他任何人设法找到它，我会尝试并尽我所能，请发布它，因为它可能对其他人有用。感谢

I am being stricken with the A2K Name AutoCorrect bug with regards to reports changing margins and orientation. I understand that you can turn this feature off when creating objects, but I am guessing (incorrectly I hope) that this will fix this problem only for my computer.

If this is indeed the case, does anyone know if it''s possible to turn autocorrect off as soon as a user opens the database (via a vba module or something)?

Thanks!

Brad.

解决方案

The following article explains how you can manually turn it off, if you need to use VBA let us know I am sure I can something to fit your needs.

"Taking the mystery out of Name AutoCorrect in Access."

http://office.microsoft.com/en-us/ac...345661033.aspx

The following article explains how you can manually turn it off, if you need to use VBA let us know I am sure I can something to fit your needs.

"Taking the mystery out of Name AutoCorrect in Access."

http://office.microsoft.com/en-us/ac...345661033.aspx

__________________________________________________ ________________
Looks like that link you sent is no longer active (or just a problem with the site).

I have had no problem manually turning off Name AutoCorrect. I just need to know if you manually turn it off before creating Access objects, will this translate to other users PCs using the network version of the database?

If not... I do indeed need some advice on how to use VBA to turn off Name AutoCorrect.

Many thanks!

I do believe this is a turned on and off per database type of an item. So if anyone is using that db then it should be set for them as well.

I do indeed need some advice on how to use VBA to turn off Name AutoCorrect.

That may take some effort I will try and do what I can if you or anyone else manages to find it please post it as it could be useful to others. Thanks

这篇关于用VBA关闭名称自动更正？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！