cruzinonline
Registered User.
- Local time
- Today, 13:42
- Joined
- Jun 26, 2014
- Messages
- 13
Sorry to jump in but you guys are awesome. I was dealing with the same issue, trying code after code. I had the exact same errors coming up and when you commented that the field was a "text" field, well, voila, it worked.
For search purposes, I had an export from an oracle database that includes a field called WONUM which are work order numbers. We have another program onsite where you can type in a work order number and pull up a ton of data.
I'm a building a data base that "taps" into the oracle data base and pulls information we need. The other search engine pulls from another system I don't have back access too and it is a pain to type in the work order numbers so I built a make table querey that simply takes the work order number and builds the address that the search engine uses to find a record. The result is the hyperlink to find details from the record you are looking at. What I didn't like was it was displayed as a long hyperlink.
Your solution is perfect. Thanks.
Private Sub Command3_Click()
Application.FollowHyperlink Me.Hyperlink
End Sub
For search purposes, I had an export from an oracle database that includes a field called WONUM which are work order numbers. We have another program onsite where you can type in a work order number and pull up a ton of data.
I'm a building a data base that "taps" into the oracle data base and pulls information we need. The other search engine pulls from another system I don't have back access too and it is a pain to type in the work order numbers so I built a make table querey that simply takes the work order number and builds the address that the search engine uses to find a record. The result is the hyperlink to find details from the record you are looking at. What I didn't like was it was displayed as a long hyperlink.
Your solution is perfect. Thanks.
Private Sub Command3_Click()
Application.FollowHyperlink Me.Hyperlink
End Sub
