链接表管理器宏 [英] Linked Table Manager Macro

问题描述

我想创建一个宏或者我可以分配给表单上的按钮的东西，它将刷新表格上的链接。因此用户无需手动执行此操作。


任何人都可以帮我这个吗？

-

Becky

应用培训师

XP& 2003 Master Instructor

I would like to create a macro or something that I can assign to a button on my form that will refresh the link on the tables. So the users do not have to do this manually.

Can anyone help me with this?
--
Becky
Applications Trainer
XP & 2003 Master Instructor

推荐答案

为什么需要刷新链接？人们一直在移动桌子吗？

Why would you need to refresh the links? People moving the tables all the time?

你在谈论表格或其他表格的RecordSource吗？

你预期会有什么变化需要Requery？

Are you talking about the RecordSource of the form or some other tables?
What changes are you anticipating that would require the Requery?

重读这个问题几次我读了标题。这给出了问题的一些背景，但请尽量清楚地问整个问题。它节省了我们所有的时间。


这个（重做链接 - 或连接属性 - 链接表）是我尝试但过去没做的事情。我最好的解决方法（我只需要处理两个场景 - 测试和实时数据）就是让两个套件都可用但是一个会被重命名。 IE浏览器。只有一个集合具有项目中使用的名称，而另一个集合以后缀命名，以将其与项目分开。


我很欣赏这不是你的意思实际上之后（我不知道你需要多少套不同的套装），但它是迄今为止我管理过的最好的套装。如果有更好的答案，我会对你学习感兴趣：）

Having reread the question a couple of times I read the title. This gives some context to the question, but please try to ask the whole question clearly. It saves us all some time.

This (Redoing the link - or Connect property - of a linked table) is something I''ve tried but failed to do in the past. My best workaround (I only needed to handle two scenarios - test & live data) was to have both sets available but one would be renamed-out. IE. only one set would have the name as used in the project, while the other set was named with a suffix to separate it from the project.

I appreciate that this is not what you were actually after (and I don''t know how many different sets you need) but it''s the best I''ve managed so far. If a better answer comes along I will be as interested as you are to learn :)

这篇关于链接表管理器宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！