save as mso dialogbox

J

Joe Garner

Hi there,

I'm trying to use the application.filedialog objects to bring up a save as
dialog box, but it turns out the microsoft in their infinite wisdom decided
not to implement this in Access.

Is there a workaround for this? I've tried using other dialog box types but
they won't let you eneter a filename that does not already exist!

What one earth was the reasoning behind this?

The reason i need the save as dialog box is that i want my database to be
able to make a new copy of itself.

Thanks for the help

cheers

Joe
 
M

Michel Walsh

Hi,

The mso reference is not checked, by default, you have to include it (ie, to check it). The
library mso is installed if you have installed Office. If you installed Access as a side product,
without Office, then, it is possible that mso is not on the PC. Probably because of that
possibility, mso is NOT checked, by default, by wisdom. You can use the API directly, as mentioned
by Dan.

Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make changes in the outlook file save as type using C# 0
Macro Code for bringing up Save As dialog box and changing file Type 0
fDialog use with form to export data 1
Dialogbox VBA 1
How to copy selected column to another page under a specifik field? 2
Always asks to "Save Changes" to Form Design in Access 2007 1
getting the File System Object to run File Save As instead of just File Save 2
Excel 2003 - Save as dialog box 1

Top