Correct Syntax

Posted on 2006-04-14
Last Modified: 2010-05-01
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True, password:="OPPS"

Any help would be greatly appreciated.

Question by:ca1358
    LVL 46

    Accepted Solution

    What exactly are you hoping to acheive? Are you wishing to link directly to a password protected page? If so, can you post the link to the site you are trying to access?



    Author Comment

    Thank all of you for this, I had 3 different problems with 3 different connections strings, and all you contributed to me finding the solution.  This particular one I ended using.

    Sub OpenAccess()

        Dim LPath As String
        Dim LCategoryID As Long
        Const DBPWD = "OOPS"

        'Path to Access database
        LPath = "\\Dtcnas-ilsp002\mandatory\Analysts - Working Files\Carol\Demo\volume.mdb"

        'Open Access and make visible
        Set oApp = CreateObject("Access.Application")
        oApp.Visible = True

        'Open Access database as defined by LPath variable and , false, dbpwd for password
        oApp.OpenCurrentDatabase LPath, False, DBPWD

        oApp.Application.DoCmd.RunMacro "Macro2CloseSwitchboard"
        oApp.Application.DoCmd.OpenForm "Form"
    End Sub
    LVL 46

    Expert Comment

    by:Wayne Taylor (webtubbs)

    Thanks for the points, although I think you may have closed the wrong question. If it is, I can ask Community Support to re-open this question for you.



    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

    728 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

    22 Experts available now in Live!

    Get 1:1 Help Now