PrintOut and PrintPreview show only first record when printed using ADO and VBA

  • Thread starter Thread starter khvatov
  • Start date Start date
K

khvatov

Hi,
I'm trying to print a batch of forms based on the records I read from
the db table.
I have my recordset and fields are filled with each iteration in excel
spreadsheet
Debug.Print indicates that form values do change, but when I print or
display printpreview through the code, the only first record shows when
I loop through the records.
What am I missing here?

I am using Excel 2003 in case it matters.
Thanks.
Alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

print command from command button in userform causes double chart 5
Using VBA to automate printing with mail merge 1
ADO help: Only get first 255 characters of field... 2
CopyFromRecordset with Filtered ADO recordset 2
Prints OK but PrintPreview Shows Only a Blanik Page 2
Print contents of sub folders 1
Problem creating PivotTable from ADO recordset using VBA 0
Macro to select, set, and print 12

Back
Top