在ClosePopup - Access 2013 Web App上刷新父视图 [英] Refresh a parent view upon ClosePopup - Access 2013 Web App

问题描述

我正在Access 2013中构建一个Web应用程序，我必须诚实地说，缺少可用的文档非常令人沮丧。 根据用户要求，我需要控制数据输入流程并通过各种向导引导用户输入产品
测试信息。 我不认为Access网络应用程序是提供此功能的最佳方式，但我的担忧似乎被置若罔闻，所以我试图让它发挥作用。

I am building a web app in Access 2013 and I have to be honest here, the lack of documentation available is extremely frustrating.  Per user requirements, I need to control the flow of data entry and walk users through a wizard of sorts to enter product testing information.  I don't think an Access web app is the best way to deliver this but my concerns appear to fall on deaf ears so I'm attempting to get it to work.

我有一个主要表单，允许用户单击按钮并开始新的产品测试或选择现有的产品测试来完成。 从该表单中，根据测试类型，我使用OpenPopup宏打开自定义视图，以允许用户输入SKU，产品编号和其他产品特定信息
。 然后，他们点击一个触发另一个OpenPopup的按钮，以显示用户将输入测试特定信息的视图。 我需要使用OpenPopup因为
我需要将他们运行的测试数量限制为管理员指定的数量。 我试图使用RelatedItem控件，但是我没有足够的控制弹出视图，所以我不得不创建一个自定义弹出窗口。

I have a main form that will allow the user to either click a button and start a new product test or choose an existing product test to complete.  From that form, depending on the type of test, I use an OpenPopup macro to open a custom view to allow the user to enter SKU, product number and other product specific information.  Then they click on a button that fires another OpenPopup to display a view on which the user will enter test specific information.  I need to use an OpenPopup because I need to limit the number of tests they run to an administrator specified number.  I tried to use the RelatedItem control but I don't have enough control over the Popup View so I had to create a custom popup.

如果我能够控制弹出视图属性一个相关的项目控件（即如果测试表中有超过3个记录与产品测试表中的测试ID匹配，不允许再输入任何记录），我不会在我当前的
。绑定 不幸的是，我没有对控件的这种控制水平。

If I were able to control the Popup View property of a related item control (i.e. if there are more than 3 records in a test table that match the test ID in the product test table, do not allow anymore records to be entered), I wouldn't be in my current bind.  Unfortunately, I don't have that level of control over the control.

所以在一天结束时，我还是使用OpenPopup来打开允许用户输入数据的自定义表单 但是，一旦他们保存测试信息，我想允许他们将产品测试提交到后端数据库。 为了做到这一点，我需要
以某种方式刷新在子视图上触发OpenPopup的父视图，然后启用用户可以按下以提交数据的按钮。

So at the end of the day, I'm left using OpenPopup to open custom forms that allow users to enter data.  Once they save test information, though, I want to allow them to commit the product test to the backend database.  In order to do that, I need to somehow refresh a parent view that fires an OpenPopup on a child view which will then enable a button the user can press to commit data.

有什么方法可以在子视图触发ClosePopup事件后刷新基础视图吗？

逻辑流程：主视图（选择新的或现有的测试） - >产品测试视图（输入产品特定信息，用户信息，日期） - > 产品压力测试视图（输入特定测试类型的通过/失败值）

Logical flow: Home view (choice of new or existing test) --> Product Test view (enter product specific information, user information, date) -->  Product stress test view (enter pass/fail values for specific test type)

保存压力测试数据后，我需要刷新产品测试视图并允许用户提交数据。 这将启用提交按钮。 然后，在提交数据时，应该刷新主视图以及关闭产品测试视图
弹出窗口。 例如，如果用户继续进行现有测试，则一旦他们提交测试结果，就应该从未完成测试的子视图中删除继续测试。 如果测试具有结束日期，并且当用户单击产品测试视图上的提交按钮时，测试记录中的结束日期为
，则认为测试已完成。

Upon saving stress test data, I need to refresh the product test view and allow the user to commit data.  That will enable a commit button.  Then, upon committing data, the main view should be refreshes as well as closing the product test view popup.  For example, if a user continues an existing test, once they commit their test results, the continued test should be removed from the sub-view of unfinished tests.  Tests are considered finished if they have an end date and the end date is added to the test record when the user clicks the commit button on the product test view.

我很感激我可以得到任何帮助。 我正在试图解决这个问题。

I appreciate any help I can get on this.  I'm pulling my hair out trying to figure this out.

推荐答案

嗨Craig831，

Hi Craig831,

我会就你的问题咨询我的同事，这需要一些时间。非常感谢您的耐心。

I will consult my colleagues on your question, and it will take some time. Your patience will be greatly appreciated.

问候，

Jeffrey

这篇关于在ClosePopup - Access 2013 Web App上刷新父视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！