adding hyperlinks to a table....

[M G Henry]

I am working on a new database and part of the requirements will be to
be able to take existing documents that are in existing folders and add
the path to a field that is a hyperlink field called: foundin
in the table named: document in the form of a hyperlink...

I am trying to come up with an easy way to be able to search the drives
( similar to windows explorer ) and come up with a path, and then
transfer that path into a field on a form ( and of course the linked
table) for each of the documents....

I would like to have something that is user friendly... any ideas ??

 

[Daniel]

You basically need to use a file dialog. Take a look at
http://www.mvps.org/access/api/api0001.htm

For a working example put together I would suggest taking a look at the
Album Sample database which can be found at

www.cardaconsultants.com/en/samples.html

The import function, to import images, does exactly this.

Daniel

 

[M G Henry]

another nice feature would be to have the ability for a data string
that the database will generate ( similar to a catalog number ) be
allowed to be used to rename the file name from whatever the 15 or so
people writing documents would name them, to a number that the database
already assigns ( that part is working fine now ) and then move the
renamed files to specific directories given the logic that would be
built into the program.

just would need to know how to go about renaming... but with a auto
generated name ... if possible.

 

[M G Henry]

Daniel, the example of the numbering is as follows :

 

[M G Henry]

Daniel,

The example of the numbering is as follows:

there are 3 sets of 3 separate 3 digit numbers, that are concantenated
togeter to form a 9 digit number.

The first 3 digit number represents one of 21 current divisions some
examples are:

121 - Accounts Payable
122 - Accounts Recievable
these are fixed numbers.

The second 3 digit number represents one of 10 current Document types
some examples are
200 - Procedure
300 - Template
these also are fixed numbers.

The third 3 digit number represents an autonumber that is put in when
the first two sets of 3 numbers combine. This number is a primary key.
some examples of how this would look in the final concatenated number
would be

121-200-001 would be the first accounts payable procedure document
121-200-002 would be the second accounts payabel procedure document,
etc.....

This concantenated number would be stored as docnum,

Ideally I would like to read the value of docnum, and use it to move
and rename the document and save it on the g drive in the appropriate
folder...

for example, the path would be
"G:\Documents\Accounts Payable\121-200-001.doc" for a word document,
..xls for an excel spreadsheet, etc....

this way people could create documents on whatever drive they are
working on, but a copy of the approved form would be saved in a folder
and access to that folder would be limited by groups to only certain
people.

Thanks for the help Daniel

 

[Daniel]

The concept shouldn't be too complicated. However, for the coding aspect on
what will you base the document name? Let me ask the question differently.
I grasp your numbering system. That part is fine. What I'm trying to
understand is how do you want your code to identify what type of ducument it
is currently renaming.

Let say your user creates a document and named it AccntTplt.doc and then
goes and enters it into your db. Based on what will I know what to rename
it too? Hoe can I programmitically identify if its 121 - Accounts Payable
or 122 - Accounts Recievable?

or am is this going to be identified in a field or series of
listboxes/comboxes on the form? Not that I'm looking to complicate things
further, but are all these docs going to be put in the same directory or are
there going to be directories for Accounts Payable and another Accounts
Recievable with sub-directories for each document type?

Given me a few more details and will be able to create the detailed code.

Daniel

 

[M G Henry]

The concept shouldn't be too complicated. However, for the coding aspect on
what will you base the document name? Let me ask the question differently.
I grasp your numbering system. That part is fine. What I'm trying to
understand is how do you want your code to identify what type of ducument it
is currently renaming.

Let say your user creates a document and named it AccntTplt.doc and then
goes and enters it into your db. Based on what will I know what to rename
it too? Hoe can I programmitically identify if its 121 - Accounts Payable
or 122 - Accounts Recievable?

or am is this going to be identified in a field or series of
listboxes/comboxes on the form? Not that I'm looking to complicate things
further, but are all these docs going to be put in the same directory or are
there going to be directories for Accounts Payable and another Accounts
Recievable with sub-directories for each document type?

Given me a few more details and will be able to create the detailed code.

Daniel


















- Show quoted text -

Thanks Daniel, sorry for the slow response been buried with other
projects....

basically the person who will be administering the document will make
that call, and I was thinking that I could work our of a block of
command buttons that would do the searches, but under the command
buttons have the codes set up for the different divisions and document
types, then having the search for the document at that point, and the
subseqent copying over to the g: drive, that would all be done in one
operation, but as far as having the program differentiate, I was
thinking along the lines of two pop up menus with command buttons.