CTRL+COPY then focus on BROWSER

L

lmv

I have a form that parses the address
It is set to a timer before it closes is there a way to have it
copy the data then focus to the open browser (FireFox)

I have a button on the form with the following which works well IF I PUSH
THE BUTTON.

=====================
Private Sub MapSearch_Click()
Dim MyHyperlink As String
Dim strGoogleLoaction As String

strGoogleLoaction = Replace([FullADDRESS], " ", "+")
MyHyperlink =
"http://maps.google.co.uk/maps?g=q&hl=en&geocode=&time=&date=&ttype=&q=" &
strGoogleLoaction & "&ie=
UTF8&msa=0&ll=52.802761,-111.972656&spn=45.773251,118.476562&t=h&z=3&om=0&msid=103780121206034963667.00044460d57e1dea96b9d"
Application.FollowHyperlink MyHyperlink
End Sub
==============
Sometimes though, I already have the browser map open and I just want it to
CTRL+Copy the data frm my open form so i can CTRL+V in the search on google
and then ALT+TAB to firefox....

Any ideas?
TIA!!
 
L

lmv

Ok I figured out the copy part
DoCmd.RunCommand acCmdCopy

but still haven't figured out the switch to open FoxFire browser window.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top