[AccessD] Select Exported Files from Access

David McAfee davidmcafee at gmail.com
Thu Jun 4 12:02:59 CDT 2015


In 2007, i couldn't get it to work with acFormatPDF.

I had to use the example below that I found online (ShowPdf is a boolean
that you can toggle to open the PDFs as they are created):

DoCmd.OutputTo acOutputReport, reportName, "PDFFormat(*.pdf)", (Path &
FileName), ShowPdf, "", 0


As for why I am doing it...

I started a new job with a non-profit company last year.
I felt like I was thrown back into 1999.

>From Working with MVC C# FE & SQL BE at my last job  to working with Excel
files being exported and passed around, edited and re-imported in to Access
databases.
I've almost forgotten how to interact with .mdbs as my last 15 years dealt
mainly with ADPs when working with Access.

I am slowly trying to automate most tasks, but change is not well received
here.

Most feel like I am trying to take their jobs away, so I have to do many
things in baby steps, only automating small portions of the task until they
"get it" then I automate more of the task.

I am slowly making progress with their trust of the automation.

It's funny, yesterday I was asked to accompany my boss over at another
location to discuss "issues" with the division director.
My latest automated report was missing 18 records that the employee had
manually done.
I quickly found that 14 were due to the user using a different date range,
3 should not have been on the manual report and 1 was due to transposed
numbers by the user (or someone that passed them the information).

The director now trusts the automated report. :)



On Wed, Jun 3, 2015 at 8:54 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> With recent versions of Access (possibly 2007, definitely 2010 on),
> ExportToPDF is built in:
>
> Docmd.OutputTo acOutputReport,"rptReport",acFormatPDF,"Report.pdf"
>
> --
> Stuart
>
> On 3 Jun 2015 at 20:34, Rocky Smolin wrote:
>
> > I'd like to know how you're making the PDFs from VBA.  I had an app
> > once years ago that used a 3rd party but it's unstable.  No immediate
> > need, but that would be a really useful thing.
> >
> > I tell my clients who want a pdf to install PrimoPDF and ctrl-P from
> > the preview and select Primo as their printer.  So far, that seems to
> > satisfy everyone.
> >
> > TIA
> >
> > Rocky
> >
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of David McAfee Sent: Wednesday, June 03, 2015 5:30 PM To: Access
> > Developers discussion and problem solving Subject: [AccessD] Select
> > Exported Files from Access
> >
> > I have some VBA that loops through a recordset and exports some
> > reports as PDFs. When the process is done, I open the folder to
> > display the files, using the following:
> >
> > Application.FollowHyperlink [Path]
> >
> > I'd like to be able to select the files that were exported, to make it
> > easier for the user to see.
> >
> > I Know they can sort the folder by date, I'm just wondering if it's
> > possible to select the files.
> >
> > Thanks,
> > David
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list