By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,153 Members | 2,581 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,153 IT Pros & Developers. It's quick & easy.

Print Log problems

P: n/a
I have developed a print log table etc which works well when I print a
single report. However, when I print a report which contains a number
of pages to a number of different receipents I can only log the name of
the first receipent. Is there a way to log each receipent from a single
report? Below is the code which I am using -

If Flag = 2 Then

rst.AddNew
rst!ReportName = "Letter to Convenor "
rst!PrintDate = Now
rst!Receipent = Reports!rLettertoGroupConvenor!FirstName & " " &
Reports!rLettertoGroupConvenor!Surname
rst.Update
Flag = 0
End If

TIA - Ray

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If you filtered your report from an unbound form, then you could just
create an append query with the same form using the same criteria.

If you really wanted ugly, you could loop through the recipients
recordset and append those, but I wouldn't recommend it. Use SQL
instead. Performance when writing record-at-a-time inserts is
absolutely dire.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.