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

Capturing Print (not Preview) Date

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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.


Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

P: n/a
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?"


Nov 13 '05 #5

P: n/a
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

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.