hey all,
i have the following code in VBA (access) and it works but i need to have similar code in Visual Basic (Visual Studio 2008) that does the same thing. so far the best i got was to have static links on the button. (don't have code on me atm so i can't see what i used)
the goal of this code is to have 3 text fields to fill out the click on one of the buttons and it will open the correct PDF for that client given the ProjectID, Lastname and ClientID
Thanks for any help..
i have the following code in VBA (access) and it works but i need to have similar code in Visual Basic (Visual Studio 2008) that does the same thing. so far the best i got was to have static links on the button. (don't have code on me atm so i can't see what i used)
the goal of this code is to have 3 text fields to fill out the click on one of the buttons and it will open the correct PDF for that client given the ProjectID, Lastname and ClientID
Code:
Private Sub cmdSite_Click()
Application.FollowHyperlink ("S:\ShedData\ShedOrders\~TEST\Quotes\" & Form_1.[ProjectNum] & " " & Form_1.[LastName] & "\Quotes\" & Form_1.[ProjectNum] & "-" & Form_1.[ClientID] & "-" & Form_1.[LastName] & "_SitePlan.pdf")
End Sub
Thanks for any help..

Comment