将记录集附加到子窗体？ [英] Attach a recordset to a subForm?
问题描述
发布
http://groups.google.com/groups?hl=e...1.cgocable.net
Lyle向我们展示了ADODB.Recordset可以创建并附加到
a连续（和数据表）表格。
我需要它对于一个数据输入子表单而且我无法得到它
上班。
是否有任何理由为什么它不能与subForm一起工作？
对数据表数据输入子表单的任何建议有两列：
a标签列（不可更新）和一列数据输入字段。 />
我有兴趣知道...
谢谢，
IanO
2004年2月16日17:48:42 -0800， ia**@infoave.net （Ian Ornstein ）写道：
发布
http://groups.google.com/groups?hl=e...1.cgocable.net
Lyle告诉我们ADODB.Recordset可以创建并附加到
连续（和数据表）表单。
我需要它用于数据输入子表单和我还没有能够得到它
工作。
是否有任何理由为什么它不能与subForm一起工作？
对数据表数据的任何建议带有两列的条目子表单：
一列标签（不可更新）和一列数据输入字段。
我有兴趣知道...
谢谢，
IanO
怎么样，而不是让您的子表单成为数据输入子表单，而是通过基于它来使您的
记录集最初为空一个不返回任何行的查询？
LinkMasterFields / LinkChildFields属性中有任何内容？如果是这样，我不希望
Recordset工作，因为每次你在主窗体中移动记录时子窗体的内容都会被更改。
-
Allen Browne - 微软MVP。西澳大利亚州珀斯。
访问用户提示 - http：// allenbrowne.com/tips.html
回复群组，而不是mvps dot org的allenbrowne。
" Ian Ornstein" < IA ** @ infoave.net>在消息中写道
news：f6 ************************** @ posting.google.c om ...
发布
http://groups.google.com/groups?hl=e...1.cgocable.net Lyle向我们展示了ADODB.Recordset可以创建并附加到
连续（和数据表）表单。
我需要它用于数据输入子表单而且我没有''能够得到它
工作。
是否有任何理由为什么它不能与subForm一起使用？
对数据表数据输入子表单的任何建议两列：
一列标签（不可更新）和一列数据输入字段。
我有兴趣知道...
谢谢，
IanO
2004年2月16日17:48:42 -0800，Ian Ornstein写道：
发布
http://groups.google.com/groups?hl=e...1.cgocable.net
我需要它用于数据输入子表单我还没有能够得到它
工作。
是否有任何理由为什么它不能使用subForm？
任何建议数据表数据输入子表单有两个专栏：
一列标签（不可更新）和一列数据输入字段。
我有兴趣知道...
谢谢，
IanO
这可能取决于您尝试设置记录源的方式。你是否正确地引用子表单 - 即。
Forms！MainForm！SubFormControl.Form.Recordsource？
-
Mike Storr
www.veraccess.com
in posting
http://groups.google.com/groups?hl=e...1.cgocable.net
Lyle showed us that an ADODB.Recordset can be created and attached to
a continuous (and datasheet) form.
I needed it for a data entry subform and I haven''t been able to get it
to work.
Is there any rational for why it doesn''t work with a subForm?
Any suggestions for a datasheet data entry subform with two columns:
a column of labels (not updateable) and a column of data entry fields.
I am interested in knowing...
Thanks,
IanO
On 16 Feb 2004 17:48:42 -0800, ia**@infoave.net (Ian Ornstein) wrote:
in posting
http://groups.google.com/groups?hl=e...1.cgocable.net
Lyle showed us that an ADODB.Recordset can be created and attached to
a continuous (and datasheet) form.
I needed it for a data entry subform and I haven''t been able to get it
to work.
Is there any rational for why it doesn''t work with a subForm?
Any suggestions for a datasheet data entry subform with two columns:
a column of labels (not updateable) and a column of data entry fields.
I am interested in knowing...
Thanks,
IanO
How about, instead of making your subform a data entry subform, you make your
recordset initially empty by basing it on a query that returns no rows?
Does your subform control have anything in its
LinkMasterFields/LinkChildFields properties? If so, I would not expect the
Recordset to work, as everytime you move records in the main form the
contents of the subform are changed.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ian Ornstein" <ia**@infoave.net> wrote in message
news:f6**************************@posting.google.c om...in posting
http://groups.google.com/groups?hl=e...1.cgocable.net Lyle showed us that an ADODB.Recordset can be created and attached to
a continuous (and datasheet) form.
I needed it for a data entry subform and I haven''t been able to get it
to work.
Is there any rational for why it doesn''t work with a subForm?
Any suggestions for a datasheet data entry subform with two columns:
a column of labels (not updateable) and a column of data entry fields.
I am interested in knowing...
Thanks,
IanO
On 16 Feb 2004 17:48:42 -0800, Ian Ornstein wrote:
in posting
http://groups.google.com/groups?hl=e...1.cgocable.net
Lyle showed us that an ADODB.Recordset can be created and attached to
a continuous (and datasheet) form.
I needed it for a data entry subform and I haven''t been able to get it
to work.
Is there any rational for why it doesn''t work with a subForm?
Any suggestions for a datasheet data entry subform with two columns:
a column of labels (not updateable) and a column of data entry fields.
I am interested in knowing...
Thanks,
IanO
It may depend on how you are trying to set the recordsource. Are you
referencing the subform properly - ie.
Forms!MainForm!SubFormControl.Form.Recordsource ?
--
Mike Storr
www.veraccess.com
这篇关于将记录集附加到子窗体？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
