[AccessD] Select Exported Files from Access

[Bill Benson]

Don't you need the full path, not just "Report.pdf" ?
On Jun 3, 2015 11:55 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
>