-
Hi,
I am trying to display the status of a recordset whilst it is processing data in a progressbar control. I do not know the property of the of the recordset to use. Any help would be much appreciated. Thanks
PS.Progressbar1.value = rsData. 'Do not know property
Albert
-
if you are using DAO
ProgressBar1.Value = rsData.PercentPosition
if you are using ADO you'll need to use
'size the progressbar first
rstdata.movelast
ProgressBar1.max = rstData.RecordCount
rstdata.movefirst
'then use this within your loop
rsData.AbsolutePosition