I very much appreciate the time you are taking to find a solution to this query. Ratslinger enlightened me a lot about the sequence and its relevance.
.
I’ll summarize what I take away from this, considering that this sequence could be run from a button.
.
Step 1 - Retrieves the name of an actor in the ‘Actor’ field of the DB.
.
This step in itself is not complex to perform. A few lines of code are enough to check if the Actor field is empty or not, and to retrieve the name to place it in an ActorName variable for subsequent manipulations.
.
Step 2 - Format the name for Wikipedia search, say Tom Cruise would be (Tom_Cruise)
Step 3 - Open the internet browser, say Firefox.
Step 4 - Run a search in the Wikipedia database (Tom Cruise - Wikipedia)
.
This is where things can get problematic and unnecessary. Consider that the http header or the URL of a Database like Wikipedia always has the same format to access the actor’s web page, like "https://en.wikipedia.org/wiki/" & ActorName; then you just have to format the name put in the variable so that it matches the general conventions found on Wikipedia. There, Ratslinger is absolutely right in mentioning that a single spelling error, an unexpected upper or lower case letter and the accessibility of the web page is compromised.
.
If however it works and the web page opens as desired, there is no need to go further in the procedure because the internet address thus created during step 1 and 2 can simply be inserted in the field provided for this purpose in the form.
.
However, it remains uncertain how to do it, because the slightest change in the Wikipedia http header and a different way of formatting the name of the actor makes it useless. Just consider that it might work half the time; so, I just avoided some copy/pasting. But it’s not good to do things by halves.
.
Step 5 - Retrieves the internet address of the Wiki page found or active
Step 6 - Enter this address in the Wiki field of the database provided for this purpose.
.
Consider that steps 1 to 4 are useless or not usable, so I would like to fall back on steps 5 and 6 to avoid having to do multiple copy/paste from the internet browser to the DB form field provided for this purpose . Why? By simple laziness, why do these manipulations repeatedly if the computer, thanks to a simple click, can do it for us and perhaps more efficiently.
.
I understand that these two steps require greater programming complexity because we are talking about gathering information from a medium that is external to the DB in order to insert it into it. We can simplify the process by mentioning that the web page is already found following a manual search and it is active. Clicking the button in the DB just sets in motion the external gathering process (active Web page of an X browser), in this case the URL and inserts this URL in the field provided for this purpose.
.
However, following the comments of Ratslinger, Villeroy and Wanderer, I realize that it is much more complex than I thought and that it would require a lot of programming time just to avoid this laziness of copying and pasting from the browser to the DB.
.
With the skills I have in the field of programming, it is absolutely impossible to achieve such a thing and I do not believe I have the right to ask someone to do it for me.
.
Thank you all!
