使用表单中的命令按钮来保存&然后打开一条新纪录 [英] Using a command button in a form to save & then open a new record

查看:66
本文介绍了使用表单中的命令按钮来保存&然后打开一条新纪录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

[z {mod-edit:Original of Original post}]

我希望在表单上有一个命令按钮来保存记录&然后要求开新记录。我是新来的。


我在带有主键的表单上有MDFID。


[z {mod-edit:9号帖子的开头}]


谢谢Seth,


坦率地说,我希望保存按钮能够执行以下操作:

1。检查是否有任何字段留空。

2.如果任何字段留空,则该按钮不允许用户保存&通过给出相应字段留言的消息提示。

3.如果所有字段都填满,那么按钮应该通过启用表单的新记录按钮来保存记录(新记录按钮不应该是在表格输入时启用)。


希望,我解释道。是否可以这样做?

[z{mod-edit:Start of Original post}]
I wanted to have a Command Button on a form to save a record & then ask to open a new record. I am new to access.

I have MDFID on a form with primary key.

[z{mod-edit:Start of what was post 9}]

Thanks Seth,

To be frank, I wanted the save button to do the following:
1. Check if any fields are left blank.
2. If any fields are left blank then the button should not allow the user to save & prompt by giving message of the corresponding field which is left blank.
3. If all fields are filled then the button should save the record by enabling New Record button of a form (new record button should not be enable at the time of form entry).

Hope, I explained. Is it possible to do ?

推荐答案

tajuddin,

你的问题让我觉得你可能会得到最好的一些课程可以从Access附带的示例数据库中学习。在帮助菜单下,您将找到示例数据库。探索这些,他们对那些将与他们投入足够时间的人非常有帮助。


有一个添加命令按钮的向导。该向导可以引导您以非常简单的方式保存表单上的记录以及许多其他有用的任务。


Jim
tajuddin,
Your question leads me to think you might be best served with some of the lessons one can learn from the sample databases that come with Access. Under the Help menu you will find "Sample Databases." Explore those, they are very helpful for those who will invest sufficient time with them.

There is a wizard for adding a command button. The wizard can lead you through saving a record on a form, and many other useful tasks, in a very simple manner.

Jim


Jim ,实际上,我使用以下代码:
Jim,

Actually, i am using the below code:
展开 | 选择 | Wrap | 行号


什么如果用户不想输入新记录,你想要发生吗?

保存记录的首选方法是
What do you want to happen if the user doesn''t want to enter a new record?

My preferred method of saving a record is
展开 | 选择 | Wrap | 行号


这篇关于使用表单中的命令按钮来保存&然后打开一条新纪录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆