Link to file in Contact form

[chris w]

I would like to make a box in my contact form that functions like the "web
page address" on the form except to point to a excell file on the LAN. I
have tried puting the file link in the web page box and it works fine, but I
need both fields.

I cant use the insert > file > as link , in the note section, as
workgroupShare dosent save that link in other fields.

I know this can be done with code but I need to know how and where.

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/d/tips/formhyperlink.htm

 

[chris w]

Thanks Sue,

You have been a great help to me in the past, but on this one I need
training wheels, I keep skining my knees.

If I have my form open in design view, I can add a control box to the form
but I cant figure out where to put the code for that box.

Sorry If I am not up to speed with the rest of the class, so if the
explanation is too much detail for the forum, I understand. I am going to
purchase your book to help me out.

chris w

 

[Sue Mosher [MVP-Outlook]]

Let's start at the beginning: How do you envision people using this feature
that you're designing in?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[chris w]

Thank you Sue,

Every Contact /Customer has a quote in Excel related to their custom
product. I woul like people to be able to input the link to the quote
exactly as you would enter a web address in the web page portion of the
contact sheet. I have tried to copy a link into the web portion of the
contact and it did link to the file, Outlook did add a %20 in the link.
Example- file://Cp300/my%20documents/Quotes/1aQuoteCP3.xls

I would like it to function like that except in its own field. Then any
time that contact is open, the quote can be viewed in Excel by simply
clicking the link to file.

 

[Sue Mosher [MVP-Outlook]]

You have two choices:

1) Use one of the built-in fields that support web URLs (there is more than
one -- look at the Field Chooser).

2) Use a custom text field and text box and a command button to launch the
file. See http://www.outlookcode.com/d/tips/formhyperlink.htm for sample
code.

It is not possible to make a simple text field and text box directly
clickable as a hyperlink.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[chris w]

I used option 1 and used the FTP site field. It works locally on each
machine, but WorkgroupShare shows the field as blank when opend on another
machine. Funny if the file is entered into the web page field the link to
file works and shows up on all workstations. All other aspects of my custom
form propogate as they should, all not fields and custom fields with drop
down boxes, just no links or attached files except for web page in
WorkgroupShare. I think I am out of luck unless I just use the web field
which I may do.

Thank you for the help Sue, I enjoy the skoolin. :^)

 

[Sue Mosher [MVP-Outlook]]

Then that's an issue with Workgroup Share that you'll have to take up with
them.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers