Results 1 to 2 of 2

Thread: Access 97 and VBA

  1. #1
    Michael Stolz Guest

    Access 97 and VBA

    I don't know how I can get the value of a filed from a table of the currently open Access-database.

    I fact I want to get this value in a procedure (runs behind a form) for writing it to a external ASCI-file.

    Can anybody help me?
    Thanks

    Kind Regards,
    Michael Stolz


  2. #2
    Phill Kenny Guest

    Access 97 and VBA (reply)

    Micheal,

    To retrieve the value of a form field simply use the Me!fieldName syntax in the form module. eg. varMyVariable = Me!txtSomeField

    You can also use the DoCmd.TransferText method to export data directly from a table to a variety of text formats. See 'TransferText' method in online help for more details.

    Hope this helps,

    Phill Kenny


    On 1/22/99 2:50:33 AM, Michael Stolz wrote:
    > I don't know how I can get the value of a filed from a table of the
    > currently open Access-database.

    I fact I want to get this value in a
    > procedure (runs behind a form) for writing it to a external
    > ASCI-file.

    Can anybody help me?
    Thanks

    Kind Regards,
    Michael Stolz


Posting Permissions

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