初始条目后，查询字段不会更新 [英] Query fields will not update after intial Entry

问题描述

大家好，两天的网络搜索，我还没有找到答案。


访问开发的新手很合适。


Access 2000在Windows XP上使用Access 2003的数据库


我在创建查询时遇到问题，我可以将部件ID作为值输入，并且描述，成本等等在其余部分中填充查询。


我有两张桌子; ItemMaster和[初始输入]

[初始输入]有一个值：[部件ID]

和ItemMaster有几个，但我只限于Segment1，Description，Item_Cost


我想创建一个基于查询的表单，当输入部件ID时，查询运行并显示其余信息。这将稍后附加到一个表格中，该表格将由另一个用户跟进。


我遇到的问题是除非保存，关闭和重新打开或切换，否则查询不会更新观点。因此，不是输入一个值而是自动填入其余值，而是输入到下一个空白值。


我之前已经完成了几次这样的操作工作。一个可能有所作为的项目是我只是转移到一台新PC并尝试更改所有选项，所以我可能选中/取消选中我不应该拥有的东西。


任何帮助或帮助都可以赞赏


谢谢

展开 <跨度类= codeDivider > | <跨度类= codeLink点击=selectAll（this）;>选择 | Wrap < span class =codeDivider> | 行号

解决方案

< blockquote>

大家好，两天的网络搜索，我还没有找到答案。


访问开发的新手很合适。


使用acc访问2000 DB在Windows XP上使用ess 2003


我在创建查询时遇到问题，我可以将部件ID作为值输入，并且在描述的其余部分填充描述，成本等等。 。


我有两张桌子; ItemMaster和[初始输入]

[初始输入]有一个值：[部件ID]

和ItemMaster有几个，但我只限于Segment1，Description，Item_Cost


我想创建一个基于查询的表单，当输入部件ID时，查询运行并显示其余信息。这将稍后附加到一个表格中，该表格将由另一个用户跟进。


我遇到的问题是除非保存，关闭和重新打开或切换，否则查询不会更新观点。因此，不是输入一个值而是自动填入其余值，而是输入到下一个空白值。


我之前已经完成了几次这样的操作工作。一个可能有所作为的项目是我只是转移到一台新PC并尝试更改所有选项，所以我可能选中/取消选中我不应该拥有的东西。


任何帮助或帮助都可以赞赏


谢谢

展开 | 选择 | Wrap < span class =codeDivider> | 行号

Nope，未选中已经。


我做了检查测试，取消检查测试，到目前为止没什么。


我已经测试了另一台PC上的另一个数据库我也有一个类似的问题，所以也许是只是我。

Nope，已经取消选中。


我确实检查了测试，到目前为止，取消选中测试，没有任何内容。


我已经在另一台PC上的另一个数据库上进行了测试，我也遇到了类似的问题，所以也许只是我。

顺便说一句，您在帖子中显示的查询不是更新查询或插入查询...它只是一个选择查询。这不是您所说的查询而不是更新吗？

Hello all, two days of websearching and I cannot find an answer yet.

Reasonably new to access development.

Access 2000 DB using access 2003 on windows XP

I am having an issue with creating a query that I can enter the Part ID as value and hvae the description, cost etc. populate in the rest of the query.

I have two Tables; ItemMaster and [Initial Input]
[Initial Input] has one Value: [Part ID]
and ItemMaster has several but i have limited to Segment1, Description, Item_Cost

I want to create a form based on a query that when the Part ID is entered that the query runs and displays the rest of the information. This will later be appended to a table which will be followed up on by another user.

The problem I have is that the query will not update unless saved, closed and reopened, or switch views. So instead of Entering in the one value and the rest of the values filling in automatically, enter just goes to the next blank value.

I have done this several time before and they have all worked. One item that may make a difference is i just transfered to a new PC and attempted to change all the options so perhaps i checked/unchecked something i shouldnt have.

Any help or assistance can be appreciated

Thanks

Expand|Select|Wrap|Line Numbers

解决方案

Hello all, two days of websearching and I cannot find an answer yet.

Reasonably new to access development.

Access 2000 DB using access 2003 on windows XP

I am having an issue with creating a query that I can enter the Part ID as value and hvae the description, cost etc. populate in the rest of the query.

I have two Tables; ItemMaster and [Initial Input]
[Initial Input] has one Value: [Part ID]
and ItemMaster has several but i have limited to Segment1, Description, Item_Cost

I want to create a form based on a query that when the Part ID is entered that the query runs and displays the rest of the information. This will later be appended to a table which will be followed up on by another user.

The problem I have is that the query will not update unless saved, closed and reopened, or switch views. So instead of Entering in the one value and the rest of the values filling in automatically, enter just goes to the next blank value.

I have done this several time before and they have all worked. One item that may make a difference is i just transfered to a new PC and attempted to change all the options so perhaps i checked/unchecked something i shouldnt have.

Any help or assistance can be appreciated

Thanks

Expand|Select|Wrap|Line Numbers

Nope, Was unchecked already.

I did check it test, uncheck test and nothing so far.

I have since tested on another database on another PC and i am also having a similiar issue there, so maybe it is just me.

Nope, Was unchecked already.

I did check it test, uncheck test and nothing so far.

I have since tested on another database on another PC and i am also having a similiar issue there, so maybe it is just me.

By the way, the query that you are showing in your post is not an update query or insert query ...it is just a select query. This is not the query that you were talking about it not updating is it?

这篇关于初始条目后，查询字段不会更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！