Office 2007 SP2 DLookup() Access problem

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • neelsfer
    Contributor
    • Oct 2010
    • 547
    #1

    Office 2007 SP2 DLookup() Access problem

    Did anybody else also experienced hassles. MY DLookup()code i use to prevent duplicate entries in 2 different applications stopped working. Quite frustrating to say the least.
    2007 Microsoft Office Suite Service Pack 2 (SP2) with windows xp sp3
    Tags: office 2007 servicepack 2
    • neelsfer
      Contributor
      • Oct 2010
      • 547
      #2
      see this thread of mine
      http://bytes.com/topic/access/answers/897744-prevent-duplicate-entries-form-access-2007-a

        Comment

        • dsatino
          Contributor
          • May 2010
          • 393
          #3
          You also might want to check your library references. I've had some similar situations after Office updates and it was always a broken library reference.

            Comment

            • neelsfer
              Contributor
              • Oct 2010
              • 547
              #4
              The strange thing is that when i make an AccDE copy of this file, then it works 100% and it prevent duplicate entries.

                Comment

                • neelsfer
                  Contributor
                  • Oct 2010
                  • 547
                  #5
                  how do you check library references?

                    Comment

                    • MMcCarthy
                      Recognized Expert MVP
                      • Aug 2006
                      • 14387
                      #6
                      In the VBE (code) window, go to Tools Menu and select References. Look to see if any of the ticked libraries is marked as "Missing:"

                        Comment

                        Previous template Next
                        Working...