Search results

Wow, the whole QWERTY?? I have a pretty big head and reckon I would only end up with WERT on it at worst. Are you Hermann Munster in disguise??

Just came over cloudy here. So much for the sunny SE england

I am guessing here, so feel free to ignore me. Can you create two buttons on the form (one with each picture), and hide the relevant one?

Re: why players are writing on the ground Answer: They are trying to influence the ref into giving a yellow or red card to the other player. Solution: Yellow card anyone who simulates an injury. Simulation (i.e. diving) is a foul, so why isn't simulating an injury?

You haven't added your first string to your second string in that code, so have only a query starting at your WHERE statement. strSQL = strSQL & "WHERE ((([Combined data:Phoenix].SlipId) Like 'L*'));" This will solve that problem.

Just to hijack the thread a little, as someone who was diagnosed ADD by my school, I don't believe in ADD. I didn't have ADD, I just didn't care about certain subjects in school and did the minimum to get through. On the other hand, the subjects I was good at I picked up very quickly then got...

As this question seems to be outstanding, here is my understanding of it: Great Britian includes England, Scotland and Wales United Kingdom includes Northern Ireland as well. For Example, the UK passport has on the front cover: United Kingdom of Great Britian and Northern Ireland

I see your point, but I think you slightly misunderstood mine. Some people are adamant they know something, and are wrong. I for one, couldn't even guess at most of the items you mentioned above, but I wouldn't say I know there are 34 cantons in Switzerland and refuse to believe I may be wrong...

Ah, the technicalities!! I did know that deep down somewhere as I have been told before, but most people in the USA don't even know that one!!

I too have found that most people here (in the very southeast UK) seem to think there are 48, 49, 51 or 52 states. For some reason most people I have spoken to about this don't think there are 50! Strange. An example, "there are 52, don't forget about Alaska and Hawaii!" I had an argument with...

I think the problem is because the tables are only joined by the Section_Label, hence for each entry in Table_S, you are getting one line of Table_T at a time. If you join them by 'From' as well, this should resolve your issue. If you are not sure, post the SQL as well and we can advise how to...

I am shocked that no-one has mentioned the original Civilization as one of the best games ever. Also games like: Grand Prix X-Com 1+2 (rest were rubbish!) Freespace 1+2 Total Annihilation The Hitchhikers Guide to the Galaxy (Text adventure game for those that don't know) How I miss the days...

Just to follow up on Americans lack of geographical knowledge: 1) I went to school there, we learned the 50 states and 50 capitals. That was about it. I am still greatly lacking in geographical knowledge, but know where most countries are these days. 2) My mum still lives there and was asked...

You can run excel VBA commands from Access VBA. Try looking up those commands, then Access will do the work. There maybe some changes to the code needed, but they should be minimal. P.S. If you would like people to look through your code, please use the code window as below: example of a code...

The easiest way is to write some VBA code. I.E. You can enable text boxes depending on the result of a dropdown box. The VBA could be triggered when you change the dropbox. I assume you haven't worked with VBA before?

The first error in your spreadsheet which may help with other areas is that the conditional formatting for cell P13 should be for the 'Cell Value Is' as opposed to the 'Formula Is'. I assume you will need to correct this for the rest of the row. In addition, your outcome can return "FALSE" as...

I haven't tried it, but can you put "*" OR Is Null as the true condition of the IIF?

Of course. So simple and absolutely correct!

I actually have a search form with a subquery. I didn't use VBA to define the subquery as I didn't know enough VBA to do it then. I have a query which defines the subquery content, and my criteria is Like IIf([forms]![form1]![keyword] Is Null,"*","*" & [forms]![form1]![keyword] & "*")...

I am not sure but it sounds like a "" vs Null issue to me. The following code change may sort your problem out: Function SearchFun() If searchtext Is Null Then SearchFun = "*" Else SearchFun = searchtext End Function I haven't tried this yet, but hopefully it works! **EDIT** Wait, think...