在VBA中捕获表单上的用户输入 [英] capture a user input on a form in VBA

问题描述

我需要在用户点击附加查询按钮并输入订单号后捕获用户输入。使用此捕获的il使用变量将其与archeive查询中的删除进行比较

I need to capture user input after user clicks append query button and types in an order number. with this captured il use the variable to compare it to the delete from archeive query

推荐答案

您的问题远非明确。


听起来好像你正试图从表格或查询中找到一条记录。

你能否重新解释这个问题并告诉我们你想要实现的目标，而不是关于捕获的详细信息。按钮。


菲尔

Your question is far from clear.

It sounds as if you are trying to find a record from a table or query.
Could you rephrase the question and tell us what you are trying to achieve, rather than the detail about capture & buttons.

Phil

如果我能找到一种发布屏幕截图的方法我认为这会有所帮助，如果我有一个猜测我会说setfocus methodmight help

if i could find a way to post a screen shot i think that would help, if i had a guess i would say the setfocus methodmight help

使用PrintScreen捕获你的屏幕。


使用Paint将其裁剪到相关区域。将其收缩至约3英寸宽和2高。它仍然很容易阅读吗？


然后在这个网站上使用高级选项卡 - >>插入 - >管理Attachmente以选择图像。选择上传


如果双击图像，它将显示类似
https://bytes.com/attachment.php?att...1&d=1516724952 因为它是地址。


复制该地址，在本网站上，点击插入图片（黄色）符号。


将地址粘贴到该地址。
< br $> b $ b祝你好运


Phil

Use PrintScreen to capture your screen.

Use Paint to crop it to the relevant area. Shrink it to about 3" wide and 2" high. Is it still easy to read?

Then on this website use the Advanced Tab ->> Insert --> Manage Attachmente to select the image. Select Upload

If you double click on the image, it will show something like
https://bytes.com/attachment.php?att...1&d=1516724952 as it''s addtress.

Copy that address and on this website, click the Inset Image (Yellow) symbol.

Paste the address into that.

Good luck

Phil

这篇关于在VBA中捕获表单上的用户输入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！