防止记录被保存？ [英] Prevent a record being saved?
问题描述
你好！我仍然很新，只能使用它来获得
几天。
如果记录已部分填写或甚至完整填写
，然后表格关闭或用户点击查看替代
记录我不希望他们输入该记录的值是
已保存。
如果用户点击
我页面上的保存按钮，我只想保存valuse。
在我的表格中，我已将每个文本框的控制源设置为表格中的
relavent colmn，但我不希望这些更新表格
直到保存被选中。
这可能吗？如果不能，我可以做一个if语句
之类的... ...
如果还没有填写任何文本框。
完全删除此记录
非常感谢提前
Hello there! I''m Still pretty new to access only been using it for a
couple of days.
If a record has been partially filled out or even completly filled out
and then the form is closed or the user clicks to view an alternative
record i do not want the values they had typed into that record to be
saved.
I only want the valuse to be saved if the user clicks my save button on
my page.
On my form i have set the control source of each of my textboxes to the
relavent colmn in the table but i dont want these to update the table
untill save is selected.
Is this possible? If not could i do an if statment which said something
like..
If any of the textboxes have not been filled out.
Delete this record altogether
Many thanks in advance
推荐答案
si ************ @ gmail.com 写道：
[snip]
si************@gmail.com wrote:
[snip]
如果记录已部分填写或甚至完全填写
然后表单已关闭或用户点击查看替代
记录我不希望保存他们输入该记录的值。
如果用户单击我的保存按钮，我只想保存valuse
我的页面。
If a record has been partially filled out or even completly filled out
and then the form is closed or the user clicks to view an alternative
record i do not want the values they had typed into that record to be
saved.
I only want the valuse to be saved if the user clicks my save button
on my page.
[snip]
我不明白你为什么要做这样的事情，但是使用一个未绑定的
形式如果这是你想要的行为。
-
我没有查看电子邮件帐户ttached
到此消息。发送给...
在Hunter dot com的RBrandt
[snip]
I don''t understand why you would want to do such a thing, but use an unbound
form if this is the behavior you want.
--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
< si ************ @ gmail.com>在消息中写道
news：11 ********************** @ g47g2000cwa.googlegr oups.com ...
<si************@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
你好！我仍然很新，只能使用它几天。
如果记录已部分填写或甚至完整填写
然后表单已关闭或用户单击以查看替代
记录我不希望保存他们键入该记录的值。
我只想要valuse如果用户在我的页面上单击我的保存按钮，则保存。
在我的表单上，我已将每个文本框的控件源设置为
relavent colmn表，但我不希望这些更新表
直到保存被选中。
这可能吗？如果不能，我可以做一个if语句，如
如果还没有填写任何文本框。
完全删除此记录
<非常感谢提前
Hello there! I''m Still pretty new to access only been using it for a
couple of days.
If a record has been partially filled out or even completly filled out
and then the form is closed or the user clicks to view an alternative
record i do not want the values they had typed into that record to be
saved.
I only want the valuse to be saved if the user clicks my save button on
my page.
On my form i have set the control source of each of my textboxes to the
relavent colmn in the table but i dont want these to update the table
untill save is selected.
Is this possible? If not could i do an if statment which said something
like..
If any of the textboxes have not been filled out.
Delete this record altogether
Many thanks in advance
而不是专注于前端编码，你应该看看
后端表设计。也就是说，如果你不允许在字段中使用空值或
零长度字符串，那么除非你已经填写了必填字段，否则你无法保存记录。这比你可能想出的任何形式/编码更加强大。
防止空白。
Rather than focussing on the front-end coding, you should be looking at the
back-end table design. That is, if you do not allow null values or
zero-length strings in the field then you cannot save the record unless you
have filled in the required fields. This is a much more robust way to
prevent ''blanks'' than any forms/coding you might come up with.
True但是如果您将文本框设置为必填项，并且用户单击以转到
之前的表单，则他们无法直到他们填写了
焦点当前设置为的文本框。 br />
True but if you set a textbox to compulsory and a user clicks to go to
previous form they cant untill they have fill ou the text box the
focus is currently set to.
这篇关于防止记录被保存？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
