Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: How do i use the Dlookup command?

    Dear Reader

    I am creating a book retail store and i need help with:
    When selling a book, its price will be fetched from the table using the DLookup command and the stock will be reduced by the number of books sold.

    I would b grateful if someone could help me with this

    Thank You very much

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: How do i use the Dlookup command?

    Simple.. suppose you have the table books that has book price and other information like its qty.

    dim sngPrice as single

    sngPrice=dlookup("PRICE","TBL_BOOKS","ISBN_NO='" & txtISBN & "'")

    ISBN No will be captured from the screen which you will use to scan the book.




    Originally posted by Kewl101
    Dear Reader

    I am creating a book retail store and i need help with:
    When selling a book, its price will be fetched from the table using the DLookup command and the stock will be reduced by the number of books sold.

    I would b grateful if someone could help me with this

    Thank You very much

Posting Permissions

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