Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You might get most of the references fixed in stored objects (but not code) if you have Name Autocorrect enabled. It's another thing that the experts say shouldn't be turned on but I don't have a link handy for that one.

  2. #17
    dniezby is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Apr 2013
    Posts
    183
    Quote Originally Posted by Micron View Post
    You haven't entered any criteria in the dlookup though?
    I did though.
    I see no criteria in this expression: PLocalTime = DLookup("MyTimeZone","Settings")
    Without criteria, you get the field value from the first record in the table, so you are probably correct about the table design. I see no field that you can filter on, such as UserID, to get the time shift value according to the user.

    I think many here would agree with the notion that you should dispense with lookup fields in tables. Here's why http://access.mvps.org/access/lookupfields.htm
    This info helped a lot. I'm watching that YouTube series by "programming" that has made me rethink how to set up my tables better. That's has to be many of my issues.



    Sent from my iPhone using Tapatalk

  3. #18
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. DLookup not working
    By Lou_Reed in forum Access
    Replies: 29
    Last Post: 03-13-2017, 01:25 PM
  2. DLookup not working,HELP!!
    By riocobre in forum Access
    Replies: 2
    Last Post: 03-12-2017, 11:36 AM
  3. Dlookup not working
    By shaunacol in forum Forms
    Replies: 8
    Last Post: 06-12-2015, 09:28 AM
  4. Three criteria in Dlookup not working?
    By dcdimon in forum Programming
    Replies: 5
    Last Post: 07-03-2014, 07:04 AM
  5. DLookup isn't working
    By cec in forum Access
    Replies: 7
    Last Post: 12-28-2012, 12:21 PM

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