Results 1 to 3 of 3
  1. #1
    Nod_Swerdna is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2015
    Posts
    27

    How Do I open a website URL in 'Pop Up Mode' from a form in access.

    I am writing a program that allows users to enter customer info and I want to be able to pop up a window that will search for Postal (Zip) codes using the Postal Service URL. (I would like to position the popup so that the contents of the Address and Postal Code fields are still visible on the form). I would also like to know if there is a way to copy the contents of the Address Field in my program to the Windows Clipboard, using VBA code, so that I can paste it into the Postal Code Finder without highlighting the field contents and pressing Ctrl-C.
    Thank you so much for your help in advance...
    Don

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    I built a form with boxes for each item
    street #
    street name
    street type (ave, st, way)
    city
    state

    In the form I added the activeX control , microsoft web browser , when the user click the find button, it builds the URLstring to the browser...

    Code:
    Private Sub btnFind_Click()
    Dim vUrl
        Dim strURL As String
        Dim objIE As Object
    
        strURL = "http://www.yahoo.com"
    
    
    vUrl = "https://tools.usps.com/go/ZipLookupResultsAction!input.action?resultMode=0&companyName=&address1="
    vUrl = vUrl & txtNum & "+" & txtStreet & "+" & txtStType
    vUrl = vUrl & "&address2=&city=" & txtCity
    vUrl = vUrl & "&state=" & cboState & "+"
    vUrl = vUrl & "&urbanCode=&postalCode=&zip="
    
        Set objIE = Me.WebBrowser1.Object
        objIE.Navigate vUrl
    
    End Sub

  3. #3
    Nod_Swerdna is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2015
    Posts
    27
    Thank you for your help with this problem. I don't completely know how to adapt your code to my program, but I will try it as soon as I get a chance and I'm sure I can work it out. Thanks again...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form to open in 'find mode'?
    By kattatonic1 in forum Forms
    Replies: 13
    Last Post: 10-17-2013, 01:37 PM
  2. Can't open form in Design mode
    By GraeagleBill in forum Forms
    Replies: 4
    Last Post: 01-06-2013, 08:41 PM
  3. Open Access Database in Read Only Mode
    By praloy in forum Programming
    Replies: 2
    Last Post: 03-28-2012, 10:50 PM
  4. Replies: 2
    Last Post: 09-01-2011, 10:48 PM
  5. Open Form in Add Mode
    By Boreal2009 in forum Programming
    Replies: 2
    Last Post: 10-23-2009, 10:53 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums