ACCESS FEED: Re: [MS_AccessPros] Re: How to know if a report has printed

Senin, 19 September 2011

Re: [MS_AccessPros] Re: How to know if a report has printed

Adam,

I have a question. If you disable the print, then when will they be able to print again? I agree with George that sometimes the users need to take responsibility for themselves. We created a process in a database that had a label on the form or a text box that changed to say the last time the button was clicked. this would at least let the users know when it was clicked last. They could manage it on their own from there.

Jim Wagner
________________________________

________________________________
From: AdamF <runuphillracing@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, September 19, 2011 3:33 PM
Subject: [MS_AccessPros] Re: How to know if a report has printed

Duane,

I didn't try to code. I don't have a field, but could easily add one. I was hoping that was something I could do when they actually printed it. Lacking that, I didn't see the point of adding the field or trying the code.

Lacking that, would it be possible to disable the Print option from the pull-down menus, create my own custom print icon (I know I can hide the standard print icon) that would initiate code to check to see if the batch has been printed, print the report and mark the batch as being printed if not, and send a message if it has been marked? I know how to refer to a Macro from a custom icon. I don't know how to point it to VB code though.

Adam

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> Adam,
> Do you have any field in your table that identifies if a record has been printed?
> Did you at least try the code to see if the MsgBox matches your expectation of printing vs previewing?
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: runuphillracing@...
> Date: Mon, 19 Sep 2011 20:42:38 +0000
> Subject: [MS_AccessPros] Re: How to know if a report has printed
>
>
>
>
>
>
> Duane,
>
> Where would I put this code? There is no "OnPrint" for reports.
>
> The way it's done now, the report is brought up in Preview mode so they can review the labels before printing (that's how they want it now). Then they print from there (using Ctrl-P or the printer icon). There's nothing in the system that would prevent them from printing repeated times from the Preview mode until they close the report. Once closed, they can't bring up those labels again.
>
> Adam
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> >
> >
> > I generally recommend prompting the user with a msgbox following the printing like:
> >
> > If msgBox("Did these labels successfully print?",vbYesNo+vbQuestion,"Labels Printed") = vbYes then
> > currentdb.Execute "UPDATE ... ", dbFailOnError
> > End If
> >
> > FredG posted something a number of years ago that might work. You would need to replace the MsgBox with some type of update query.
> >
> > Option Compare Database
> > Option Explicit
> > Dim intPreview As Integer
> >
> > Private Sub Report_Activate()
> > intPreview = -1 ' If [Pages] is not used
> > ' intPreview = -2 ' If [Pages] used
> > End Sub
> >
> > Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
> > If intPreview >= 0 Then ' If [Pages] not used
> > ' If intPreview >= 1 Then ' If [Pages] used
> > MsgBox "Gone Printing"
> > End If
> > intPreview = intPreview + 1
> > End Sub
> >
> > Duane Hookom
> >
> >
> >
> >
> > To: MS_Access_Professionals@yahoogroups.com
> > From: runuphillracing@
> > Date: Mon, 19 Sep 2011 19:49:50 +0000
> > Subject: [MS_AccessPros] Re: How to know if a report has printed
> >
> >
> >
> >
> >
> >
> > No.
> >
> > Adam
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "luvmymelody" <luvmymelody@> wrote:
> > >
> > >
> > > Adam
> > >
> > > Did you ever find the solution to your question?
> > >
> > > Jim Wagner
> > >
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "AdamF" <runuphillracing@> wrote:
> > > >
> > > > Is there a way to mark a report when it prints (at least when sent to a printer rather than just preview) so that it doesn't get reprinted?
> > > >
> > > > Printing bar code labels. Each label has a unique number, so I don't want them to print it twice. I know I can mark it in the code I use to print the labels if it were printed directly from that code. However, they want it to display in preview mode, then to print from there.
> > > >
> > > > Adam
> > > > Denver, CO
> > > >
> > >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]