Recent content by Yarp

  1. Y

    i-Phone apps - free or otherwise

    skobbler Lite is a free turn-by-turn GPS navigation tool. It downloads the journey map when you start each trip, so beware data download costs, especially abroad. The maps are taken from a user updated wiki style map that you are encouraged to update if you find errors (OpenStreetMap). I have...
  2. Y

    Why is DELL Still in Business??????

    The only problem I have had over the last 4 years using my Dell laptop and desktop are relating to Vista being rubbish. I have upgraded the RAM in both and they still handle everything I want to do. The desktop has a new graphics card (a couple of years ago) and it still manages new games with...
  3. Y

    Form Filter

    I figured this one out myself recently, so there may be a better way, but this is how I did it. Basically you need to enter a valid query into the 'Row Source' on the combobox2 properties. I assume you have already done this combobox1. You can either create a query and call that, or just plug...
  4. Y

    Why is this not recognised as a valid fieldname or expression... grrrrrr! lol

    Try looking up the error code you receive on the error message via a search engine. I usually find a clue that helps me solve my coding mistakes this way. Without knowing your table and form design, it is pretty hard for anyone to diagnose why it isn't working.
  5. Y

    Progress Bar help

    I have made some alterations. You pretty much had it, just needed to trust yourself!
  6. Y

    Incredibly Smart or Incredibly Stupid?

    I have to ask you two questions relating to your post: 1) Where did I say you should allow illegal immigration? Nevermind the fact that if you allow it, it isn't illegal, I said the USA depends on it. I never said open the floodgates, however, some illegal immigration is needed to maintain...
  7. Y

    Incredibly Smart or Incredibly Stupid?

    Just to throw a little more fuel on the immigration fire. I have two points. 1) Americans claiming that immigrants can't move there is hypocrisy of the highest order. America was founded on immigration, and is still dependent on it today. Unfortuantely, USA, and now the UK, governments get...
  8. Y

    FIFA World Cup 2010

    Rugby has video replay. It has the TMO (Television Match Official).
  9. Y

    excel Between[]and[] query only works if not saved??

    Do you get an error message? Which line errors? Perhaps if you find the line that errors you (we) can identify why?
  10. Y

    Advice on Table Structure

    That was my typo there. For [Variable J2-1], try [Variable J2]-1. Does that make sense? If not, post the SQL you used and I will amend it.
  11. Y

    Advice on Table Structure

    No, but close J1 J2 30 31 31 32 32 33 I hope my editted response above makes more sense now.
  12. Y

    Advice on Table Structure

    Sorry, edit this because it was just plain wrong!! I was thinking that you would sum the distances on records starting where J1 was 30 and J2 was 40. So, variables are J1=30 and J2=40. A bit of air code: SELECT Sum(Distance) FROM Table WHERE J1 BETWEEN [Variable J1] AND [Variable J2-1]...
  13. Y

    Advice on Table Structure

    Just thinking out loud. I assume distances are the same in both directions. Fields Value Motorway M6 J1 J29 J2 J30 Distance 1.88 In this way, you can search for your start junction in J1, then your end junction in J2, and sum the Distance field. I guess if you are travelling in the opposite...
  14. Y

    Worst Software

    Norton Internet Security Suite - the subscription that came with the PC my sister brought expired, so it blocked access to the internet! Excuse me, if I want to surf with no security, what business is it of yours!!! Removed, and free software installed and immediately located issues that norton...
  15. Y

    If statement challenge

    chergh, nice edit, just saw it in time ;)
See more
Top Bottom