[AccessD] Select Exported Files from Access

Stuart McLachlan stuart at lexacorp.com.pg
Wed Jun 3 22:54:43 CDT 2015


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
> 




More information about the AccessD mailing list