By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,099 Members | 2,156 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,099 IT Pros & Developers. It's quick & easy.

How do I select (highlight) a record in a datasheet using VBA?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
19 Replies


P: n/a
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...
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.

Nov 12 '05 #2

P: n/a
Thanks Allen.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
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...
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.


---
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
Nov 12 '05 #3

P: n/a
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...
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

---
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
Nov 12 '05 #4

P: n/a
Let's try this again!

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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
Nov 12 '05 #5

P: n/a
I want to stop spam: I want my return address to be:
ba*****************@NOSPAMrogers.com

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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
Nov 12 '05 #6

P: n/a
Test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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
Nov 12 '05 #7

P: n/a
rkc

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:B9****************@news04.bloor.is.net.cable. rogers.com...
I want to stop spam: I want my return address to be:
ba*****************@NOSPAMrogers.com


Outlook Express right?

Tools - Accounts - News - Properties - Email Address


Nov 12 '05 #8

P: n/a
On Thu, 20 Nov 2003 14:25:37 GMT in comp.databases.ms-access, "Barry
Edmund Wright" <ba*****************@rogers.com> wrote:
I want to stop spam: I want my return address to be:
ba*****************@NOSPAMrogers.com


Too late Barry, your address has been posted, harvested and put into a
dozen or so mailing lists, this happened the very first time you
posted it. Expect some spam soon, it won't stop for years.

As you use OE, you'll feel right at home using Mozilla Thunderbird
(http://www.mozilla.org/products/thunderbird/), which has better spam
filtering, bit draconian at first but as 99% of my mail is spam it
works for me. I'd suggest moving junk to a junk folder at first until
it learns that some of your friends aren't junk senders (yes, that's
right, it learns, oh and it puts some of your friends emails into junk
as well until it does).

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #9

P: n/a
Test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03
Nov 12 '05 #10

P: n/a
Test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03
Nov 12 '05 #11

P: n/a
Test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03
Nov 12 '05 #12

P: n/a
Test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03
Nov 12 '05 #13

P: n/a
test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03
Nov 12 '05 #14

P: n/a
Test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03
Nov 12 '05 #15

P: n/a
Test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:B9****************@news04.bloor.is.net.cable. rogers.com...
I want to stop spam: I want my return address to be:
ba*****************@NOSPAMrogers.com

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03
Nov 12 '05 #16

P: n/a
This is what groups like alt.test are for.

And how many times do you have to test?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:dk*****************@news04.bloor.is.net.cable .rogers.com...
Test
"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03

Nov 12 '05 #17

P: n/a
Test

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03
Nov 12 '05 #18

P: n/a
Barry,

Making progress yet ?

Arno R

"Barry Edmund Wright" <ba*****************@rogers.com> schreef in bericht
news:5L******************@news04.bloor.is.net.cabl e.rogers.com...
Test

"Barry Edmund Wright" <ba*****************@rogers.com> wrote in message
news:r0******************@news04.bloor.is.net.cabl e.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...
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

---
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

---
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.543 / Virus Database: 337 - Release Date: 11/21/03

Nov 12 '05 #19

P: n/a
On Sun, 23 Nov 2003 19:19:29 GMT in comp.databases.ms-access, "Barry
Edmund Wright" <ba*****************@rogers.com> wrote:
Test


Failed: alt.test thataway --->

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #20

This discussion thread is closed

Replies have been disabled for this discussion.