Hi there,
I'm trying to create a simple hyperlink to a carrier's website to obtain proofs of delivery for lines displayed in a list box.
The list box is called LstSOPDeliveryInfo.
The command button is called CmdBusinessPostPOD
The text box called txtPODHyperlink
The text box is updated with the web address to be used for the relevant line when the list box is clicked.
The problem i am having is that when i click the Command button, it opens explorer to an error that the page could not be found. BUT then if i ignore that and leave the browser open, then click the Command button again...it finds the correct page no problem!
Is using "Application.FollowHyperlink" as below correct here or am i missing somthing to "fire up" explorer first?
Here's the code...
--------------------------------------------------------------------------
Private Sub lstSOPDeliveryInfo_Click()
'Populate the text box with the full address including consignment reference.
Me.txtPODHyperlink = "http://www.business-post.com/scripts/wsisa.dll/ws_refquickpod.html?lc_SearchValue=" & Me.lstSOPDeliveryInfo.Column(5)
End Sub
--------------------------------------------------------------------------
Private Sub CmdBusinessPostPOD_Click()
'follow the hyperlink to the business post website for this consignment.
Application.FollowHyperlink Me.txtPODHyperlink
End Sub
--------------------------------------------------------------------------
I'm trying to create a simple hyperlink to a carrier's website to obtain proofs of delivery for lines displayed in a list box.
The list box is called LstSOPDeliveryInfo.
The command button is called CmdBusinessPostPOD
The text box called txtPODHyperlink
The text box is updated with the web address to be used for the relevant line when the list box is clicked.
The problem i am having is that when i click the Command button, it opens explorer to an error that the page could not be found. BUT then if i ignore that and leave the browser open, then click the Command button again...it finds the correct page no problem!
Is using "Application.FollowHyperlink" as below correct here or am i missing somthing to "fire up" explorer first?
Here's the code...
--------------------------------------------------------------------------
Private Sub lstSOPDeliveryInfo_Click()
'Populate the text box with the full address including consignment reference.
Me.txtPODHyperlink = "http://www.business-post.com/scripts/wsisa.dll/ws_refquickpod.html?lc_SearchValue=" & Me.lstSOPDeliveryInfo.Column(5)
End Sub
--------------------------------------------------------------------------
Private Sub CmdBusinessPostPOD_Click()
'follow the hyperlink to the business post website for this consignment.
Application.FollowHyperlink Me.txtPODHyperlink
End Sub
--------------------------------------------------------------------------
