访问表单中的动态显示 - 可能吗？ [英] Dynamic display in Access Form - possible?
问题描述
我有点像excel的高级用户和Access的新手虽然可能性令我兴奋:-)
我正在尝试在Access中创建一个工具来替换Excel中的现有工具。我的问题是我是否能够复制我在Excel中可以做的一些关键功能。
Excel工具是我公司的操作员输入质量控制记录的生产中的测试。由于我们有很多复杂的测试，因此我能够使用一些excel功能让它们更容易：
1.在Excel中，我的表单动态显示''Acceptance Range''和'每个字段旁边的说明。 （这些在TableX中指定，具体取决于正在制作的产品类型）Access中的表单是否也可以根据一些预先选择的标准动态显示表中的信息？
2.当他们进入测试时结果它会立即变为红色或绿色，具体取决于结果是否可接受（通过检查它是否属于TableX的''验收范围'）。如果我在访问中创建了一个表单，那么在提交表单之前，每个字段（测试结果）之后是否仍然会创建一些视觉反馈？
我公司的运营商保留当前Excel文件全天打开，如果产品进入危险区域并需要隔离，则依赖它来标记它们。但问题是，使用excel工具，无法在领导层可以审阅的不同文件中创建报告。我希望通过迁移到Access，我将能够创建我需要的报告。但是我不认为运营商会接受它，如果它没有像现在这样给他们即时反馈。
我真的希望有人会说这是可能的办法。任何有关如何做到这一点的帮助非常感谢。 :-)
Mathew
Hi,
I''m somewhat of a power user in excel and a newbie to Access though the possibilities are exciting me :-)
I am trying to create a tool in Access to replace an existing tool in Excel. My question is whether I will be able to replicate some key features that I was able to do in Excel.
The Excel tool was for operators in my company to put in records of Quality Control tests in production. Since we have a lot of complex tests, I was able to make it much easier for them with some excel features:
1. In Excel, my form dynamically displays the ''Acceptance Range'' and ''Instructions'' next to each field. (These are specified in TableX depending on the type of product being made) Can a form in Access also dynamically display information from a table based on some pre-selected criteria?
2. when they enter a test result it immediatelly turns red or green depending whether the result is acceptable or not (by checking whether it falls within the ''Acceptance Range'' of TableX). If I create a form in access, is there anyway of creating some visual feedback after each field (test result) is filled even before the form is submitted?
The operators in my company keep the current Excel file open all day long and depend on it to flag them if product is getting into the danger zone and needs to be quarantined. But the problem is that with an excel tool, one cannot create reports across different files that the leadership can review. I am hoping that by migrating to Access, I will be able to create the reports I need. But I don''t think operators will accept it if it doesnt give them instant feedback like they''re getting now.
I am really hoping somebody will say this is possible in some way. Any help on how to do this is GREATLY appreciated. :-)
Mathew
推荐答案
形成你所说的，看来这可以轻松而有效地成为在Access中完成。对于初学者，我会猜测哪些Fields包含TableX，只要告诉我哪些是正确/不正确的，然后填写缺少的空白。
Form what you are saying, it would appear that this could easily and more efficiently be accomplished within Access. For starters, I''ll take a guess as to which Fields comprise TableX, just tell me which ones are correct/incorrect, then fill in the missing blanks.
形成你所说的，看起来这可以在Access中轻松，高效地完成。对于初学者，我会猜测哪些Fields包含TableX，只要告诉我哪些是正确/不正确的，然后填写缺少的空白。
Form what you are saying, it would appear that this could easily and more efficiently be accomplished within Access. For starters, I''ll take a guess as to which Fields comprise TableX, just tell me which ones are correct/incorrect, then fill in the missing blanks.
--------------------------- ------------------------
这几乎是准确的。
-TableX不包含[测试结果]。这填写到表单中并进入另一个表。
-it确实包含一个额外的字段; [测试类型]。我们对每种产品都有30-40种不同的测试，每种产品的验收范围和说明都不同。
感谢您的快速反应ADezii :-)
Mathew
---------------------------------------------------
Thats almost exact.
-TableX does not contain [Test Results]. That is filled into the form and goes into another table.
-it does contain an additional field; [Test Type]. We have some 30-40 different tests for each product and the acceptance range and instructions are different for each.
thanks for the quick response ADezii :-)
Mathew
只需检查Matthew，稍后会报告并查看我们是否可以帮助您入门。
Just checking in Matthew, will report back later and see if we can get you started.
这篇关于访问表单中的动态显示 - 可能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
