Connecting Tech Pros Worldwide Help | Site Map

Print Log problems

  #1  
Old November 13th, 2005, 10:00 AM
Chesne
Guest
 
Posts: 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

  #2  
Old November 13th, 2005, 10:00 AM
pietlinden@hotmail.com
Guest
 
Posts: n/a

re: Print Log problems


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.

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having problems accepting parameters to a function rh0dium answers 6 May 1st, 2007 11:45 PM
mysql Install Problems PowerLifter1450@gmail.com answers 1 November 1st, 2006 06:05 PM
append log file Tom answers 8 July 18th, 2005 04:05 AM
Error log empty Wayno answers 1 July 17th, 2005 02:09 AM