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?
Virtually Inert Person
Windows 10 
Access 2016
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.
Virtually Inert Person
Windows 10 Access 2016
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.Originally Posted by tholden
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Me.Dirty=True
Windows 7 32bit Access 2010 32bit
LOL. When I saw your response after I posted I was going to post "I gave you the fish, Microns teaching you how" Too funny.
Novice
Windows 10 Office 365
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
Virtually Inert Person
Windows 10 Access 2016
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.
Excess Access
Windows 10 Access 2016
Private Sub List308_DblClick() was not created by VBA as the event name.
It should be this : Private Sub List308_DblClick(Cancel as Integer)
Me.Dirty=True
Windows 7 32bit Access 2010 32bit
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.)
Virtually Inert Person
Windows 10 Access 2016
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.
Double Click Listbox
Posting Permissions
Reply With Quote