Re: ADO vs. Progress Bar

> Yes, I'm using an ADO control on my form("MSADODC.OCX") which hasn't the
> event handler you mentioned "FetchProgress".

FetchProgress is an event of Recordset not the ADO control.

> So, what do you mean by a recordset object, and how can I put it on the
form
> to show its event on the procedures list in code window?
> Please, give a complete example.

I cannot. I do not use the ADO control.
On researching the ADO control it does not seem as if the control exposes
the internal Recordset.
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconusingadodatacontrol.asp
and page down to the bottom
where it talks about "ADO Data Control Events"

Notice that various "ADO Data Control Events" are fired by changes to the
internal Recordset properties and/or Recordset events.

Given that you cannot control the internal Recordset, you best bet is use a
Server-side cursor, set the cache size to something like 64, 128, 256 and
make sure it is not a forward only cursor.

Stephen Howe


.

Relevant Pages

  • Re: Select query with parameters
    ... I can use data grid control if it will be better for my situtaion. ... When you Open a recordset you pass an SQL query statement as a string. ...
    (microsoft.public.vb.database.ado)
  • Re: Me! vs Me. (was temporarily Re: !fidlname vs .controlname)
    ... .controlname is to refer to a control (and if it is not on the form, then the recordset will be searched) ... change the NAME of another control on your form --> Test whose ControlSource is something else and is filled out ... In this case, however, the bang and the dot can be interchanged. ...
    (microsoft.public.access.formscoding)
  • Re: Reference forms and fields with variables
    ... There are so many ambiguities here, that it may not really help to follow ... If Field2 is a field in the underlying recordset, ... but the reference is unstable. ... LinkChildFields property of a subform is NOT represented by a control in the ...
    (microsoft.public.access.formscoding)
  • Re: DataGrid not showing programmatic changes
    ... It's been awhile since I've used the DataEnvironment... ... The DataGrid is usually bound to a Data control which in turn ... rsCashbook is a recordset of that Connection with a source of SELECT * FROM ...
    (microsoft.public.vb.general.discussion)
  • Re: Microsoft Document 210239 returns Error 461
    ... One possibility is that the active control is a control type that does not ... Another possibility is that the recordset variable is defaulting to an ADODB ... > Dim RS As Recordset ... ' Find using Numeric data type key value? ...
    (microsoft.public.access.formscoding)