Search results

@strive4peace design, prototype, manufacture, retail, wholesale, repair & refinery, all smal-medium scale vertical integration i only dont have a mining plant😫

i Adjusted the QUERY to: SELECT * FROM mytbl WHERE (((UCase([mytbl].myfield1)) Like "*" & forms![myForm]!SrchText & "*")) this works by MAKING all cellValues upperCase, although i cant tell whether the original values are lower or upper, but the results are OK!! Thanks @CJ_London &Q...

@CJ_London , sorry i read it again but didnt understand were are you telling me to change, In Query somwhere?? im not an expert, im a CopyPaster :cry: or Adjuster a better word :unsure: ,

@CJ_London SrchText.Value = UCase(vSearchString) this makes the script search only for UPPER CASE? i cant get the results i want i have values for example [day;Day;DAY] in diferernt columns! UCase gives me only [=DAY] result!!

@strive4peace Whenever i try to update the linked Table i get [Cannot define fields more than once], Workaround Fix: i created a view in Sybase-mydatabase and i linked ms access on the VIEW, when i tried to delete then update the linked table from sybaseDb , all the tablenames were showing...

Hi, I changed the OPTIONS>GENERAL>NewSortOrder to GENERAL, and OPTIONS>GENERAL>FILTER lookup options (myDatabase) ODBC Fields [checked] and OPTIONS>ObjectDesigners>Query design> SQL server Compatibile Syntax (ANSI 92) >this Database [checked] // Had to replace LIKE "*" with ALIKE "%"...

Hi CJ will i be able to type in lower case and show lower and upper case results? in my database some columns contain text that are lower-case and other columns that cointain upper-case text, i need to search both!

Hello , i have made a form with a text box that searches many columns with string "SearchFor" [based on Dynamically search multiple fields] if i search for a string in LOCAL TABLE (case insensitive) the results are OK, but in LINKED TABLE search is CASE-SENSITIVE? linked table is from Sybase...

Hi im a jeweller, i use msAccess and Excel to build reports from a software that i use as POS with a Sybase [advantage database] i connect thru odbc to read, filter and do reports.. thanks