Link to home
Start Free TrialLog in
Avatar of itsquad
itsquadFlag for United States of America

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.HyperlinkAddress = "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
Avatar of Norie
Norie

Kevin

Do you want to extend your existing code to do a search using a value/values from your form?
Avatar of itsquad

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 TRIAL
Members 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.