Use Access as A Document Manager

[iheartvba]

Hi,

I'm trying to set access up to be a document manager, what I basically want is that every time a new client is created in the client details table, a new folder is created with the name of the folder being the primary key that is allocated to the client and/or a hyperlink being created in the client details table which links to that folder.

Your Help would be greatly appreciated.

[JConsulting]

Hi,

I'm trying to set access up to be a document manager, what I basically want is that every time a new client is created in the client details table, a new folder is created with the name of the folder being the primary key that is allocated to the client and/or a hyperlink being created in the client details table which links to that folder.

Your Help would be greatly appreciated.

Hmmm, How about something like this. in the after update event of your form (assume you have a form...because tables don't have events)

dim YourPath as string
dim yourID as string
YourPath = "C:\Clients\"
YourID = dmax("ID","YourClientTable")
makedir(YourPath & YourID)
currentdb.execute "Insert into YourClientTable set Folder = '" & YourPath & YourID & "';"
 

Make the Folder field in your client table a type Hyperlink

Should do it.
J