Results 1 to 3 of 3

Thread: VBA Access Help

  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: VBA Access Help

    Hi,

    Easy question:

    how do i access the field value in a table ?

    e.g. for table "People", in field "Name", how do i access what is in that field ?


    PS. Is there a VBA access specific reference library online anywhere ?

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    how do you wnat to access? through vba code? if so then create a recordset based on that table and then use

    rs![FieldName] to get the field value

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Or RS("FiledName")
    Or RS(i) ' i denotes the number of the field in the table

Posting Permissions

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