Solved

Forms that link to Windows folders

Posted on 2004-10-21
194 Views
Last Modified: 2010-04-08
I would like to modify a contact form to be able to assign a hyperlink to a specific windows (not outlook) folder on my server.  This link would need to be different for each record.

Ultimately I would like to click on the link which woud open the windows folder specific to a contact that contains correspondence, images, etc relative to that contact.
0
Question by:lake59
    11 Comments
     
    LVL 49

    Expert Comment

    by:sunray_2003
    I am thinking if you need form for that ..

    Can you do as given here
    http://www.slipstick.com/outlook/toolbar.htm

    Outlook 2000 and 2002 hyperlink and macro buttons
    0
     
    LVL 49

    Expert Comment

    by:sunray_2003
    0
     
    LVL 2

    Author Comment

    by:lake59
    SR this looks just like what I am looking for!  Need just a bit of help to implement though.

    I created a lable control
    entered the folders address in the caption for the control
    pasted this code into the script editor:

    Sub Label1_Click()
        Set objWeb = CreateObject("InternetExplorer.Application")
        objWeb.Navigate Item.GetInspector.ModifiedFormPages _
          ("P.2").Controls("Label1").Caption
        objWeb.Visible = True
    End Sub

    and got this error: Object Required 'Item.GetInspector.ModifiedFormPages(...)'
    0
     
    LVL 49

    Assisted Solution

    by:sunray_2003
    Sorry to say that I am not familiar with VBA code.. I shall see if other experts in this TA come here. I shall contact them and ask them to post back here

    SR
    0
     
    LVL 13

    Expert Comment

    by:stefri
    Hi, kate
    Following your link, I am here

    lake59
    What is the name of the page P.2 or did you change it to someting eles
    Are you sure your label is in the P.2 page and not on General page?
    Stefri
    0
     
    LVL 13

    Accepted Solution

    by:
    Just tested your code with Label1 on General page, worked as a charm
    Sub Label1_Click()
        Set objWeb = CreateObject("InternetExplorer.Application")
        objWeb.Navigate Item.GetInspector.ModifiedFormPages("General").Controls("Label1").Caption
        objWeb.Visible = True
    End Sub

    Stefri
    0
     
    LVL 2

    Author Comment

    by:lake59
    Awesome!  Thank you both!!!
    0
     
    LVL 49

    Expert Comment

    by:sunray_2003
    Stefri , thanks
    0
     
    LVL 49

    Expert Comment

    by:sunray_2003
    Stefri,

    One more hot cake for you..
    Could you please check here
    http://www.experts-exchange.com/Databases/MS_Access/Q_21179089.html#12384339

    SR
    0
     
    LVL 49

    Expert Comment

    by:sunray_2003
    Thanks to all and Have  a great weekend

    SR
    0
     
    LVL 13

    Expert Comment

    by:stefri
    Sunray,
    Super-hero, if it is me, missed the appointment...Phonebooth was too small.
    Stefri
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
    Use email signature images to promote corporate certifications and industry awards.
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    857 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now