File control and path handling

[Tim L]

I want to be able to distribute a copy of a database and to be able to store exported data in a user defineable location.

Is it possible to create directories/folders from within Access? E.g: so that after having copied the database onto their HD Access (when run) could create extra folders, such as "Backup" & Now().

Also, it should be possible for the user to redefine the path to the backup (or other) folder(s). How can a user entered path be checked for validity?

Is it possible to determine the size of a file on the HD from within Access or to estimate the size of a text file before the file is created?

Tim

 

[fuzzygeek]

Common Dialog DLL

See the following knowledge base article for using the common dialog whereby you can choose a folder or create a new folder and save a file.

http://support.microsoft.com/default.aspx?scid=kb;en-us;303066

 

[Tim L]

Thanks fuzzy,

This article explains how to use the Common Dialog API to replace the Common Dialog Box functionality that is included only with the Office 97 Developer Edition.

Also, the footnote says the article is relevant to Access 97

I'm creating an Access 2k db in Access XP but I presume that this should still work with the newer version BUT I do not have the developer edition :-(

Is there another way, or do I have to get the developer edition?

Tim

 

[fuzzygeek]

Windows API

You do not need Developer to use the common dialog. It is a windows dll (API). The code should work in 2K and XP.

 

[fuzzygeek]

Mo Info

Review the searched items on this site. There are at least 4 hyperlinks that will provide you with additional info on using the dll and ocx.

http://www.access-programmers.co.uk/forums/search.php?action=showresults&searchid=247767&sortby=lastpost&sortorder=descending

 

[Tim L]

Thanks, I'll check it out.

Tim