Results 1 to 6 of 6
  1. #1
    WAVP375 is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171

    DLookUp command stoped working

    The LookUp command in a 3 year working DB has stopped working. Even the backups or the past 3 months o not work. The same code on my development machine works well as it always has. The only thing that has changed is the system has been upgraded to windows 365, but the code has been working since then. I have found no other problems with the existing code.
    Any thoughts or ideas?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    What's the DLookup, and how are you using it? What error do you get?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    WAVP375 is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171
    Quote Originally Posted by pbaldy View Post
    What's the DLookup, and how are you using it? What error do you get?
    Following is the code. =DLookUp("[FullName]","[TblVolunteers]","[Badge]=" & [Forms]![FrmVolunteerOnboard]![Badge])
    No errors or error code just no result.
    This code has worked fine for over three years. The network systems have been upgraded recently to Microsoft 365. That is the only difference although it has been working for a month until now. Confusing!

    Thanks

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    So the textbox is blank? Would this work as an alternative?

    http://www.baldyweb.com/Autofill.htm

    it would be more efficient if it fits the situation.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    WAVP375 is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171
    Quote Originally Posted by pbaldy View Post
    So the textbox is blank? Would this work as an alternative?

    http://www.baldyweb.com/Autofill.htm

    it would be more efficient if it fits the situation.
    I have no data to save I am mearly populating a form and then printing. I know that print out are supposed to br print objects however this is very simple form and has been working fine for over 3 years.

  6. #6
    WAVP375 is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171
    I could populate it with a query but that's one more unnecessary object.

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

Similar Threads

  1. DLookup not working
    By RJB in forum Access
    Replies: 4
    Last Post: 06-14-2018, 12:37 PM
  2. CarryOver Command is not working
    By Jchal3 in forum Programming
    Replies: 3
    Last Post: 05-10-2017, 03:24 PM
  3. Replies: 13
    Last Post: 01-22-2015, 05:27 PM
  4. IIf command not working
    By Lifendason in forum Reports
    Replies: 5
    Last Post: 02-10-2014, 03:03 PM
  5. Command Like DLookup but to store a string
    By viruzman in forum Programming
    Replies: 2
    Last Post: 07-28-2011, 02:04 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