且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

表格问题

更新时间:2022-11-28 11:34:12

Mike,


这些选项非常无限.....我有一些带有五个标签的表格,一个标签上有四个子表格....所有指向不同的表/查询。您有什么想法?
Mike,

The options are pretty limitless..... I''ve had some forms with five tabs, and four subforms on a tab.... All pointing to different tables/queries. What do you have in mind?


根据我的发现,限制是7个级别的子表单,754个控件/部分在表单的生命周期内。 (限制子表单?)标签除了视觉上,控制对子窗体没有任何影响。我做了一个有5个子表格的数据库,所以你的三个应该没问题。


更新:我刚发现一篇文章给出了更好的限制:子表单
From what I have found, the limit is 7 levels of subforms, 754 controls/sections over the life of the form. (Limit for subforms?) The tab control doesn''t really have any effect on the subform other than visually. I have done a database that had 5 subforms, so your three should be okay.

Update: I just found an article that gives better limitations: Subforms


嘿twinnyfo,


Page1:Record Source = tblIntakeMaster


链接字段:IntakeMasterID(tblIntakeMaster的PK)


Page2:记录源(tblClient)= sfrmClient


链接字段:ClientID(tblClient的PK)


Page3:记录来源(tblAccident)= sfrmAccident


链接字段:意外ID(PK为tblAccident)



Page3 :记录来源(tblFollowUp)= sfrmFollowUp

链接字段:FollowUpID(tblFollowUp的PK)



基本上我认为是它。看起来我的Link Field正在消失,或者当我把它放回去时,我在该页面上的Subform消失了。我不确定为什么?


谢谢,

Mike
Hey twinnyfo,

Page1: Record Source = tblIntakeMaster

Link Field: IntakeMasterID (PK for tblIntakeMaster)

Page2: Record Source (tblClient) = sfrmClient

Link Field: ClientID (PK for tblClient)

Page3: Record Source (tblAccident) = sfrmAccident

Link Field: AccidentID (PK for tblAccident)


Page3: Record Source (tblFollowUp) = sfrmFollowUp

Link Field: FollowUpID (PK for tblFollowUp)


Basically I think that is it. It seems like either my Link Field is disappearing or when I put it back, my Subform on that Page disappears. I''m not really sure why?

Thanks,
Mike