File Dialog causes crash

[dynamictiger]

I have been playing around with a few Access books on various ways to relink my tables on startup. The technique I liked uses Access 2002 Office Object 10.0 library FileDialog. Sagekey Runtime lists Office Object 10.0 library as being distributable.

However, whenever i try and run this with a runtime switch (not packaged yet) the application crashes on a runtime error. I thought it was something I did so I tried the books sample chapter mdb as well and got the same result.

I tried staging message boxes through the code and the crash seems to occur in the code

set objFileDialog=Application.FileDialog(msoFileDialogOpen)

With objFileDialog

It does not move past this point as I have a message box immediately after this section that is not poping up.

 

[Drevlin]

Whenever I've used file dialog I've never set it as an object.

Try it this way:

with Application.FileDialog(msoFileDialogOpen)

It should just open the dialog and then returns a selection set of the files (or single file if you don't have .AllowMultiSelect set to True)

Let me know if this doesn't work.

 

[dynamictiger]

According to Microsoft the filedialog methods are not supported in Runtime only in Full Retail product, they just hadn't told anyone.