如何创建附加到表的数据输入表单（也使用查询）。 [英] How to create a data entry form (using a query, too) that appends to a table.

问题描述

早上好！


我查看了我的Access圣经，但我很困惑。


我有一张桌子，它是制作成查询，然后在表单中使用。


最终用户输入信息（和/或从下拉框中选择）。有四个条目可供制作，从这些条目中它们会自动创建一些不同的符号。 （一种符号格式的示例：SPX 090221C00221000）。


我需要做的是每个条目和创建的符号，它们都需要写入一个表，同一个表（就像一个计数 - 它继续增长）。


我可以这样做吗？我正试图弄清楚如何使用我所提供的表格来查询附件。


如果需要更多信息，请告诉我。我不知道怎么问这个问题，我是不是要留下什么重大的东西！


谢谢你的帮助！

解决方案

通常，您将数据集绑定到表单（或者更准确地说，反之亦然），然后可以更新数据甚至添加到该表单。


我不确定这是你想到的（应该是），还是你想在事后用SQL附加数据。可以说，使用SQL在记录基础上追加数据很少是可取的。我很少说，但只是因为我接受这样的想法，即可能会出现一种我不知道哪种情况适合的情况。我当然不能想到它。


显然，以这种方式绑定的任何查询都需要是一个可更新的查询（参见查询不可更新的原因）。

< blockquote>你好NeoPa，


我很无能，请原谅我。可能很容易解决我需要做的事情，但还没有想到它。我很喜欢Bytes！


但是如果需要的话，我会再提一些，然后再回到Bytes。


发送消息后，我意识到我可能知道如何做到这一点。但这是值得怀疑的。


谢谢！

Faith

如果你继续挣扎，请告诉我们信仰。尽可能清楚地了解您的困惑，我们会尽力帮助解决您的具体问题。

Good morning!

I looked through my Access bible but I''m baffled.

I have a table and it was made into a query and then used in a form.

The end user enters the information (and/or chooses from drop down boxes). There are four entries to make and from those entries they automatically create a handful of various symbols. (an example of one symbol format: SPX 090221C00221000).

What I need to do is for every entry made and symbols created, they all need to write to a table, the same table (like a tally - it continues to grow).

Can I do this? I''m trying to figure out how to use the Append from the query by form I made.

If more information is need please let me know. I''m not sure how to ask the question and if I''m leaving anything major out!

Thank you for the help!

解决方案

Typically, you bind your dataset to the form (or more accurately vice-versa) and the data can then be updated or even added to that way.

I''m not sure if this is what you''re thinking of (it should be) or if you''re thinking of appending data using SQL after the fact. Suffice to say appending data on a record by record basis using SQL is rarely advisable. I say rarely, but only because I accept the idea that it''s possible there''s a scenario I don''t know of where it may be appropriate. I certainly can''t think of one though.

Clearly, any query bound to in this way would need to be an updatable query (See Reasons for a Query to be Non-Updatable).

Hi NeoPa,

I''m clueless, please forgive me. There is probably a very easy solultion to what I need to do but haven''t figured it out yet. I''m greatful for Bytes!

But I''m going to fiddle some more and then come back to Bytes if need be.

After I sent the message I realized I may know how to do this. But it''s doubtful.

Thank you!
Faith

Let us know if you continue to struggle Faith. Be as clear as you can about what confuses you and we''ll try to help with your specific problem.

这篇关于如何创建附加到表的数据输入表单（也使用查询）。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！