如何使用VBA选择(突出显示)数据表中的记录? [英] How do I select (highlight) a record in a datasheet using VBA?

查看:72
本文介绍了如何使用VBA选择(突出显示)数据表中的记录?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

这个简单的愚蠢的事情让我难过!


光标位于数据表的记录中。我如何选择该记录

(突出显示),就像我使用VBA点击记录选择器一样。


问候。

Barry

---

来自Barry Wright的这封电子邮件已经使用AVG 6.0扫描,并且已经过认证

无病毒。

由AVG反病毒系统检查( http://www.grisoft.com)

版本:6.0.541 /病毒库:335 - 发布日期:11/14/03

This simple stupid thing has me stumped!

The cursor is on a record in a datasheet. How do I select that record
(highlight) like I would if I clicked on the Record Selector using VBA.

Regards.
Barry
---
This email from Barry Wright has been scanned using AVG 6.0 and is certified
Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.541 / Virus Database: 335 - Release Date: 11/14/03

推荐答案

Runcommand acCmdSelectRecord

-

Allen Browne - Microsoft MVP。西澳大利亚州珀斯。

访问用户提示 - http:// allenbrowne.com/tips.html

回复群组,而不是mvps dot org的allenbrowne。


" Barry Edmund Wright" < BA ***************** @ rogers.com>在消息中写道

新闻:sX ******************* @ news04.bloor.is.net.cab le.rogers.com .. 。
Runcommand acCmdSelectRecord

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:sX*******************@news04.bloor.is.net.cab le.rogers.com...
这个简单的愚蠢事让我难过!

光标位于数据表的记录中。我如何选择该记录
(突出显示),就像我使用VBA点击记录选择器一样。
This simple stupid thing has me stumped!

The cursor is on a record in a datasheet. How do I select that record
(highlight) like I would if I clicked on the Record Selector using VBA.



感谢Allen。


" Allen Browne" <铝********* @ SeeSig.Invalid>在留言中写道

news:3f ********************** @ freenews.iinet.net.a u ...
Thanks Allen.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Runcommand acCmdSelectRecord

- Allen Browne - Microsoft MVP。西澳大利亚州珀斯。
访问用户提示 - http://allenbrowne.com/ tips.html
回复群组,而不是在mvps dot org的allenbrowne。

Barry Edmund Wright < BA ***************** @ rogers.com>在消息中写道
新闻:sX ******************* @ news04.bloor.is.net.cab le.rogers.com ...
Runcommand acCmdSelectRecord

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:sX*******************@news04.bloor.is.net.cab le.rogers.com...
这个简单的愚蠢的事情让我感到难过!

光标位于数据表的记录中。我如何选择该记录
(突出显示),就像我使用VBA点击记录选择器一样。
This simple stupid thing has me stumped!

The cursor is on a record in a datasheet. How do I select that record
(highlight) like I would if I clicked on the Record Selector using VBA.




---

来自Barry Wright的这封电子邮件已经使用AVG 6.0扫描并经过认证

无病毒。

由AVG反病毒系统检查( http://www.grisoft.com)

版本: 6.0.541 /病毒数据库:335 - 发布日期:11/14/03


---
This email from Barry Wright has been scanned using AVG 6.0 and is certified
Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.541 / Virus Database: 335 - Release Date: 11/14/03


测试看看我的电子邮件地址是什么 - 出于反垃圾邮件的原因。

" Barry Edmund Wright" < BA ***************** @ rogers.com>在消息中写道

新闻:sX ******************* @ news04.bloor.is.net.cab le.rogers.com .. 。
Testing to see what my email address looks like - for antispam reasons.

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:sX*******************@news04.bloor.is.net.cab le.rogers.com...
这个简单的愚蠢事让我难过!

光标位于数据表的记录中。如何使用VBA点击记录选择器,如何选择该记录
(突出显示)。

问候。
Barry

- -
来自Barry Wright的这封电子邮件已经使用AVG 6.0进行了扫描,并且是经过
认证的无病毒版。
由AVG反病毒系统检查( http://www.grisoft.com)
版本:6.0.541 /病毒库:335 - 发布日期:11 / 14/03
This simple stupid thing has me stumped!

The cursor is on a record in a datasheet. How do I select that record
(highlight) like I would if I clicked on the Record Selector using VBA.

Regards.
Barry
---
This email from Barry Wright has been scanned using AVG 6.0 and is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.541 / Virus Database: 335 - Release Date: 11/14/03



---

来自Barry Wright的这封电子邮件已使用AVG 6.0进行扫描并已通过认证

无病毒。

由AVG反病毒系统检查( http ://www.grisoft.com)

版本:6.0.541 /病毒库:335 - 发布日期:11/14/03


---
This email from Barry Wright has been scanned using AVG 6.0 and is certified
Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.541 / Virus Database: 335 - Release Date: 11/14/03


这篇关于如何使用VBA选择(突出显示)数据表中的记录?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

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