Home > Archive > Visual Basic > June 2006 > Current Record
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi,
How can I display the current record info(Record X of XXX) in a ADODC
control? Is it possible?
Greatly appreciate your suggestions and feed back.
Struggling to teach myself.
KPLG
| |
|
|
"PG" <PG@discussions.microsoft.com> wrote in message
news:72E02D00-B565-4497-B5A2-446B9B92ACBE@microsoft.com...
> Hi,
>
> How can I display the current record info(Record X of XXX) in a ADODC
> control? Is it possible?
Maybe this? Untested. I never use data controls or data-binding.
Dim RecordInfo As String
RecordInfo = "Record " & Adodc1.Recordset.AbsolutePosition & " of " &
Adodc1.Recordset.RecordCount
Look up those properties in VB's Help for more information. There are
caveats to RecordCount, but I have no idea if they come into play with the
ADO Data Control.
If that doesn't work, you could keep track of it yourself, which might even
be better (check out the MoveComplete and WillMove events).
--
Mike
Microsoft MVP Visual Basic
| |
|
| I tried exactly the same way and solved my problem. Thanks for your
assistance any way.
KPLG
"MikeD" wrote:
>
> "PG" <PG@discussions.microsoft.com> wrote in message
> news:72E02D00-B565-4497-B5A2-446B9B92ACBE@microsoft.com...
>
>
> Maybe this? Untested. I never use data controls or data-binding.
>
> Dim RecordInfo As String
> RecordInfo = "Record " & Adodc1.Recordset.AbsolutePosition & " of " &
> Adodc1.Recordset.RecordCount
>
> Look up those properties in VB's Help for more information. There are
> caveats to RecordCount, but I have no idea if they come into play with the
> ADO Data Control.
>
> If that doesn't work, you could keep track of it yourself, which might even
> be better (check out the MoveComplete and WillMove events).
>
>
> --
> Mike
> Microsoft MVP Visual Basic
>
>
|
|
|
|
|