rs.absoluteposition problems 
Author Message
 rs.absoluteposition problems

It seems like such a simple thing
rs.record count
rs.absoluteposition

I am using DAO (at least I thing that's what it's called i.e.
I'm not using a control

the record count is not accurate (I have 151 records it
reports 150) even after a rs.movelast

the rs.absoluteposition gives me an error (object is not
supported for this type of object

I'm at my wit's end...
Please post and email so I quit asking this question.
Thanks Jay


(402)471-5589



Tue, 26 Oct 1999 03:00:00 GMT  
 rs.absoluteposition problems

Try connecing to the table as a TABLE, not snapshot. You must carry out
.movelast before the recordcount and then you should be in business.
 ----


Quote:
>It seems like such a simple thing
>rs.record count
>rs.absoluteposition

>I am using DAO (at least I thing that's what it's called i.e.
>I'm not using a control

>the record count is not accurate (I have 151 records it
>reports 150) even after a rs.movelast

>the rs.absoluteposition gives me an error (object is not
>supported for this type of object

>I'm at my wit's end...
>Please post and email so I quit asking this question.
>Thanks Jay


>(402)471-5589



Wed, 27 Oct 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Another Newbie Problem: AbsolutePosition = -1

2. adodc.caption absoluteposition problem

3. RS.MoveLast and RS.RecordCount strategy

4. trouble rs.edit and rs.addnew and cursors

5. rs.close or set rs = nothing

6. RS-232 to RS-422

7. RS.MovePrevious / RS.Move(-2) doesn't work

8. excellent jobs for vb prog'rs/devl'rs

9. rs = nothing (vs.) rs.close

10. rs!field vs. rs.fields(fieldname).value

11. excellent jobs for vb prog'rs/devl'rs

12. excellent jobs for vb prog'rs/devl'rs

 

 
Powered by phpBB® Forum Software