Capturing Print (not Preview) Date

[Tim Marshall]

In an A97 app I'm redeveloping, I've got a field in a table called
TS_LAST_PRINT which indicates the last date this record was printed.
That is a hard copy was produced, not an on screen print preview.

I'm sure I can capture this in code in a proc which does the
docmd.printout or a DoCmd.RunCommand acCmdPrint.

But what I'm worried about are more savvy users who just go Ctrl-P.

Any suggestions on how to capture this keyboard combination so I can
populate TS_LAST_PRINT?

Thanks in advance for any suggestions.
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Tom van Stiphout]

On Thu, 14 Oct 2004 21:04:08 -0230, Tim Marshall
<TI****@antarctic.flowerpots> wrote:

Ctrl+P can be captured using an AutoKeys macro.
But sending it to the printer doesn't mean it printed. The best
strategy is to ask the user.

-Tom.

In an A97 app I'm redeveloping, I've got a field in a table called
TS_LAST_PRINT which indicates the last date this record was printed.
That is a hard copy was produced, not an on screen print preview.

I'm sure I can capture this in code in a proc which does the
docmd.printout or a DoCmd.RunCommand acCmdPrint.

But what I'm worried about are more savvy users who just go Ctrl-P.

Any suggestions on how to capture this keyboard combination so I can
populate TS_LAST_PRINT?

Thanks in advance for any suggestions.

[Tim Marshall]

Tom van Stiphout wrote:

Ctrl+P can be captured using an AutoKeys macro.
Thank you Tom.
But sending it to the printer doesn't mean it printed. The best
strategy is to ask the user.

Crumbs! You are right - I suppose they could cancel the operation.
What do you mean by asking the user? Is it as simple as you make it
sound? 8) I mean, simply a msgbox asking "Do you want to record this
as a print job sent?"
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Pieter Linden]

Tim Marshall <TI****@antarctic.flowerpots> wrote in message news:<ck**********@coranto.ucs.mun.ca>...

Tom van Stiphout wrote:

Ctrl+P can be captured using an AutoKeys macro.

Thank you Tom.

But sending it to the printer doesn't mean it printed. The best
strategy is to ask the user.

Crumbs! You are right - I suppose they could cancel the operation.
What do you mean by asking the user? Is it as simple as you make it
sound? 8) I mean, simply a msgbox asking "Do you want to record this
as a print job sent?"

And then asking if the job printed OK. Then go ahead and update whatever.

[Tom van Stiphout]

On Fri, 15 Oct 2004 01:40:55 -0230, Tim Marshall
<TI****@antarctic.flowerpots> wrote:

Sure, a MsgBox would work. I've also seen implementations with a
checkbox on the main form.

-Tom.

Tom van Stiphout wrote:

Ctrl+P can be captured using an AutoKeys macro.

Thank you Tom.

But sending it to the printer doesn't mean it printed. The best
strategy is to ask the user.

Crumbs! You are right - I suppose they could cancel the operation.
What do you mean by asking the user? Is it as simple as you make it
sound? 8) I mean, simply a msgbox asking "Do you want to record this
as a print job sent?"

[Alan Webb]

Tim,
On my own Windows domain I've got the system log telling me a job was
printed on a printer. It's in the logs on my server. Also, I remember a
couple cases where a client had WinNT Server sending a NET SEND message from
the server saying a job had printed. One would think there was a way to use
api's or some such to trap the logged event or NET SEND message and do what
you need in your database.

"Tim Marshall" <TI****@antarctic.flowerpots> wrote in message
news:ck**********@coranto.ucs.mun.ca...

In an A97 app I'm redeveloping, I've got a field in a table called
TS_LAST_PRINT which indicates the last date this record was printed. That
is a hard copy was produced, not an on screen print preview.

I'm sure I can capture this in code in a proc which does the
docmd.printout or a DoCmd.RunCommand acCmdPrint.

But what I'm worried about are more savvy users who just go Ctrl-P.

Any suggestions on how to capture this keyboard combination so I can
populate TS_LAST_PRINT?

Thanks in advance for any suggestions.
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto