access2003 Like forced to Alike in ApplyFilter Where

B

Bren

Running a simple database
Three fields
Search field is [Item]
[Item] has :eg
Vikings
English Kings
Ancient Mapping
UK Settlements and maps
etc

Search is from a form Textbox
and OnUpdate using a Macro to ApplyFilter
eg 'Like' "ing" (with the correct syntax)
Got me Viking and English Kings

ON UPGRADE TO 2003
When I try to place a 'Like' in a macro or a Query Criteria it is forced
to 'Alike'
Help
Bren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ApplyFilter Where Condition in Macro 0
SQL Where Clause Syntax 0
Going nuts... 6
Going nuts... 5
Make the syntax in Access consistent 1
DOWNLOAD GibbsCAM 2009,Autocad 2009,WILCOM 2009,CAMWORKS 2009,CATIA2009,Medical software,MASTERCAM X 0

Top