itsquad
asked on
Is it possible to have and Access 2016 Module/vba copy the value of a field, open browser and paste?
I currently have a Module that does this perfectly:
Option Compare Database
Private Sub Command424_Click()
Command424.HyperlinkAddres s = "https://google.com/"
End Sub
I'm not schooled with Modules/VBA code hardly at all, so if you can... school me up! :D
My Form name is "Grab_Data"
Field Name I'd like to copy is "WebSearchTXT"
And it'd be a bonus if it would first Filter By Selection on the field "ITEMNO", open the web browser and paste the copied info!
It would be for just the current record or one record at a time that has the focus that I'd be working on (if that helps anything?)
Thanks! Kevin
Option Compare Database
Private Sub Command424_Click()
Command424.HyperlinkAddres
End Sub
I'm not schooled with Modules/VBA code hardly at all, so if you can... school me up! :D
My Form name is "Grab_Data"
Field Name I'd like to copy is "WebSearchTXT"
And it'd be a bonus if it would first Filter By Selection on the field "ITEMNO", open the web browser and paste the copied info!
It would be for just the current record or one record at a time that has the focus that I'd be working on (if that helps anything?)
Thanks! Kevin
ASKER
Yes, it would be the value that is in the "WebSearchTXT" field. Thanks
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Do you want to extend your existing code to do a search using a value/values from your form?