Yes, well look how long it has been an issue. I've turned off updates for Access. If it ain't broke...There's been a few posts about that recently, hasn't there?
Yes, well look how long it has been an issue. I've turned off updates for Access. If it ain't broke...There's been a few posts about that recently, hasn't there?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Short answer, no. All you can do is design to minimize it, beginning with splitting the db, not sharing the fe, hiding the nav pane, disabling default right click menus, disabling shift bypass, all the way to hiding the ribbon and rolling your own ribbon.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I went into my table after adding a hyperlink to it, worked great when i double click, opened it no problem, but when I tried (below) code on my listbox, getting an error. Any ideas on this? feel like we are close
Private Sub List308_DblClick()
Application.FollowHyperLink Me.List308.Column(6)
End Sub
One reason could be a disconnect between the control and the code. First, go to the property sheet of the control in design view. On the event tab, click the ellipses (...) and it will take you to the code. If it creates a new procedure, you must have changed the control name. If it goes to the same procedure, it will be reconnected if it was disconnected. The only way you'll know is if it works.
If not, it could be the syntax you have used. Try parentheses around the reference: (Me.List308.Column(6))
or declare a variable of type String and use that so that the reference (path) is coerced to a string
or substitute a working url for the listbox reference and see if it works. If it does, then there possibly there is an issue with the reference. If it doesn't then I'm not sure if file: portion is OK for this as the method was meant to navigate to web pages. Try the hard coded method without file: portion. String paths probably have to be enclosed in quotes within () as in Application.FollowHyperlink ("https:.....")
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Private Sub List308_DblClick() was not created by VBA as the event name.
It should be this : Private Sub List308_DblClick(Cancel as Integer)
I rarely use followhyperlink anymore. I use Dev Ashish's fHandleFile routine which you can find here . . . http://access.mvps.org/access/api/api0018.htm
The advantage being it opens the link in windows default programs (ie. a browser for a URL, your mail program for an email address, etc.)
Good catch. Clicking on the ellipses would catch that because it would begin a new and properly defined procedure.It should be this : Private Sub List308_DblClick(Cancel as Integer
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.