Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2005

Tip: Looking for answers? Try searching our database.

msoFileDialogSaveAs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
regarrels - 18 Feb 2005 18:29 GMT
I have AccessXP with ServicePack3 installed.  I have referenced  the
Microsoft Office 10.0 Object Library.  I can access the FileDialogOpen and
FileDialogFilePicker but it refuses to let me access FileDialogSaveAs.  Any
help would be appreciated.
Dirk Goldgar - 18 Feb 2005 18:59 GMT
> I have AccessXP with ServicePack3 installed.  I have referenced  the
> Microsoft Office 10.0 Object Library.  I can access the
> FileDialogOpen and FileDialogFilePicker but it refuses to let me
> access FileDialogSaveAs.  Any help would be appreciated.

The SaveAs dialog isn't supported for Microsoft Access.  If you want to
bring that one up, you have to call the Windows API yourself.  See the
code posted at

   www.mvps.org/access/api/api0001.htm

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

regarrels - 18 Feb 2005 20:59 GMT
> > I have AccessXP with ServicePack3 installed.  I have referenced  the
> > Microsoft Office 10.0 Object Library.  I can access the
[quoted text clipped - 6 lines]
>
>     www.mvps.org/access/api/api0001.htm

Bob Garrels
Douglas J. Steele - 18 Feb 2005 21:32 GMT
>> > I have AccessXP with ServicePack3 installed.  I have referenced  the
>> > Microsoft Office 10.0 Object Library.  I can access the
[quoted text clipped - 12 lines]
> using Windows API.
> Thanks for the info.

I see nothing in that KB article that talks about FileDialogSaveAs

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

regarrels - 18 Feb 2005 22:45 GMT
> >> > I have AccessXP with ServicePack3 installed.  I have referenced  the
> >> > Microsoft Office 10.0 Object Library.  I can access the
[quoted text clipped - 14 lines]
>
> I see nothing in that KB article that talks about FileDialogSaveAs

It indicated that the SaveAs file dialog box was available directly within
the Office 10.0 object library and since the KB 279508 article also referred
to the Office 10.0 object library I assumed too much.  Sorry.
Dirk Goldgar - 18 Feb 2005 21:33 GMT
>> You are abviously right, however, in KB article 279508 Microsoft
>> says that the AccessXP version now allows direct access to that
>> particular dialog box withbout using Windows API.  Thanks for the
>> info.

Other dialogs are available by way of the FileDialog object, but not the
Save As dialog.  That is true for Access, but not for other Office
programs.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.