Hyperlinks are not working in Microsoft Access 2010

[amwkl4]

I have a column called "Links" which has many records of website addresses. The data type for this column is set to hyperlink and when I first made the table, the hyperlinks worked. The next time I tried clicking on any link nothing happened. Also, if I edit the text in a hyperlink field and click on it after editing, the link works again. What could be the problem? I should note that I do not know how to use VBA.

[twinnyfo]

I always use a plain text fields for my hyperlinks, then execute them using a Command Button (does require VBA, but not much):

Application.FollowHyperlink Me.txtWebsite

Hope this hepps!

[amwkl4]

How do I implement this VBA? Also where would I put the button? I thought you could only put buttons in forms/reports. My goal is to be able to open the links that are shown after a search query has been performed to narrow the results.

[twinnyfo]

In terms of "good DB Design", my projects are always Form-driven, so that any results you want are always presented in a Form or Report. Thus, in a Form, if you have a record that contains this hyperlink, You have a corresponding button on the form to execute that hyperlink.

You state you do not know how to use VBA, so I would highly recommend you pursue some online tutorials, as VBA will allow you to create much more robust projects that can automate processes and easily manipulate and update data.

There are many good sites to begin learning about MS Access and advancing to VBA. This forum is more closely geared toward troubleshooting problems, rather than introductions for novices.

I can provide some guidance, but the forum medium leaves much to be desired when it comes to "start from scratch" instruction. I hope you understand.