[AccessD] RE: When is a report actually printed

David,

You opened it in design view.  If your right click
on it in the database window and go to properties,
you will see what I was talking about.

What I was proposing was a way to determine if the
report had ever been printed or previewed.  Is
that what you want to track?  Or is it just for the
current user?

I use the description property because I do not have
to open the report in design view to read it.  I can
use the document collection to read the information.
I use it for displaying a list of reports and the
report category so I can use a single form to print
all reports.  Oh, and I also store the name of the form
to open for criteria if the report needs that also.
It is really handy.

Robert

At 02:54 PM 10/8/2003 +1000, you wrote:
>Thanks Robert,
>I looked at the properties of the report, but can find no description. 
>There's a Caption.
>
>I'm not sure I follow your line of thought. How will this help me 
>determine if the user actually printed the report rather than simply 
>previewed it and just closed the preview?
>
>I'd love to see your code - it may help me towards a solution.
>
>Marty Connelly from Canada posted a possible solution with this URL
>http://www.merrioncomputing.com/Programming/index.htm
>but I haven't had time to check it thoroughly yet.
>
>Cheers
>David Ô¿Ô¬
>Brisbane
>Australia
>
>
>-----Original Message-----
>From: Robert L. Stewart [mailto:rl_stewart at highstream.net]
>Sent: Wednesday, 8 October 2003 6:21 AM
>To: accessd at databaseadvisors.com
>Cc: David Fenton
>Subject: Re: When is a report actually printed
>
>David,
>
>If you are not using an MDE you could do the following:
>
>Right-click on the report and go to properties.
>Enter No Print;No Preview in the description.
>Change the description in code on the line
>before opening it in Preview or Print mode.
>
>If you need help with the code, let me know
>and I will post it to the list.
>
>I don't think you can change this property in an MDE.
>
>Robert
>
>At 10:56 PM 10/6/2003 -0500, you wrote:
> >Date: Tue, 7 Oct 2003 09:30:06 +1000
> >From: "David Fenton" <dfe at nudgeeinternational.com>
> >Subject: [AccessD] When is a report actually printed (vs previewed
> >         only)
> >To: <accessd at databaseadvisors.com>
> >Message-ID:
> >
> ><A3218B71657C264E8EAE5A90040B351103CBE7 at phoenix.student.nudgeeinternation 
> al.com>
> >
> >Content-Type: text/plain; charset="iso-8859-1"
> >
> >Hello again,
> >I have searched archives and looked through recent newsgroups for Access
> >Reports and found only a few tips on determining if a report is printed
> >rather than just previewed. None of them seem to hit the mark I'm after.
> >
> >I found this:
> >http://ourworld.compuserve.com/homepages/attac-cg/ARptTip.htm#PREVIEW
> >but it doesn't quite suit.
> >
> >Does anyone have any u-beaut ideas on how I can tell whether a report has
> >been previewed or printed? I do not want to prevent my users from
> >printing. In the OnClose event of the report I set a 'printed' flag. But
> >one of my users correctly pointed out that previewing it is not the same
> >as printing it. She can look at the report but change her mind and NOT
> >print it. In that case she doesn't want the 'printed' flag to be set. I
> >guess she's after a Cancel button on the print preview. I am not aware of
> >any cancel methods on the print preview page. I know there is an OnPrint
> >event, but it seems to apply to sections of the report, not the entire
> >report itself.
> >
> >I could have two buttons on the form - one preview and one print, then
> >putting the flag setting into OnClick on the print button instead of the
> >report itself, but it doesn't feel robust...
> >Any ideas folks?
> >Cheers
> >David Ô¿Ô¬
> >Brisbane
> >Australia