更新表单上的字段 [英] Updating Fields on Form Open
问题描述
Hi Every1
我刚刚开始研究数据库 - 而且我还处于技术阶段。
我正在创建一个数据库来集成到sage line 50.这一点很好,它是用户友好的。我遇到了麻烦。
我有一张包含主发票详细信息的表格(这是客户账户上的子表格)。我需要另一个表格来输入发票信息和材料和人工的细目。我想在子窗体上添加一个按钮来打开一个新窗体,但是已经输入了发票号。
我已经尝试了微软内置选项,但只出现为已经输入的数据工作。
如果有人可以提供帮助,我会非常感激。
谢谢
Dan
Hi Every1
I have only just started working on databases very recently - and I am not at the technical stage yet either.
I am creating a database to integrate into sage line 50. This bit is fine, its the "user friendly" side I''m having trouble with.
I have a form with the main invoice details (which is a sub form on the customer account). I need another form to enter the invoice message and breakdown of materials and labour. I would like to add a button on the subform to open a new form but to have already entered the invoice number.
I have tried already the microsoft built in options, but that only appears to work for data which has already been entered.
I would be grately appreciative if anyone could help.
Thanks
Dan
推荐答案
Hi Every1
我最近刚刚开始研究数据库 - 而且我还处于技术阶段。
我正在创建一个数据库来集成到sage line 50.这一点很好,它是用户友好的。我遇到了麻烦。
我有一张包含主发票详细信息的表格(这是客户账户上的子表格)。我需要另一个表格来输入发票信息和材料和人工的细目。我想在子窗体上添加一个按钮来打开一个新窗体,但是已经输入了发票号。
我已经尝试了微软内置选项,但只出现为已经输入的数据工作。
如果有人可以提供帮助,我会非常感激。
谢谢
< br $>
Dan
Hi Every1
I have only just started working on databases very recently - and I am not at the technical stage yet either.
I am creating a database to integrate into sage line 50. This bit is fine, its the "user friendly" side I''m having trouble with.
I have a form with the main invoice details (which is a sub form on the customer account). I need another form to enter the invoice message and breakdown of materials and labour. I would like to add a button on the subform to open a new form but to have already entered the invoice number.
I have tried already the microsoft built in options, but that only appears to work for data which has already been entered.
I would be grately appreciative if anyone could help.
Thanks
Dan
嗨!
让我直接说出来。仅在您刚刚输入的记录上错误地打开表单,以前输入的记录没有问题。这是完全正常的情况bcz Access移动到另一个时会保存新记录或一个表格失去焦点。
如果是这样,治愈很容易。只需添加
Hi!
Let me straight it out. The form is opened incorrectly only on a record you''ve just entered, there is no problem with records entered previously. This is completely normal situation bcz Access saves new record when you move to another one or a form looses focus.
If so, the cure is easy. Just add
你好,
不幸的是没有。只是为了澄清我有3张桌子
*发票(我出口给Sage的主要细节)
*发票明细(主要文字字符串)
*发票明细
这些都是由发票号码链接的。我创建了一个包含帐户详细信息的表单,并且其中包含主要发票详细信息的子表单。在子表单中,我添加了一个使用访问向导打开表单的按钮(发票详细信息和发票明细作为子表单)。但它不会将发票链接到发票明细表。
感谢您的帮助!
Dan
Hi There,
Unfotunately not. Just to clarify I have 3 tables
* Invoice (Main details that I export to Sage)
* Invoice Details (main text string)
* Invoice Breakdown
These are all linked by the invoice number. I have created a form with the account details, and as a subform from that has the main invoice details. In the subform I have added a button using the access wizards to open a form (invoice details and invoice breakdown as a subform). But it does not link the invoice to the invoice details form.
Thanks for your help with this!
Dan
你好,
不幸的是没有。只是为了澄清我有3张桌子
*发票(我出口给Sage的主要细节)
*发票明细(主要文字字符串)
*发票明细
这些都是由发票号码链接的。我创建了一个包含帐户详细信息的表单,并且其中包含主要发票详细信息的子表单。在子表单中,我添加了一个使用访问向导打开表单的按钮(发票详细信息和发票明细作为子表单)。但它不会将发票链接到发票明细表。
感谢您的帮助!
Dan
Hi There,
Unfotunately not. Just to clarify I have 3 tables
* Invoice (Main details that I export to Sage)
* Invoice Details (main text string)
* Invoice Breakdown
These are all linked by the invoice number. I have created a form with the account details, and as a subform from that has the main invoice details. In the subform I have added a button using the access wizards to open a form (invoice details and invoice breakdown as a subform). But it does not link the invoice to the invoice details form.
Thanks for your help with this!
Dan
Plz post子处理button_click事件。
Plz post the sub handling button_click event.
这篇关于更新表单上的字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!