Results 1 to 3 of 3
  1. #1
    mjwillyone is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    11

    Macro to search firstname and last name in Google

    Hello,

    I have a form that include firstname and lastname fields. I would like to create a button that will automatically put the two words together (i.e. Sam Jones) and then search for the name (along with the words Simpson Electric) in Google. My hope is that my web browser will automatically open and the search results will show.

    Thank you so much, in advance, for your help!



    Mike

  2. #2
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    there are several ways to do it and a google search should show many different ways.(punn intended) You can save results to a table or just launch a browser filled in with the criteria.

    to launch in a browser, you need to run something like below.
    you would concatenate your name fields and use it in the search criteria.

    Code:
    Dim strName as string
    
    strName = Me.YourFirstNameField & " " & Me.YourLastNameField 
    
    Application.FollowHyperlink "http://www.google.com/search?q=" & strName  & " Simpson Electric"

  3. #3
    mjwillyone is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    11
    Thank you very, very much! That worked perfectly!

    Mike

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

Similar Threads

  1. Replies: 11
    Last Post: 11-27-2018, 08:04 PM
  2. Google Style Search
    By JetMottoGURU in forum Forms
    Replies: 2
    Last Post: 03-02-2018, 05:18 PM
  3. Google Search Terms Needed
    By hrenee in forum Reports
    Replies: 4
    Last Post: 09-25-2013, 02:38 PM
  4. Replies: 7
    Last Post: 07-11-2013, 10:27 AM
  5. Replies: 4
    Last Post: 09-06-2011, 01:00 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