Webb App - 访问Webb App打开弹出视图到特定记录 [英] Webb App - Access Webb App Open Pop Up View to a specific record

问题描述

您好，

我知道有一个相关的主题：

I know there is a thread out there that is related:

https：//social.msdn。 microsoft.com/Forums/office/en-US/d777aa1d-1f95-4562-a00b-5ea1037333b6/web-app-where-clause-on-a-macro-to-open-popup-form-to-specific-record？ forum = accessdev

https://social.msdn.microsoft.com/Forums/office/en-US/d777aa1d-1f95-4562-a00b-5ea1037333b6/web-app-where-clause-on-a-macro-to-open-popup-form-to-specific-record?forum=accessdev

但我不认为我的情况完全一样。我也是编程和访问webb应用程序的新手，所以请光临我。我想要做的是创建一个快捷按钮，它将自动完成当前记录列表中的组合框，此外
在我们的呼叫列表中为特定记录添加一个条目。我的申请结构是： 

But i don't think my situation is exactly the same. I am also new to programming and acces webb app so please bare with me. What i am trying to do is create a shortcut button that will auto complete a Combo Box in the current record list and in addition add an entry in our Call List for a specific record. The structure of my application is: 

表格列表：此表格包含我们的客户信息。

Table List: this form contains our client information.

- 出于我想要做的目的，我们的用户使用此表单来选择帐户的一般状态（例如投票FOR），这将是一个组合框。 

- For the purpose of what im trying to do, our users uses this form to choose a general status for an account (ex. Voted FOR) which would be a Combo Box. 

- 此外，我已经在我的第二个表（呼叫日志）列表中构建了一个相关项控件，该列表具有一个查找字段，用于在我的第一个表中使用HolderID文本框将新的呼叫日志条目链接到我的第一个表。这受第一个
表中的自动ID字段的约束。如果我只是点击添加呼叫日志链接，持有人ID就会直接链接到我添加呼叫日志的记录，但我现在要做的是添加一个按钮，它会自动填充我第一个表格上的组合框然后打开通话记录链接，然后自动
填写另一个表上的通话记录字段。所以按顺序，前三个步骤即可：

- In addition, i have built a Related Item Control to my second Table (Call Log) List which has a look up field to link a new call log entry to my first table using a HolderID Text Box in my first table. This is bound by the automatic ID field in the first table. If i simply click on the add a call log link, the Holder ID links exactly to the record im adding a call log to, but what i want to do now is add a button that will auto fill the combo box on my first table then open the call log link and then auto fill the call log fields on another table. So in order, first three steps im able to do:

1。单击（示例：左语音邮件按钮）

1. Click on (example: Left Voice Mail Button)

2。表一当前记录通过组合框上的"左侧语音邮件"状态更新。 

2. Table One Current Record gets updated with `Left Voice Mail`status on Combo Box. 

3。保存当前记录

4。打开呼叫日志表（列表视图），其中已根据表1当前记录填充ID。 （例如：如果表1中的记录具有ID 4226，那么当使用该按钮打开呼叫日志视图时，该ID将从关于
的ID拉到特定记录。 

4. Open Call Log Table (List View), where the ID is already populated based on Table One current record. (Example:if the record in table one has an ID 4226, then when the Call Log View is opened using the button, then the ID will pull from the ID pertaining to the specific record. 

5.接下来，来自通话记录的通话结果将输入为"左语音邮件"

5. Next, the call result from the call log will be entered as `Left Voice Mail`

6.保存记录并关闭弹出窗口。 

6. Save record and close pop up. 

表1中的最终结果应该看起来像主编号一样编码为Left Voice Mail，相关的项目控件应显示语音邮件留下的日期。我需要的原因将呼叫记录记录为左语音邮件，我们需要计算
我们在主文件上拨打特定人员的次数。因此，当表一状态可能永远不会改变时，呼叫记录可能会显示三个语音邮件的记录。 

The end result on table one should look have the main account as coded as Left Voice Mail, and the related item control should show the date when the voice mail was left. The reason why i need the call log recorded as left voice mail, is we need to count how many times we have made a call to a particular person on the main file. so while table one status may never change, the call log could show three records of voice mail. 

所以我遇到了Open Pop功能的问题以及我当前代码在哪里部分是：

So I am having problems with the Open Pop Feature and my current code in the where portion is:

= [CallLog]。[HolderID] = [IDTextBox]

=[CallLog].[HolderID]=[IDTextBox]

这里我引用了Ho中的呼叫记录表lderID文本框，设置为查找表一"ID"字段。然后我说让它成为ID。 

here i was referencing the Call Log Table in the HolderID text box which is set up as a Look Up to Table One `ID` field. then i said make it = to the ID. 

但是当我运行它时，它只是在编辑模式下为新条目打开一个呼叫日志列表视图。我需要在我的第一个表格中打开当前帐户的ID，然后自动填充通话结果。 

But when i run this, it just opens up a Call Log List view in edit mode for a new entry. I need this to open up with the id of the current account in my first table, and auto populate the call result. 

对于长篇帖子感到抱歉，希望有人可以帮我解决在这方面，现在已经坚持了两天而且我疯了，任何帮助都会受到赞赏！ 

sorry for the long post and hopefully someone can help me out on this, been stuck on this for two days now and im going insane, any help would be appreciated! 

推荐答案

Hi Battery_Checked，

Hi Battery_Checked,

>>当我运行它时，它只是在编辑模式下打开一个新条目的呼叫日志列表视图。我需要在我的第一个表中打开当前帐户的id，并自动填充调用结果。

>> when i run this, it just opens up a Call Log List view in edit mode for a new entry. I need this to open up with the id of the current account in my first table, and auto populate the call result.

我使用OpenPop进行了测试，并且where语句正常工作如果[CallLog]中存在[IDTextBox]的值。[HolderID]。我提出了一个特定的情况，即[CallLog]中没有[IDTextBox]的值。[HolderID]，此时，
OpenPop将出现一个空视图。所以，首先我建议你检查[CallLog]中是否存在IDTextBox的值。[HolderID]。

I made a test with OpenPop, and the where statement worked correctly for me if the value of [IDTextBox] exists in the [CallLog].[HolderID]. I made a specific situation that the value of [IDTextBox] do not exist in the [CallLog].[HolderID], at this time, the OpenPop will appear an empty view. So, first I suggest you check whether the value of the IDTextBox exist in the [CallLog].[HolderID].

如果[CallLog]中存在IDTextBox。[HolderID]，它没有在OpenPop视图中显示，我建议您分享相关表数据的屏幕截图，以及用于打开OpenPop视图的按钮事件。

If IDTextBox exist in the [CallLog].[HolderID], and it did not show in the OpenPop view, I will suggest you share us the screen shot of the related table data, and the button event you use to open OpenPop view.

最好的问候，

Edward

这篇关于Webb App - 访问Webb App打开弹出视图到特定记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！