OnClick事件编码 [英] OnClick Event coding

问题描述

任何人都可以帮我解决一些VBA编码问题。


我想有两个文本框，用户可以在任意一个框中输入一个数字单击搜索按钮以显示记录。


例如：


VIN num SEARCH

型号


用户可以输入VIN或型号，具体取决于他们拥有的VIN或型号。 ***这些不是我使用的例子****


我需要帮助OnClick事件编码

解决方案

请记住为任何已启动的线程提供有意义的标题（请使用适当的标题for New Threads！）。这有助于确保其他成员以及公众更有机会找到任何类似问题的答案。


主持人。

< blockquote>

任何人都可以帮我解决一些VBA编码。



我想有两个文本框，其中用户可以在任一框中输入数字，然后单击搜索按钮以显示记录。


例如：


VIN num SEARCH

型号


用户可以输入VIN或型号，具体取决于他们拥有的VIN或型号。 ***这些不是我使用的例子****


我需要OnClick事件编码的帮助

onclick事件编码究竟出现了什么问题？

如果我有这个权限你要提示用户输入两个值，然后点击搜索按钮调出显示特定于这些值的记录的表单。


假设我们使用的两个值是modelID和yearID，它们是文本数据类型。

相应的文本框是txtModelID和txtYearID。

记录的格式为frmDisplayRecord。


文本框中的值将用于构建open form命令的WHERE语句。构建完成后，我们只需将字符串作为参数和我们要打开的表单的名称一起传递。

展开 | 选择 | 换行 | 行号

Can anyone help me out with some VBA coding.


I would like to have two text boxes where the user can enter a number in either of the boxes and click a search button to bring up the record.

Example of this is:

VIN num SEARCH
Model num

User can enter a VIN or model number depending on which one they have. ***These are not the feilds im using just examples****


I need help with the OnClick event coding

解决方案

Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR.

Can anyone help me out with some VBA coding.


I would like to have two text boxes where the user can enter a number in either of the boxes and click a search button to bring up the record.

Example of this is:

VIN num SEARCH
Model num

User can enter a VIN or model number depending on which one they have. ***These are not the feilds im using just examples****


I need help with the OnClick event coding

what exactly is the problem with the onclick event coding?

If I have this right you want to prompt the user for two values and then clicking the search button bring up a form displaying the record specific to those values.

Let''s assume the two values we are working with are modelID and yearID and they are text data types.
The corresponding text boxes are txtModelID and txtYearID.
The form for the record will be frmDisplayRecord.

The values from the textboxes will be used to build the WHERE statement of the open form command. Once built we just pass the string in as a parameter along with the name of the form we want to open.

Expand|Select|Wrap|Line Numbers

这篇关于OnClick事件编码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！