Run query using VB6 and DAO

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Stefanie (Stefanie_at_zsmail.net)
Date: 11/26/04

  • Next message: Paul: "Application block" 
    Date: Fri, 26 Nov 2004 20:03:26 +0100

    Hi,

    I'am new to database programming so please be patient.

    I created a database with one table (two fields) and one query (both fields
    from the table and sorted)
    Now i'd like to run this query from my VB6 application with some input.
    So i have a textbox on my form for a parameter in my query.
    How can i receive the values from field 1 and field 2 running my query.
    (I have to write these values to a file)

    (BTW i'am using DAO but i don't know if this is the best for a table with
    about 2,000,000 records.)

    Q1: How to run the query with a parameter from my textbox
    Q2: How to receive te results (i know how to write them to a file)

    Stefanie

  • Next message: Paul: "Application block"

    Relevant Pages

    • Re: form value based on query
      ... entry for that patient and set it as the default value. ... had been trying to use a query for the control source as a ... Will i have to use dlookup functions on each textbox? ... The parent form contains the demographics of ...
      (microsoft.public.access.forms)
    • Re: form value based on query
      ... Are you trying to use a query as the Control Source for a textbox? ... > show the last height of the patient from the last visit to ...
      (microsoft.public.access.forms)
    • Re: Run query using VB6 and DAO
      ... Stefanie bracht volgend idée uit: ... > I'am new to database programming so please be patient. ... > Now i'd like to run this query from my VB6 application with some input. ... Your eyes are weary from staring at the CRT. ...
      (microsoft.public.vb.database)
    • Run query using VB6 and DAO
      ... I'am new to database programming so please be patient. ... Now i'd like to run this query from my VB6 application with a parameter. ... So i have a textbox on my form for a parameter in my query. ...
      (microsoft.public.vb.database.dao)
    • Re: Q/R Models Again..
      ... The query results depend on the query model and type of query your ... provide unique key for patient level else query would fail. ... SCP must answer ... Study UID must be included also.. ...
      (comp.protocols.dicom)