Auto hyperlinking

[swmasson]

Hi again,

I dont suppose anyone knows how do carryout the following task do you?

I have set a colum in a table to hyperlink, when i create a form and someone types in the report number as requested i.e. rep0001 i am trying to automatically generate a link to c:\reports\rep0001.doc. So what i basically need i would think is to create some kind of hidden link wich includes the report number in between C:\reports\*.doc.

But i have no idea how i would do this, or even if it is possible?

Thank you for your time

Kind regards

steve Masson

 

[Parker]

Hi again,

I dont suppose anyone knows how do carryout the following task do you?

I have set a colum in a table to hyperlink, when i create a form and someone types in the report number as requested i.e. rep0001 i am trying to automatically generate a link to c:\reports\rep0001.doc. So what i basically need i would think is to create some kind of hidden link wich includes the report number in between C:\reports\*.doc.

But i have no idea how i would do this, or even if it is possible?

Thank you for your time

Kind regards

steve Masson

Maybe I'm just being blonde but what are you expecting to store this information in a table or do you just want a document to open.

 

[swmasson]

I have a tabe called inspection data, within this table i have a field called Report Number. There are other field but they are irrelevant.

I created a form for data input to this table, the report number field was created as a "hyperlink" field.

When people input an entry they will fill in the report number field for example with "rep0001", i want this entry to be created into a hyperlink. the hyperlink will only open when clicked on which is normal but the hard bit is creating the format for the hyperlink.

As it stands when someone types in the report number into the form the text will try and open "http://rep0001" - What i would like it to open is C:\reports/rep0001.doc"

Have i explained this properly or am i still babling?

Thanks

steve