Search results

Hi, For many years I have been using the following code to search plant names on Google. Today, it's stopped working and hangs the database. Dim strURL As String, Tempstr As String Tempstr = Forms!MainOptions!MainView!LatinName Tempstr = Replace(Tempstr, " ", "+") strURL =...

Listening is not something you can switch off. In the UK we have freedom of expression which allows people to voice their opinions but, unlike in the US, using foul language is deemed to be a public order offence. Hence the different terminology.

Thanks CJ, I overlaid a transparent button and it worked. Thanks for the solution.

Hi, On the OnClick event for the image, I used - MoreDetails_Click with the same result. I have read the comment from CJ_London (below) and think he has supplied a solution which I'm off to try out. Thanks for your input.

Hi All, Interesting problem today. I have a continuous form which shows a few main fields together with an image. On a button in each record I have the following code - Dim TempID As Integer Forms!MainOptions!ID = Me!ID TempID = DLookup("[ID]", "MainTable", "[LatinName]= " & Chr$(34) &...

Tempstr is usually a plant name. For the purpose of my tests I have used Tempstr = "Pennisetum" The actual string content makes no difference.

Indeed. I am focused on Access simply because the same URL works outside of Access but not not within the VBA. I tried using the line in Word but it came up with the cookie request. Although, if I paste the same line into the address bar of Chrome, the results page opens with no request. I...

Yes, indeed. I, too, can copy the code into Chrome and it runs without the prompt. I can only assume that the line I use to open the browser with the search parameters is not correct. I agree that line is more to do with Google but when I use it within Access, it becomes, for me, an Access problem.

Hi. I haven't tried it Word, Excel or Outlook. Access is my bag. I'm sure that it's something in the strURL that isn't right, that I'm missing something from it that would allow it to skip the prompt. Tomorrow, I will copy the line to Word and see what happens. Thanks for your constructive input.

Thank you for your reply. However, it wasn't very helpful; I wasn't looking to change my browser. My browser settings are set correctly and the prompt doesn't appear when I use Chrome normally, only when opening the browser from VBA, which is why it remains an Access question. There must be...

I have my database which has a button to onclick a link to a site with search parameters - Dim strURL As String, Tempstr As String Tempstr = Forms!MainOptions!MainView!LatinName Tempstr = Replace(Tempstr, " ", "+") strURL = "https://www.google.co.uk/search?hl=en&q=" & Tempstr...

What mainstream science sources, and media outlets, are reporting this revelation? I haven't heard anything so far, so I'm leaning towards the hoax.

And, of course, it will work.

Thank you both for your comments. I still prefer my method but I accept it may not align with good practice.

The reason being that I can make the search easier using one field rather than 12? I can search for single months or multiple months (seasons, but not exclusively). By my thinking, 400 records X 12 fields is a lot more than 400 fields...and would use less coding.

Yes. The check boxes are initialised to ensure a two-state operation, and the code determines whether each is True or False. That part of the code is completed a working satisfactorily. The code tests for True or False so won't look for values. In other circumstances, I tend to use an...

Thanks for that but I'm not looking at the binary method, having looked at the code, it seems a lot of effort for little return. I am now clearer in my mind that my originally suggested method is the way to go. I will have unbound 12 check boxes and a separate field that has 12 symbols...

Thanks to all for your replies. I am going away to study and digest them... Thanks again. DaveE

Thanks for that... I've always wondered about using one-to-many table relationships. In the context of data being repeated a lot within the db, I've always used one-to-many. In this db, however, the plant has one unique flowering pattern so, I think, it can be held within the same table. A...

Hi CJ, Indeed, that would be the method, with the field being 'decoded' into months dependent upon each code bit. The string would be inspected by a looping VBA procedure on the OnCurrent event. And yes, some flowers have two flowering periods in a single year, so this method would cater for...