访问VBA关系窗口 [英] Access VBA Relationship Window

问题描述

我正在尝试使用VBA将表添加到Access中的关系视图中。有谁知道如何做到这一点？我知道如何手动完成它，但我需要自动化它。任何帮助将不胜感激。谢谢。

i am trying to add tables to a relationship view in Access using VBA. Does anyone know how to do this? I know how to manually do it but i need to automate it. Any help will be greatly appreciated. Thanks.

推荐答案

您好，



最好的方法是使用内置的表设计和关系创建选项，但如果你想学习请按照这个



创建表的参考：



http://msdn.microsoft.com/en-us/library/office/ff837200.aspx [ ^ ]



参考创建他们之间的关系：



用于创建MS Access Relations的VBA代码 [ ^ ]





所有最好的:)如果你面对任何我，请回信用代码判断。

Hello ,

The best way is to create with the inbuilt Table design and relationship option but if you want to learn pls follow this

Reference for creating table :

http://msdn.microsoft.com/en-us/library/office/ff837200.aspx[^]

Reference for creating the relationship between them:

VBA code for creating MS Access Relations[^]


All the Best:)Pls write back if you are facing any issues withe code.

这篇关于访问VBA关系窗口的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！