Results 1 to 2 of 2

Thread: Select Query

  1. #1
    Join Date
    Apr 2004
    Posts
    13

    Unanswered: Select Query

    Hi all,
    I want to know how I can use SELECT query in VB.
    I used RUNSQL but Access throws an exception "Cann't run Select query".
    I need this query to link it to a form.
    The query is linked to two linked tables.

    Thanks allot...

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Re: Select Query

    Originally posted by WasseemFarhat
    Hi all,
    I want to know how I can use SELECT query in VB.
    I used RUNSQL but Access throws an exception "Cann't run Select query".
    I need this query to link it to a form.
    The query is linked to two linked tables.

    Thanks allot...
    Use the metodo DoCmd.RunSQL :

    DoCmd.RunSQL "UPDATE Empleados " & _
    "SET Empleados.Cargo = 'Director regional de ventas' " & _
    "WHERE Empleados.Cargo = 'Director de ventas';"
    Saludos
    Norberto

Posting Permissions

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