Link Access to a folder to store emails etc

[Geordie2008]

Good afternoon All,

I have created an issues database (v basic) and the user would like to be able to attach "issue related" files to the particular isue so they can access them all from one place.

These could be emails, word docs, excel etc etc.

After reading through some posts on this site I thought a hyperlink to a folder (1 for each issue) might work.

So when a new issue is raised, it is given an issue number (autonumber) and I would like access to create a new folder whenever a new issue is created and then have a button to "open the folder" to either add or view what has been stored in there...

Can someone please help, point me in the right direction?

On click add new record I want a new folder to be created
On click open folder I want said folder to open and display **all files** (not just access, excel OR word, but all of them)

Thanks,
Mandy

 

[DCrake]

Simple Software Solutions

Hi Mandy

I have attached a sample demo that lists all files found in a specific folder. In this example it is the current project folder. It places these files in a listbox on the form. When the user double clicks on any file it opens up in its native software. So if it is Excel file Excel opens, same for doc files Word opens.

This will get you most of the way there. I have code for creating folder if they don't exist so if you can't manage that then let me know.

CodeMaster:

 

[Geordie2008]

Wow... This looks brilliant.... Im going to spend some time going through it all now (esp the VBA which looks quite tricky!).

Thanks so much.
Mandy

 

[Geordie2008]

"My Location" is currently pointing to an area of my C: drive.

Is it ok to change that to a shared drive that all users will have acces to?

Thanks,
M

 

[Geordie2008]

I changed it and it was quite happy.

Do you have any code that will enable me to auto create a folder using the auto number of the issue when a new issue is created.

Thanks,
Mandy

 

[GaryPanic]

I have this (thanks Dcrake) and it does exactly what you ask for
I have 1 folder per record and in this I can store pdf, word etc and open then from access etc

works a charm

 

[Geordie2008]

It is brilliant, does exactly what I am looking for, except it does not like emails. When I save an email into the folder I get a debug error:

Syntax error (missing operator) in query expression "mandy.msg"

and the debug error is on:

DoCmd.RunSQL "INSERT INTO tblFoundFiles ( FilePath , FileName, DocType ) SELECT '" & Folder & "\" & "' AS A, '" & fName & "' AS B, " & MySource & " AS C;"

Im not too hot with VBA and hence I dont understand how to adjust the VBA for this error?

Thanks,
mandy

 

[Geordie2008]

ah.... Tis working fine, I'd chosen a message with ' ' in the title and hence access was confused. Normally titled messages work great.

Thanks again,
M

 

[DCrake]

Simple Software Solutions

Glad to see that it works for you both. I have posted this in the samples database section. It's awating approval at the moment.

David: