Recent content by cayham86

Ill have another try later

Like didn't bring back any results

Isn't that being done directly from SQL not access

Tried that and it didn't work as it needs to contain part of a bit of text which isn't at the start of the description but in the middle of the description

Hey guys, I am trying to make a query which contains certain information so wondering how do I write a contains query?

Thanks for the help, you guys are very knowledgeable within access

Option Explicit Private Sub Command56_Click() Dim strUrl As String strUrl = Me.Value_Source strUrl = Replace(strUrl, "#", "") Application.FollowHyperlink strUrl End Sub This code has finally got it opening in chrome, if I set my default browser to Firefox will it automatically open in Firefox

Highlighted bits have shown up as a problem

Still getting a hash at the start and end of website URLS so they wont open when clicked how do I solve that.

Its complaining about the yellow highlighted part of the code.

I did do this and there is a valid URL

Can we DM as a lot easier

Problem in yellow I think

Value in value source is any website URL and I will try me.Value_Source and let u know how I get on. Also what does debug.print Me.Value_Source do as just tried it but couldn't tell if anything happened?

I have a column in a table with the name value_source where all the URLs are kept so the control is called value_source in the form