Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Rotterdam
    Posts
    17

    Question Unanswered: sqlstatement in DLOOKUP function

    Can anybody tell me if it is possioble to use the Dlookup function in combination with a sql statement.

    example:
    dim sql as string

    sql = """select * fom table"""

    dlookup("field",sql)

    thank you
    Peter Dorsman

  2. #2
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91
    Why would u use that ?
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

  3. #3
    Join Date
    Oct 2003
    Location
    Rotterdam
    Posts
    17
    I prefer to hide a query if possible
    Peter Dorsman

Posting Permissions

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