Automatic Folder Creation

[MG101]

Hi,

I currently have a database where users input new parts into a database using a part form. When they put in the part type, a tracking number is automatically generated. I would like a folder to be created for each part where we can store pictures and a report. How would i have it create a report to a certain area using the tracking number as the folder name? I also want to be able to upload pictures and eventually save the report in there but creating the folder is the first step!

Any help or suggestions is greatly appreciated. Thanks!

 

[Galaxiom]

Take a look at the methods of the FileSystemObject.

 

[MG101]

Hi Galaxiom,

I did try using that with some forums i found but I couldnt quite figure out how to do it. :/

 

[pr2-eugin]

Is it not simply MkDir ?

Dim PathToSave As String
[COLOR=Green]' the path you already have, append the special Folder at the end.. [/COLOR]
PathToSave = "C:\somewhere\" & yourSpecialName & "\
MkDir PathToSave

 

[MG101]

I havent tried that yet but It seems like it would work. Is it possible to code it to automatically fill in a field on my form with the hyperlink to the folder after it creates it? I already have a hyperlink field so if it could just put in the location of the oflder as text it should automatically turn it into a hyper link.

Thanks!

 

[pr2-eugin]

Yes, you can code it all.. The above is more of a pseudo code.. You need to expand on it.. Post back if you are stuck..

 

[gemma-the-husky]

i suspect you might struggle to hyperlink to a folder, as a folder probalably does not have a default application.

possibly easier to a create an info file (say a .txt file), and hyperlink to that.

 

[MG101]

Hi All,

Are either of you good at really good at coding? Im having a bigger issue with another automation that Ive had some help coding on. here is the link. http://www.access-programmers.co.uk/forums/showthread.php?t=247405 If you would like to look at my last few posts to see the trouble im having and maybe help me figure it out I'd be very appreciative! Theyre are on the second page. Thanks for any help or suggestions