Rabu, 28 September 2011

[MS_AccessPros] Re: Output Report to PDF

 

Thanks Brian

Giorgio

--- In MS_Access_Professionals@yahoogroups.com, "brian.rogoski" <brian.rogoski@...> wrote:
>
> **These lines set the data the are to be put into the ini file**
> bz.SetValue "OwnerPassword", "PASSWORD"' for the "owner password"
> bz.Setvalue "UserPassword", "PASSWORD"'for the "user password
> bz.SetValue "output", strPdfFileName
> bz.SetValue "showsettings", "never"
> bz.SetValue "showpdf", "no"
> bz.SetValue "confirmoverwrite", "no"
>
>
> **This line creates the ini file**
> bz.WriteSettings True
>
>
> **This line creates the PDF (by printing the access report)**
> DoCmd.OpenReport strReportName
>
> --- In MS_Access_Professionals@yahoogroups.com, giorgio_rovelli <no_reply@> wrote:
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "brian.rogoski"
> > <brian.rogoski@> wrote:
> > >
> > Brian,
> >
> > you say, "these lines specifically create the (runonce.ini)file via the
> > reference to the bzpdfc.dll file. You could output it using a text
> > stream, I suppose, but doing it this way creates it in the correct
> > directory and format."
> >
> > Which is the line the creates the runonce.ini file?
> >
> > I see bz.SetValue "output", strPdfFileName but it creates the pdf file
> >
> > You also say, "if the created date of the
> > 'ini file is more then 15 minutes, we just delete and print anyway"
> > therefore shouldn't this be the correct code:
> > If DateDiff("n", fs.GetFile(strRunOnce).DateCreated, Now) > 15 Then
> > fs.DeleteFile strRunOnce, True
> > ?
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar