[AccessD] Select Exported Files from Access

Stuart McLachlan stuart at lexacorp.com.pg
Wed Jun 3 23:51:48 CDT 2015


I do include the path in real code, frequently in a string which includes "currentproject.path".  

That was just an ultra-simplified example.

-- 
Stuart

On 4 Jun 2015 at 0:32, Bill Benson wrote:

> Ok, but it's rare that one would, no? I think it is best to include
> the path, but that is me. Glad to know there is a choice. On Jun 4,
> 2015 12:10 AM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:
> 
> > Only if you don't want it to go into the default directory (usually
> > My Documents)
> >
> >
> >
> > On 3 Jun 2015 at 23:58, Bill Benson wrote:
> >
> > > 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
> > > >
> > > --
> > > 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