Hyperlinks in a table, each click opens NEW browser window - me no likeee

[peskywinnets]

So I have a table with hyperlinks (formed from the contents of other fields on the same row)....it all works, I click on the hyperlink & a browser window opens *but* a new browser window is opened each time - ok, you might think so what? Well the problem is, I'm actually trying to browse to a paypal transaction (how I anticipated this would work is, that I login to paypal once then when I click on the hyperlink it takes me to the actual transaction from my hyperlink, but becuase a new window browser opens each time I click on a hyperlink, I'm prompted to login to paypal, after I do, the link I initially wanted to go to is lost by paypal ........therefore I can't click on a hyperlink to go direct to the paypal transaction). If access only opened one browser window, then all this would work...any ideas how to force this?

 

[Galaxiom]

Change the New Window setting in the default browser.

In IE this is Internet Options > General > Tabs > Open links from other programs in:

 

[speakers_86]

Or use a better browser!

 

[Galaxiom]

Or use a better browser!

Which browsers honour the NewWindow argument in FollowHyperlink?

Another variation would be to use ShellExecute and specify the browser.

 

[peskywinnets]

From access help here:-
https://msdn.microsoft.com/en-us/library/office/ff822080.aspx

You will see how the hyperlink function works and the options you have when using it:-

expression .FollowHyperlink(Address, SubAddress, NewWindow, AddHistory, ExtraInfo, Method, HeaderInfo)

You need to change the "new window" option from its default where it is optional and nothing is in it; you need to add a 0 so that it does not open a new window.....

I'm a little puzzled at the above, these are hyperlinks that already exist in an access table ...whereas that reference above looks to be code for creating them (mine are already created).

I use chrome...the feature for opening in same window doesn't appear tobe there?

 

[speakers_86]

It is my understanding that modern browsers do not honor parameters to open in new windows. Instead, they use their own internal settings. So basically check the settings in your browser.

 

[peskywinnets]

That's because you can call the hyper link from a command button with code something similar to this:-

This code checks to see if there's a complete URL; if not, it adds the Facebook part of the URL to the username.

But I'm, using a table (it's just me using the database & for simplicity, I prefer using the database direct rather than front ending it with a form or report)......not sure I can have a button in a table?