FileDialog Access XP Developer

[johnqzsmith]

Much is written about the msoFileDialog problems in Access. I am confused with what I am reading.

I am using Access XP (2000) Developer version and have used the msoFileDialogSaveAs without any problem. HOWEVER, I have not created a runtime version yet. A couple of articles seem to state that there is not a problem with the runtime version with Access XP Developer (Office 2002 SP3).

I have used 10-12 instances of the msoFileDialogSaveAs in my program without any errors. Are these all going to fail when I create my runtime version? I have seen the code from Ken Getz (http://www.mvps.org/access/api/api0001.htm) and people seem to agree that it works. Alas, with developing we all like to proceed without having to go back and change what we’ve done. I have become quite comfortable with the msoFileDialog and hope that it can stay.

Can anyone help clear this up for me?

Thanks,

JQ

 

[ghudson]

I suggest that you stick with the APIs. Check this out...

Browse [Find a directory or file]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

 

[Pat Hartman]

The problem is not with using it on your development PC (as long as you have the correct license installed), the problem is distributing the application to PCs that do not have the activeX control registered or trying to use it on a PC that doesn't have the correct license.