PDA

View Full Version : Count selected Records



johnny
12-12-2008, 12:00 PM
Hi,

I have a sub form in datasheetview.
I need to count the number of records selected in the datasheet.
I know its a basic thing but still I dont know.
:help me please.

OBP
12-13-2008, 05:05 AM
I am not sure what you mean by "Selected".
Do you mean Highlighted for Selection as in Deleting or copying etc.

johnny
12-15-2008, 11:01 AM
Yes. You're right. "Highlighted"
I need to count it before copying.

OBP
12-16-2008, 04:49 AM
This is quite a tricky one, have a look at this MS Article

http://support.microsoft.com/kb/294202

and this practical application

http://www.mvps.org/access/forms/frm0033.htm

johnny
12-16-2008, 09:51 AM
Thanks a lot for the article.
I was searching for .SelHeight and .SelWidth
This helped a lot.......
thanks once again