Selasa, 27 September 2011

[MS_AccessPros] Re: Output Report to PDF

 

**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