Linking to specific external documents

[Guest]

I want to create a link to a document relating to a particular record. The
name of the document will be the same as the primary key reference of the
record and all documents will reside in the same directory but maybe of
different file types - what is the best way to go about this?

thanks
Richard

 

[Guest]

I think you would want to add a new column to your underlying table....in
Design View, add a new item & select the hyperlink option as the Datatype.

then in the table itself...you will have a new column....you can type in the
path here

or put your cursor in a blank field in that column and right click and you
will see that 'hyperlink' is one option....select the 'Edit Hyperlink' and it
will open the window browser for you to go find the document...

 

[Guest]

Thanks, I did try this with the following on the default value of the
underlying table (where [DMS Ref] is the primary key of that table):

="S:\DMS Database\Documents\" & [DMS Ref]


But it doesn't like it.

What I was thinking was an option button on the overlying form with code on
the Onclick event that points to that document (if it exists of course).

Does anyone know if this is possible?

Thanks
Richard

 

[Guest]

if you want to auto-define the url link by using the 'value' of another field
in the table (i.e. the primary key) then you might try this via a query
rather than via the default value of the form....

in a query you can have a field that is a calculated value based upon the
value of another field of the same record - so you should be able to plug in
that record's key value into your preset url string text....

then of course build the form off the query....
--
NTC

Thanks, I did try this with the following on the default value of the
underlying table (where [DMS Ref] is the primary key of that table):

="S:\DMS Database\Documents\" & [DMS Ref]


But it doesn't like it.

What I was thinking was an option button on the overlying form with code on
the Onclick event that points to that document (if it exists of course).

Does anyone know if this is possible?

Thanks
Richard

I think you would want to add a new column to your underlying table....in
Design View, add a new item & select the hyperlink option as the Datatype.

then in the table itself...you will have a new column....you can type in the
path here

or put your cursor in a blank field in that column and right click and you
will see that 'hyperlink' is one option....select the 'Edit Hyperlink' and it
will open the window browser for you to go find the document...

 

[Guest]

Ok, I can get the windows path for each referenced document in a query field.
But not too sure what to do with it now - I cannot make reference to that
field on a hyperlink and I cannot set the field type on a query to hyperlink.

What code would I write on an OnClick event to activate the path to that
document?

Thanks
Richard

if you want to auto-define the url link by using the 'value' of another field
in the table (i.e. the primary key) then you might try this via a query
rather than via the default value of the form....

in a query you can have a field that is a calculated value based upon the
value of another field of the same record - so you should be able to plug in
that record's key value into your preset url string text....

then of course build the form off the query....
--
NTC

Thanks, I did try this with the following on the default value of the
underlying table (where [DMS Ref] is the primary key of that table):

="S:\DMS Database\Documents\" & [DMS Ref]


But it doesn't like it.

What I was thinking was an option button on the overlying form with code on
the Onclick event that points to that document (if it exists of course).

Does anyone know if this is possible?

Thanks
Richard

I think you would want to add a new column to your underlying table....in
Design View, add a new item & select the hyperlink option as the Datatype.

then in the table itself...you will have a new column....you can type in the
path here

or put your cursor in a blank field in that column and right click and you
will see that 'hyperlink' is one option....select the 'Edit Hyperlink' and it
will open the window browser for you to go find the document...
--
NTC


:

I want to create a link to a document relating to a particular record. The
name of the document will be the same as the primary key reference of the
record and all documents will reside in the same directory but maybe of
different file types - what is the best way to go about this?

thanks
Richard

 

[Guest]

sounds like you got the query to make the url you need - that's the right
first step.

from here you need to be creative - - I guess what I might do is the modify
that query to be an Append Table query...(maybe a MakeTable)....and then you
can define this field as a hyperlink in advance - and then append to it to
the final Table.

so you end up with a preliminary table and a final table made by your
query.....with a macro you can link all these things together so they happen
instantly one after the other. you can play around with it as appropriate
but in general you've figured out how to automate the creation of that url
link so I think that's the key thing....
--
NTC

Ok, I can get the windows path for each referenced document in a query field.
But not too sure what to do with it now - I cannot make reference to that
field on a hyperlink and I cannot set the field type on a query to hyperlink.

What code would I write on an OnClick event to activate the path to that
document?

Thanks
Richard

if you want to auto-define the url link by using the 'value' of another field
in the table (i.e. the primary key) then you might try this via a query
rather than via the default value of the form....

in a query you can have a field that is a calculated value based upon the
value of another field of the same record - so you should be able to plug in
that record's key value into your preset url string text....

then of course build the form off the query....
--
NTC

Thanks, I did try this with the following on the default value of the
underlying table (where [DMS Ref] is the primary key of that table):

="S:\DMS Database\Documents\" & [DMS Ref]


But it doesn't like it.

What I was thinking was an option button on the overlying form with code on
the Onclick event that points to that document (if it exists of course).

Does anyone know if this is possible?

Thanks
Richard

:

I think you would want to add a new column to your underlying table....in
Design View, add a new item & select the hyperlink option as the Datatype.

then in the table itself...you will have a new column....you can type in the
path here

or put your cursor in a blank field in that column and right click and you
will see that 'hyperlink' is one option....select the 'Edit Hyperlink' and it
will open the window browser for you to go find the document...
--
NTC


:

I want to create a link to a document relating to a particular record. The
name of the document will be the same as the primary key reference of the
record and all documents will reside in the same directory but maybe of
different file types - what is the best way to go about this?

thanks
Richard