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

Automatic Update After Printing

P: n/a
Using WinXP & AccessXP, I'd like to automatically have the records that I've
just printed in a report automatically updated to have the 'print date &
time' immediately inserted into a 'Date/Time' field in the table of all of
the 'just printed' records. The crude way would be to run an Update Query
immediately before or immediately after printing on those records in the
report, but how would I have this done automatically when hitting the
'Print" button? The problem is that I don't want any of the records that
I've ever printed to be included in the next report that I run, so I want to
exclude them from the next report based on the fact that they've already
been printed.

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


P: n/a
"Earl Anderson" <is*****@rcn.com> wrote in message
news:Uu********************@rcn.net...
Using WinXP & AccessXP, I'd like to automatically have the records that
I've just printed in a report automatically updated to have the 'print
date & time' immediately inserted into a 'Date/Time' field in the table of
all of the 'just printed' records. The crude way would be to run an
Update Query immediately before or immediately after printing on those
records in the report, but how would I have this done automatically when
hitting the 'Print" button? The problem is that I don't want any of the
records that I've ever printed to be included in the next report that I
run, so I want to exclude them from the next report based on the fact that
they've already been printed.

Thx...
Earl


That doesn't seem that crude - and basically any workable solution will be
somewhat similar - it's just a case of how many bells and whistles you want
to add to the procedure. The first thing to bear in mind is that batch
printing does not always go smoothly - paper runs out, gets stuck or mangled
in the printer, quality is unacceptable due to ink cartridge, etc.
Therefore the first thing you need to be able to do is to update the
LastPrintDate field to today's date if everything went OK - or be able to
say 'don't update the records -the printing got all screwed up'. The next
thing you might need (depending on the batch size) is to say that you got
through 326 of 400 records when it all went wrong, so you just need to print
the outstanding records.
As a solution I could imagine a form/subform screen where the subform shows
the records you are going to print. The subform is based on a query where
the records are sorted in the same order as the sorting and grouping of the
report. When you press the print button it tries to print all the records
and then asks you if it went OK and so you can decide to update the records
or not. You could also edit the subform to remove the LastPrintDate from
any records which didn't print satisfactorily so you could do a partial
re-print.
As to the actual solution, you don't say whether you are happy to write vba
code or have made any start yourself in the coding of any subs or functions.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.