Results 1 to 6 of 6

Thread: Select Query

  1. #1
    Join Date
    Apr 2004
    Posts
    13

    Unanswered: Select Query

    Hi all,
    How can I build SELECT query by DoCmd.RunSQL command in VB.

    If I write DoCmd.RunSQL "Select * From Symbolic_40 Where (Symbolic_40.Operand like "T*");"
    access throws an exeption "Cann't run Select query.
    What is the problem,And how I can solve it ?
    best regards...

  2. #2
    Join Date
    Apr 2004
    Location
    Kingsland, Georgia
    Posts
    231

    Re: Select Query

    i doubt this is it, but i thought the wildcard for the LIKE part of a select statement was 'T%' instead of "T*". i'm having fits running the docmd.runsql thing myself.
    sorry if this doesn't help.


    Originally posted by WasseemFarhat
    Hi all,
    How can I build SELECT query by DoCmd.RunSQL command in VB.

    If I write DoCmd.RunSQL "Select * From Symbolic_40 Where (Symbolic_40.Operand like "T*");"
    access throws an exeption "Cann't run Select query.
    What is the problem,And how I can solve it ?
    best regards...

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    try -1

  4. #4
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    -1 what?

    Sorry I dont understand what that means.
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Assuming the field is a boolean datatype, access translates true to -1.

    YourField = -1

  6. #6
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Okay I think I got it now I hope it helps em .

    Thanks Teddy

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •