Search results

Well I did hope it was an easy fix for someone who understood code, obviously I don’t but can struggle through sometimes, I can fault find to component level on transmitters radio’s etc. but not code. I joined the group because it welcomed beginners, but not to be rude either but it obviously...

Well I must admit I am totally stuck I assume this is the bit of code I need Select Case Sql_Type Case sdt_text Sql = Replace(Trim(Value), "'", "''") If Sql = "" Then Sql = SqlNull Else Sql = " '" & Sql & "'" End If But exactly where to put it in my SQL I'm afraid I have no know idea...

I thing I forgot to mention if you use a double inverted comma like it’’s works fine

My database is based and dissected from the old Northwind database which works well enough for me BUT the database does not support searching for inverted commas e.g. its is fine but search it’s and it produces a pop up error message as follows Run-time error ‘3075’ Syntax error (missing...

OK thank you for the welcome nice to meet you all

Hello all I have been using access for my record database for years but struggled to get a sate base up and running but I can’t overcome one problem, to do with searching a database and I wonder where the best place on the forum to post the question. Hope someone can help