Do...Loop Question

[MarkL]

I want to programatically loop through all the rows in my database when a user clicks on a pushbutton.

However I get an error:
"Object variable or with block variable not set"

Here's what I am doing:

do while not adoTargets.recordset.eof
...
... processing code here
...
loop

What am I doing wrong ? I want it to loop until EOF.

[Sam Finch]

Have you definately gone adoTargets.recordset.movefirst before the loop and make sure your recordset object is attatched to a database recordset, I still use DAO myself so i'm not sure.

Hope this helps

[MarkL]

Here's what my code looks like now:

--------------------------------------------
adoTargets.recordset.movefirst

do while not adoTargets.recordset.EOF
...
... Processing code here
...
loop

--------------------------------------------
I am now getting an error on the first stmt:
adoTargets.recordset.movefirst

I get the same error:

"Object variable or with block not set"

Hummmm.... suggestions ? anyone please??

[netSurfer]

Did you set the recordset anywhere? You have to set adoTargets to something. I'm not sure how it works with ADO exactly (whether you're using a physical control) but

set adoTarget = dbDatabase.OpenRecordset(Table)

might work with Table being the name of your table and dbDatabase being your database. If it's a physical control - you need to do this:

adoTarget.Recordsource = "Select * from table"

or something like that.

[MarkL]

Within the ADO data control I set the recordsource to:
SELECT * from Targets

(I have double checked to be sure that the table name is spelled correctly.)

[mishra_suresh]

Chk 4 ur connection, ur recordset is not opening at all

[dee-u]

Did you know the date of that thread?

[mishra_suresh]

Yes I did but then I also didn't C the satisfactory reply 2 last post n I thought that my post might help in future if required. If the prob is already solved I think this post should not hav come. I'd advice stop pointing out this kind of logical things like kids.
Thanx