Application.FileDialog unavailable in Access runtime

[Daniel Malcolm]

I am using the XP Office Developer Packaging Wizard to distribute an Access
XP database (2000 format) as a standalone application with the Access
runtime.

However, one of the functions in the database is not running correctly
when the database is running in the Access RunTime. I use a VBA function to
open the select folder dialog window. This runs fine in Access itself, but
results in an error when running with Access runtime.

The code is as follows:

Dim objFD As Office.FileDialog
Set objFD = Application.FileDialog(msoFileDialogFolderPicker)

The error message given by Access runtime is:

Error -2147467259 Method 'FileDialog' of object '_Application' failed.

I'm pretty sure that the reference to the Office10 and Access libraries are
intact as I can access other properties/methods of Application object
without problems, e.g. :
MsgBox Application.Name

Is it possible that file / folder select dialogues are unavailable in the
Access runtime?

Thanks in advance for any suggestions

Daniel

[Douglas J. Steele]

Don't know for sure.

However, it's not that difficult to make the API calls directly.

Check out the API section of Dev Ashish's "The Access Web"
http://www.mvps.org/access/

The File Open/File Save dialog is the first entry, while the Folder Browser
is the second.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele

"Daniel Malcolm" <dan...@holdonthespam.mfusion.co.uk> wrote in message
news:ecEP##A4BHA.2328@tkmsftngp02...