将MSaccess表单上的文本字段复制到同一表单中的另一个字段 [英] Copy text field on MSaccess form to another field within the same form
问题描述
任何人都可以帮助我。我有一个有表格的数据库。在表单上,我有一个子表单,它引入了一些与主表单上的数据相关的数据,但是从一周前开始(项目的状态是数据)。
如果事情没有改变,我希望有人点击一个按钮,以便前一周的数据进入本周数据。我不能让它工作。我尝试在按钮的on click属性上使用表达式构建器并告诉它
[Status_for_Week_Ending] = Forms![qryForReview subform1]!Status_for_Week_Ending
但是这样做不行。
有什么建议吗?
不确定我是否理解并且我错过了一些细节。
Status_for_Week_Ending
您是说要使用新日期更新此字段,如果是本周日期或本周结束日期。这个字段在主窗体或子窗体上吗?
主窗体
Me!Status_for_Week_Ending = DateAdd(" d",7,Me!Status_for_Week_Ending)
SubForm
Me!MySubForm.Form!Status_for_Week_Ending = DateAdd(" d",7,Me!MySubForm.Form!Status_for_Week_En ding)
对不起。我已经知道了日期。我只想让它从一个备忘录字段中复制数据,然后点击一个按钮将其放入另一个备忘录字段。
谢谢
不确定我是否理解并且我错过了一些细节。
Status_for_Week_Ending
你是说要更新这个具有新日期的字段,如果是本周日期或本周结束。这个字段在主窗体或子窗体上吗?
主窗体
Me!Status_for_Week_Ending = DateAdd(" d",7,Me!Status_for_Week_Ending)
SubForm
Me!MySubForm.Form!Status_for_Week_Ending = DateAdd(" d",7,Me!MySubForm.Form!Status_for_Week_En ding)
我仍然不清楚控件所处的位置,看看你有什么顶部我想你希望子窗体中的日期转移到控件上主要形式?
我![Status_for_Week_Ending] =我![qryForReview subform1] .Form!Status_for_Week_Ending
Can anyone help me. I have a database that has a form. On the form I have a subform that brings in some data that is relevant to the data on the main form but from a week before (status of projects it was the data is about).
If things haven''t changed I want someone to click on a button so that the data from the week before goes into the spot for this weeks data. I can''t get it to work. I have tried using the expression builder on the on click property of the button and telling it that
[Status_for_Week_Ending]=Forms![qryForReview subform1]!Status_for_Week_Ending
However this does not work.
Any suggestions?
Not sure if I understand and I am missing some details.
Status_for_Week_Ending
Are you saying that you want to update this field with a new date and would that be todays date or the end if this week. Is this field on the main form or the subform?
Main Form
Me!Status_for_Week_Ending = DateAdd("d",7,Me!Status_for_Week_Ending)
SubForm
Me!MySubForm.Form!Status_for_Week_Ending = DateAdd("d",7,Me!MySubForm.Form!Status_for_Week_En ding)
I''m sorry. I already have the date figured out. I just want it to copy data from one memo field and put it into another memo field with the click of a button.
Thanks
Not sure if I understand and I am missing some details.
Status_for_Week_Ending
Are you saying that you want to update this field with a new date and would that be todays date or the end if this week. Is this field on the main form or the subform?
Main Form
Me!Status_for_Week_Ending = DateAdd("d",7,Me!Status_for_Week_Ending)
SubForm
Me!MySubForm.Form!Status_for_Week_Ending = DateAdd("d",7,Me!MySubForm.Form!Status_for_Week_En ding)
I am still not clear about where the controls reside from looking at what you have up top I think you want the date in the subform to be transfered to a control on the main form?
Me![Status_for_Week_Ending]=Me![qryForReview subform1].Form!Status_for_Week_Ending
这篇关于将MSaccess表单上的文本字段复制到同一表单中的另一个字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!