Problem in loop for recordset

**aman1234** · 07-09-2010, 04:59 AM

Hi guys

I am getting a problem in the loop below. It doesn't display me each person's record. Can anyone please solve my problem.

Please Login or Register  to view this content.

Thanks
Aman

**daksh1981** · 07-09-2010, 05:32 AM

Try to use absolute recordset field name instead of index number. For example rs.fields(“User Name”).

**aman1234** · 07-09-2010, 07:14 AM

Hi

I think there is no problem of field names as the code works fine but it displays the result of only one person. Suppose one person has done 10 letters and 2nd person has done 5 letters then the report will display the username,total letters and total time taken to do those letters for one person only and will not display anything for the 2nd person.

I hope anyone can help me in this.

Thanks

**Andy Pope** · 07-09-2010, 07:46 AM

Hard to tell as you have not posted all the relevant code but a guess would be that the output sheet being references as ws is not the activesheet where J is being defined.

**aman1234** · 07-09-2010, 08:54 AM

Hi

Please find below the complete code and put me in the right direction.

Please Login or Register  to view this content.

Thanks

**Andy Pope** · 07-09-2010, 08:59 AM

Is Sheet3 the active worksheet?

try using the same sheet object

Please Login or Register  to view this content.

**aman1234** · 07-09-2010, 09:33 AM

After writing ws instead of activesheet, there is no difference in the output. Again one person's record gets displayed and other users records are again not displayed.

I think the loop runs only once thats why only first person's record gets printed. Please can you read the code inside loop again and guide me in this.

**Andy Pope** · 07-09-2010, 09:37 AM

Without the data file it is impossible for use to guess what is happening.

What happens when you step through the code line by line.
What are the values of J. Are they correct.

Does the record set really return more than 1 person.
Try adding some debug.print line so you know for sure data is being missed from the worksheet

**aman1234** · 07-09-2010, 10:12 AM

When I write :

a=rs.recordcount

then it displays me the result -1.

Please Login or Register  to view this content.

**Andy Pope** · 07-09-2010, 10:18 AM

don't you need to move through the record set before the recordcount returns meaningful values.

why not for debugging simple debug.print all the information.

**aman1234** · 07-09-2010, 10:32 AM

Hi Andy

There is a problem in the loop only which displays first record only. As if i write the following code then everything works fine :

Please Login or Register  to view this content.

Thanks a lot anyway for your help.

Problem in loop for recordset

LinkBack

Thread Tools

Rate This Thread

Display

Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Re: Problem in loop for recordset

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions