Advertisement

05.22.2008 at 05:14PM PDT, ID: 23426275
[x]
Attachment Details

VBA String Comparison Function Like

Asked by astoffels in Access Coding/Macros, Microsoft Access Database, SQL Query Syntax

Tags: , , ,

I am comparing the field in a table to one in a combo box on a form.
I can't call the function Like in the query design view. Access 2003 and 2007 is replacing the function with the call to a function called "Alike". This function does not compare strings it concatenates them.
Why am I not able to use the "Like" function in the query design view, and why do the 2 versions of access not recognize this call in the Design view of the query?Start Free Trial
 
Keywords: VBA String Comparison Function Like
Title
1 fingerprint comparison
2 Excel Column Comparison issue?
3 OPTION COMPARE DATABASE
4 Validation Rule
5 Comparing MMM-yyyy dates to dd-M…
6 File Comparison Program
 
Loading Advertisement...
 
[+][-]05.22.2008 at 05:21PM PDT, ID: 21628622

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 05:23PM PDT, ID: 21628634

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 05:43PM PDT, ID: 21628697

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Microsoft Access Database, SQL Query Syntax
Tags: microsoft, access 2007, 2003 / 2007, VBA String Comparison
Sign Up Now!
Solution Provided By: dqmq
Participating Experts: 3
Solution Grade: B
 
 
[+][-]05.22.2008 at 05:44PM PDT, ID: 21628701

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.22.2008 at 05:46PM PDT, ID: 21628705

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 05:49PM PDT, ID: 21628712

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 05:53PM PDT, ID: 21628731

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.22.2008 at 06:02PM PDT, ID: 21628765

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 06:15PM PDT, ID: 21628796

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 06:16PM PDT, ID: 21628799

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 06:50PM PDT, ID: 21628914

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.23.2008 at 03:45PM PDT, ID: 21636431

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.26.2008 at 09:12AM PDT, ID: 21647010

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628