Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access 2007 VBA Do While Loop Repeats Same Output
Skip and Randy, Thanks so much! I had to change it a little, but it worked! [thumbsup] I know this seems like a "duh", but I could not see the forest for the trees. :-) Thanks again! You guys are the best! This is what I ended up with: Do While Not rst.EOF strRptName =...- DataHog2
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access 2007 VBA Do While Loop Repeats Same Output
Randy, I appreciate your time on this, but I still don't get it. The value in strRptName is supposed to be coming from the table/recordset, so rst.MoveNext is supposed to send the loop to the next record in the table. The report name will be different in that record. I don't understand...- DataHog2
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access 2007 VBA Do While Loop Repeats Same Output
I have a control table with various reports that I want to output to PDF. In Access 2007, I wrote a Do While Loop to go through the local table (30 records) and print out each report. The problem is that it just prints out the same report 30 times. Can anyone tell me what is wrong with this...- DataHog2
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
