Results 1 to 2 of 2

Thread: Help with Access

  1. #1
    Banned
    Join Date
    Jul 2004
    Location
    Blackpool
    Posts
    983
    Thanks
    15
    Thanked
    38 times in 20 posts

    Help with Access

    Okay so Ive got a problem / issue...

    I have an form in access, and I want a button that when clicked will open a webpage with values from the form in the URL...

    How the hell do i do it?

  2. #2
    Senior Member
    Join Date
    Jul 2003
    Location
    ZA ✈ UK
    Posts
    622
    Thanks
    0
    Thanked
    0 times in 0 posts
    Not that I know how to work with forms in Access, but I'm assuming you're able to name controls and handle events and so on. If that's the case, then you can do something along the lines of:

    Code:
    Private Sub LinkButtonName_Click()
        Dim strHyperlink 'As String 'Uncomment if it won't cause errors
    
        'Define the URL, using information from the form's fields
        strHyperlink = "http://your.url.blah/?id=" & FormTextBox1.Text
        strHyperlink = strHyperlink & "&desc=" & FormTextBox2.Text
    
        'Open the URL using the system's default browser
        Shell(strHyperlink)
    End Sub
    Hopefully that works.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. FTP access via Java
    By Kezzer in forum Software
    Replies: 11
    Last Post: 11-03-2005, 08:47 AM
  2. Replies: 7
    Last Post: 05-02-2005, 03:53 PM
  3. Can't access folders or printers from my laptop on network
    By TomWilko in forum Networking and Broadband
    Replies: 15
    Last Post: 02-12-2003, 09:44 AM
  4. Access Reports - help....
    By Lead_Head in forum Software
    Replies: 5
    Last Post: 22-10-2003, 12:19 PM
  5. NT4 Domain - A: drive access
    By joshwa in forum Software
    Replies: 1
    Last Post: 27-08-2003, 09:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •