Search results

  1. A

    Update Query Using Replace Worked in 2013 but not in 365

    Thank you very much indeed for your reply. I put the update inside the Cstr() and it worked a treat. So just incase anyone reads this who had the same problem and is as thick as me, what worked is below: Cstr(Replace([Stock]![stkItemURL]," ","-"))
  2. A

    Update Query Using Replace Worked in 2013 but not in 365

    After a hard disc failure I've been forced to upgrade from running Access 2013 on Windows 7 to Office 365 on Windows 10 An upgrade query that worked fine before (for many years) would replace spaces with dashes. The Update To contained: Replace([Stock]![stkItemURL],"...
  3. A

    Hello from Cornwall (UK)

    I've been using Access for maybe 20 years. Emphasis on using rather than programming as I've achieved all of my needs just using queries. I've never got into vba but always wanted to. I've also always wanted to learn to touch-type but still just use 2 fingers. My main computer at work is 10...
Top Bottom