Results 1 to 3 of 3
  1. #1
    Billy is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2018
    Posts
    1

    DLookup Problem


    Access can not run Dlookup Function in a new Computer
    how can i solve it .

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    this makes no sense,
    pick any table you have , copy any key you see in the table:
    ID, Name
    3, Smith

    then press Ctl-G (immediate window)
    type:
    ?Dlookup("[Name]","tableName","[id]=3")

    it should give you 'Smith'. (dont forget the question mark in front)

  3. #3
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,157
    More information required.
    Please show us what have you tried, and what is the error message if any?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. problem dlookup
    By ladiross in forum Access
    Replies: 5
    Last Post: 09-10-2015, 09:36 AM
  2. Dlookup problem
    By JeroenMioch in forum Access
    Replies: 6
    Last Post: 04-03-2015, 02:28 PM
  3. Problem with DlookUp
    By zylosan in forum Programming
    Replies: 10
    Last Post: 10-18-2013, 07:46 AM
  4. DLookUP problem
    By Symlink in forum Access
    Replies: 7
    Last Post: 03-28-2013, 11:03 AM
  5. Using Dlookup problem
    By Lupson2011 in forum Access
    Replies: 5
    Last Post: 12-07-2011, 10:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums