dbTalk Databases Forums  

Default Database Directory not used for RTF and PDF exports

comp.databases.ms-access comp.databases.ms-access


Discuss Default Database Directory not used for RTF and PDF exports in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tony
 
Posts: n/a

Default Default Database Directory not used for RTF and PDF exports - 01-21-2008 , 08:27 AM






I am running Access 2007 SP1 under Windows XP home.

I have configured the Default Database Folder for Access using
Office / Access Options / Popular to a folder specifically set up to
receive reports.

I have also configured the Quick Access Toolbar to contain icons for
'Export To RTF File' and 'PDF'.

When I open a report from within Access and select either the QAT RTF
or PDF icon, the default directory shown in the resulting file dialog
box is 'My Documents'.

I then tried displaying the results of Application.GetOption("Default
Database Directory") using VBA code immediately before opening the
report. This successfully displayed the specially-created reports
folder, but the RTF and PDF files still defaulted to 'My Documents'.

I have also tried using Application.SetOption "Default Database
Directory", "report folder..." before opening the report. The RTF or
PDF default directory remained at 'My Documents'.

Can anybody please advise how I can set the default directory for RTF
and PDF output in Acces 2007 from within VBA code.

Note: My Access 2007 database has been converted from Access 2003.
In Access 2003 I successfully used the Application.SetOption "Default
Database Directory" approach to control the destination folder.

Thanks, Tony.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.