Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: Storing a field value in a table

    I have a table that gets generated from a query. The query always generates one record in the table. How can I save one of the field values of the table to memory?

    For example, the table contains a "Name" field, an "Address" field, and a "Telephone" field. Only one record is in the table. The value in the "Name" field is "Bob". I would like to store the text string "Bob" to memory. How can I do this?

    Please help. Thanks.

  2. #2
    Join Date
    Oct 2003
    Germany - Stuttgart


    Hi Wild,

    what do you mean with "memory"? A vba-variable (string)?
    if it so, you can create a recordset, dim rst as recordset/adodb recordset...
    set recordset...

    After opening the recordset, you can assign the selected value with the fields(index-value)-function.


Posting Permissions

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