如何清除Access中窗体上的按钮 [英] How to clear the buttons on a form in Access
问题描述
亲爱的所有人，感谢您的阅读！
我制作了一个包含大量按钮的表单，以方便最终用户输入数据。
所有按钮在转到下一条记录后都保持高亮。
我找到解决此问题的唯一方法是关闭表格并重新打开。
有没有办法重置表单，或者是否有可以编写的代码可以一键打开和关闭表单？
我希望按下一个按钮进入下一个记录并清除表格。这将是一个完美的场景。
我是Access的新手，所以我已经阅读了有关此内容的其他帖子，但我无法使我的表单与他们的示例一起工作。就像单词clear一样，但按钮不会重置。
这是使我的表单可用的最后一步，所以我希望有人可以帮助我！
谢谢，
Rachel
嗨Rachel！
欢迎来到字节！
能否请您澄清清算是什么意思？按钮或重置按钮按钮？
我想在我们可以帮助您之前，我们需要使用相同的术语。
感谢您的帮助。
你好Rachel。
我相信我们能够帮助你，但是我对你所做的一点都不了解重新尝试解释。
ArkWent2Sea：
所有按钮在转到后都保持高亮下一条记录。
我希望制作一个按钮进入下一条记录并清除表格。
这些句子是什么意思？没有上下文，很难知道你在问什么。
为什么你首先在表单上有一堆按钮？你在做什么类型的表格？这是一个简单的添加/编辑/删除表单吗？是否处于连续表格模式？
请尝试回答提出的所有问题。如果你愿意，请给他们编号。
亲爱的，
感谢您的回复！
我附上照片以便更好地理解。该表格将用于我的团队记录我们拥有的设备的状态。
当我创建表单时，我使用了按钮选项。在控件中创建一种只需单击一下即可将数据输入到表单中的方法。
当您在点击之前看到图像按钮时您可以看到按钮是蓝色矩形（点击时，他们在我的表单中放置一个单词，反映设备的状态）
在图像上点击后按钮您可以看到蓝色按钮已被加亮成深蓝色以表示被选中。
在图像上下一条记录后的按钮您可以看到文本已清除以允许新记录但按钮尚未恢复为其未选定状态。浅蓝色。
这对最终用户来说很困惑。我想要的是当表单进入下一个记录时，所有按钮都变为默认的淡蓝色未选择的颜色。
我能做到这一点的唯一方法是打开和关闭每条记录的表格。可以制作一个宏吗？或者有更好的方法吗？
亲切的问候，
感谢您的帮助！
Rachel
Dear All, thank you for reading!
I have made a form which contains a lot of buttons for ease of data input for the end user.
All the buttons stay high-lighted after moving on to the next record.
The only way I have found to solve this is to close the form and reopen it.
Is there a way to reset the form or is there code I could write that could open and close the form in one click?
I was hoping to make a button that goes to next record and clears the form. That would be the perfect scenario.
I am new to Access so I have read other posts about this but I have not been able to make my form work with their examples. Like the words clear, but the buttons won''t reset.
This is the last step to making my form usable so I hope someone can help me!
Thanks,
Rachel解决方案Hi Rachel!
Welcome to Bytes!
Could you please clarify for us what you mean by "clearing" buttons or "resetting" buttons?
I think before we can help you, we need to have the same terminology.
Thanks for the assistance.
Hi Rachel.
I''m sure we''ll be able to help you, but I for one have little understanding of what you''re trying to explain.
ArkWent2Sea:
All the buttons stay high-lighted after moving on to the next record.
I was hoping to make a button that goes to next record and clears the form.What do these sentences mean? Without context it''s hard to know what you''re asking about.
Why do you have a bunch of buttons on the form in the first place? What type of Form are you working with? Is it a simple Add/Edit/Delete Form? Is it in Continuous Form mode?
Please try to answer all questions posed. Number them if you like.
Dear All,
Thank you for your responses!
I have attached photos for better understanding. The form is to be used for my team to record the status of equipment we own.
When I created the form I used the option "button" in controls to create a way of inputting data into my form with just one click.
When you see image "buttons before click" you can see the buttons are the blue rectangles (when clicked they place a word in my form which reflects the status of the equipment)
On image "buttons after click" you can see that the blue buttons have been hilighted into a darker blue to signify being selected.
On image "buttons after next record" you can see that the text has cleared to allow for a new record but the buttons have not reverted to their "unselected" colour of light blue.
This is confusing for the end user. What I would like is for when the form goes to next record, all the buttons change to their default light blue unselected colour.
The only way I can make that happen is by opening and closing the form for every record. Can one make a macro that does that? Or is there a better way to do this?
Kind Regards,
Thank you for all your assistance!
Rachel
这篇关于如何清除Access中窗体上的按钮的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
