Connecting Tech Pros Worldwide Help | Site Map

Print Log problems

Chesne
Guest
 
Posts: n/a
#1: Nov 13 '05
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

pietlinden@hotmail.com
Guest
 
Posts: n/a
#2: Nov 13 '05

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 Microsoft Access / VBA bytes