如果子表单没有记录，则发出警报消息。 [英] Alert Message if Sub Form has no record.

问题描述

我在Access 2000中制作了一个表格，其中包含主表格和子表格。主表单有（头文件）和子表单（详细文件）。使用Casecade更新相关字段和Casecade删除相关记录建立Header Table和Detailed Table的主键字段之间的关系。


每当User输入Header文件中的所有输入时，我都希望这样做他必须在详细文件中输入必要的记录。如果他没有这样做，会出现一条警告信息以确保相同。


请帮助我。

解决方案

您无意中在文章部分而不是我们网站的论坛部分发布了您的问题，因此我已将其移至论坛。


Linq ; 0 ）>

我在Access 2000中制作了一个表格，其主表格为&子表格。主表单有（头文件）和子表单（详细文件）。使用Casecade更新相关字段和Casecade删除相关记录建立Header Table和Detailed Table的主键字段之间的关系。


每当User输入Header文件中的所有输入时，我都希望这样做他必须在详细文件中输入必要的记录。如果他没有这样做，会出现一条警告信息以确保相同。


请帮助我。

使用应用于详细表格的DCount：

展开 | 选择 | 换行 | 行号

< blockquote>感谢您的回复。


我使用了相同的代码，但不符合我的实际要求。


如果用户没有打出任何记录并从表单退出，虽然会出现一条消息，但会关闭表格。


我们怎样才能将焦点放在子表格的字段中主要形式。他们的任何命令都是以主要形式使用的子表格字段吗？实际上，主表格中没有子表格的控制（字段）。


请求您的帮助



>

使用应用于详细表格的DCount：

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

I have made a Form in Access 2000 which has Main Form & Sub Form. Main Form has (Header File) and Sub-Form has (Detailed File). Relationship between the primary key field of Header Table and Detailed Table is established with Casecade Update Related Fields and Casecade Delete Related Records.

I want that whenever User entered all the inputs in Header file, he must enter necessary records in Detailed file also & if he fails to do so, an alert message is appear to ensure the same.

Kindly help me.

解决方案

You have inadvertently posted your question in the Articles section rather than in the Forum section of our site, so I have moved it across to the Forum for you.

Linq ;0)>

I have made a Form in Access 2000 which has Main Form & Sub Form. Main Form has (Header File) and Sub-Form has (Detailed File). Relationship between the primary key field of Header Table and Detailed Table is established with Casecade Update Related Fields and Casecade Delete Related Records.

I want that whenever User entered all the inputs in Header file, he must enter necessary records in Detailed file also & if he fails to do so, an alert message is appear to ensure the same.

Kindly help me.

Use a DCount applied to your detailed table:

Expand|Select|Wrap|Line Numbers

Thanks for your reply.

I have used the same code, as given by you but it does not serve my actual requirement.

If user did not punch any record and quits from the form, though a message is appear but that close the form.

How can we got the focus in field of Sub-Form in main form. Is their any command to go to field of sub-form used in main form? Actually, there is no control (field) of sub-form available in main form.

Your kind help is requested

Use a DCount applied to your detailed table:

Expand|Select|Wrap|Line Numbers

这篇关于如果子表单没有记录，则发出警报消息。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！