HI,
I have a button that opens a client file on www.gov.uk website, It takes their VAT number from our access DB and adds it to the URL then opens the web page (a login page appears first, then forwards you on to the page on the URL), simple really.
GOV.uk have just changed their web address of the clients files from
www.gov.uk/vat/trader/'vat-number'
to
www.tax.service.gov.uk/vat/trader/'vat-number'
I've changed the link, but it now bounces to 'you can't view this page'
If I copy and paste the url into google it works fine, but through access it bounces?
This is my code for the Web button
What am I doing wrong?
Thanks in Advance
I have a button that opens a client file on www.gov.uk website, It takes their VAT number from our access DB and adds it to the URL then opens the web page (a login page appears first, then forwards you on to the page on the URL), simple really.
GOV.uk have just changed their web address of the clients files from
www.gov.uk/vat/trader/'vat-number'
to
www.tax.service.gov.uk/vat/trader/'vat-number'
I've changed the link, but it now bounces to 'you can't view this page'
If I copy and paste the url into google it works fine, but through access it bounces?
This is my code for the Web button
Code:
Private Sub VATx_Click()
Dim ctl As CommandButton
Dim VATNO
VATNO = Replace(vat_no.Value, " ", "")
Set ctl = Me!VATx
With ctl
.HyperlinkAddress = "https://www.tax.service.gov.uk/vat/trader/" & VATNO
End With
End Sub
What am I doing wrong?
Thanks in Advance