By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

Use Access as A Document Manager

100+
P: 171
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.
May 11 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
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)

Expand|Select|Wrap|Line Numbers
  1. dim YourPath as string
  2. dim yourID as string
  3. YourPath = "C:\Clients\"
  4. YourID = dmax("ID","YourClientTable")
  5. makedir(YourPath & YourID)
  6. currentdb.execute "Insert into YourClientTable set Folder = '" & YourPath & YourID & "';"
  7.  
Make the Folder field in your client table a type Hyperlink

Should do it.
J
May 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.