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.RunComman d 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]

Re: Capturing Print (not Preview) Date

On Thu, 14 Oct 2004 21:04:08 -0230, Tim Marshall
<TIMMY!@antarct ic.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.

[color=blue]
>In an A97 app I'm redeveloping, I've got a field in a table called
>TS_LAST_PRIN T 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.printo ut or a DoCmd.RunComman d 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.[/color]

[Tim Marshall]

Re: Capturing Print (not Preview) Date

Tom van Stiphout wrote:[color=blue]
>
> Ctrl+P can be captured using an AutoKeys macro.[/color]

Thank you Tom.
[color=blue]
> But sending it to the printer doesn't mean it printed. The best
> strategy is to ask the user.[/color]

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]

Re: Capturing Print (not Preview) Date

Tim Marshall <TIMMY!@antarct ic.flowerpots> wrote in message news:<cknikg$cg c$1@coranto.ucs .mun.ca>...[color=blue]
> Tom van Stiphout wrote:[color=green]
> >
> > Ctrl+P can be captured using an AutoKeys macro.[/color]
>
> Thank you Tom.
>[color=green]
> > But sending it to the printer doesn't mean it printed. The best
> > strategy is to ask the user.[/color]
>
> 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?"[/color]

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

[Tom van Stiphout]

Re: Capturing Print (not Preview) Date

On Fri, 15 Oct 2004 01:40:55 -0230, Tim Marshall
<TIMMY!@antarct ic.flowerpots> wrote:

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

-Tom.

[color=blue]
>Tom van Stiphout wrote:[color=green]
>>
>> Ctrl+P can be captured using an AutoKeys macro.[/color]
>
>Thank you Tom.
>[color=green]
>> But sending it to the printer doesn't mean it printed. The best
>> strategy is to ask the user.[/color]
>
>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?"[/color]

[Alan Webb]

Re: Capturing Print (not Preview) Date

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" <TIMMY!@antarct ic.flowerpots> wrote in message
news:ckn2dg$bvn $1@coranto.ucs. mun.ca...[color=blue]
> 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.RunComman d 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[/color]