删除记录 [英] delete record

问题描述

我有一个表单，当选中单选按钮并单击一个命令按钮时，该表单中的信息将通过追加查询传输到另一个表。我需要的是，当我点击该命令按钮时，我还希望它从基础表中删除该记录...请帮忙！谢谢！

解决方案

嘿didacticone，


因为你在这里没有提供很多细节。我将假设一些事情。


1.我假设当你将这些信息输入表格时，它要么不保存在当前表，或者根据选择的单选按钮和单击的命令按钮，您是否希望将信息存储在特定的表中？我是否正确？


2.假设这是正确的，首先我们要确保你正在使用的当前形式不是绑定到任何一张桌子，因为这会给你带来很多问题，我在挨打？


3.那么你将不得不创建和连接打开正确的表格，你想要把信息输入。


4.保存记录


5.关闭连接


6.清除表格。


如果您需要任何相关的代码示例，请告诉我。


谢谢，


Joe P。

对不起，我总是无法完全解释我到底需要什么帮助......让我再试一次......我举一个例子......我的表格基于一张桌子，里面有一个特定日子的约会清单。在表单上的每个约会旁边，我有一个单选按钮和一个命令按钮。我没有的功能是当一个单选按钮被检查预约并点击相应的控制按钮时，它会运行一个追加查询将该记录转移到另一个表中并打开另一个表格，该表格正在查看该记录的表格。刚刚附加...我知道它有点令人困惑...如果你有任何建议......我打开...但我想要的是...当我点击该命令按钮它也将删除最初从表格中检查过的记录...我希望能为您澄清一点......如果您愿意我甚至可以将数据库发送给您，这样您就可以获得更好的想法...感谢您的帮助！ / blockquote>

@didacticone


嘿didacticone，


如果您想附加数据库，我会非常高兴看到它。

从你所说的是，如果你有一个待定的约会，并且该约会被转移到活动状态，你希望能够将该动作发送到另一个表格以进行其他修改进入？正确吗？


如果是这样，那么这就是你要做的事情：


1.创建一个清单控制所有待处理的约会。

2.使用具有挂起约会的表中的主键值，查找选定的记录并将该表单中的任何信息提取到当前表单中，并使用这些值填充相应的字段。


如果您需要有关代码示例的帮助，请告知我们。


谢谢，


Joe P。

i have a form, when a radio button is checked and a command button is clicked, the information from that form is then transferred through an append query to a different table. what i need, is when i click that command button, i would also like it to delete that record from the underlying table... please help! thanks!

解决方案

Hey didacticone,

Since you don''t provide a great deal of detail here. I''m going to assume a few things.

1. I''m assuming that when you''re entering this information into the form, it is either not save in the current table yet, or depending on which radio button is select and which command button clicked, you''re wanting the information to be stored in a particular table? Am I correct?

2. Assuming that is correct, first thing is we''re going to have to make sure that the current form that you''re using isn''t bound to any table, because that is causing you a great deal of problems, I''m beating?

3. Then you''re going to have to create and a connection and open to the correct table that you''re wanting to put the information into.

4. Save the record

5. close the connection

6. clear the form.

If you need code example of any of this, please let me know.

Thanks,

Joe P.

sorry, i always have trouble fully explaining what exactly i need help with... let me try again... ill give an example... my form is based off of a table that has a list of appointments for a given day. next to each appointment on the form i have a radio button and a command button. the functions i have no are when a radio button is checked for an appointment and the corresponding control button is clicked, it runs an append query to transfer that record into another table and opens up another form which is looking at the table that the record was just appended too... i know its a little confusing... and if you have any suggestions with that... im open... but what i would like is... when i click that command button it also will delete the record that was originally checked from the form... i hope that clarifies a little better for you... if youd like i could even send you the database so you can get a better idea... thanks for your help!

@didacticone
Hey didacticone,

If you would like to attached your database, I would be more than happy to take a look at it.

From what you''re talking about is, if you have an pending appointment, and that appointment is moved into active status, you want to be able to send that action over to another form to make additional modifications to the entry? Correct?

If so, then here''s what you''re going to have to do:

1. Create a list control with all of the pending appointments.
2. Using the Primary Key value from the table that has the pending appointments, lookup the selected record and pull whatever information from that form into the current form and populate corresponding fields with those values.

Again, if you need help with code examples, please let me know.

Thanks,

Joe P.

这篇关于删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！