User Profile

Collapse

Profile Sidebar

Collapse
JDaly
JDaly
Last Activity: Jan 7 '11, 05:31 PM
Joined: Jan 6 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JDaly
    replied to Could I get some help with a string DLookup?
    in Access
    I tries somethink that worked. I still don't understand why it worked but I changed the line to
    stPL = DLookup("[ProductLine]", "[IM1_InventoryMa sterfile]", "[ItemNumber] = [4Item]") & Mid(stItem, 1, 0)
    It may be kludgy, and I haven't checked to see what kind of performance hit it gives but for the time being I can move along. Thank you for all the help. I was stuck in a rut and really needed some...
    See more | Go to post

      Leave a comment:

    • JDaly
      replied to Could I get some help with a string DLookup?
      in Access
      Run time error '94':
      Invalid use of null
      And that error message was after I changes the [Forms]![wo complete]![4Item] to Nz([fORMS]![wo complete]![4Item])

      In immediate mode ? Nz[4Item]
      evaluates to test as it should but doesn't in the expression.
      See more | Go to post

        Leave a comment:

      • JDaly
        replied to Could I get some help with a string DLookup?
        in Access
        Removed the single quotes. Still gives a null error.
        Thanks again.
        I wounder if IM1_InventoryMa sterfile being a linked file which is read only is affecting this? It evaluates correctly when I substitute in the ""TEST"" and reads the test data but doesn't seem to work with any of the standard string methods even though it evaluates in Ctrl-g as ? [Forms]![wo complete]![4Item] being equal to TEST.
        See more | Go to post

          Leave a comment:

        • JDaly
          replied to Could I get some help with a string DLookup?
          in Access
          I changed it in the code and it still doesn't work, and edited the post to reflect the change.
          Thank you for looking through the code and taking the time to help. I have been beating my head against a wall and retyping this with different syntaxes for some time.
          See more | Go to post

            Leave a comment:

          • JDaly
            started a topic Could I get some help with a string DLookup?
            in Access

            Could I get some help with a string DLookup?

            This bombs on the StPL= line. I want it to look up a string value from a table with a criterion of matching another string. In immediate mode the form evaluates correctly with ? Form![wo complete]![4Item] as TEST but it returns a null in when executed. I have tinkered with syntax for way too long and would like to get past this part of a project. The lines with """"TEST"" all return a value stored under TEST in the...
            See more | Go to post
            No activity results to display
            Show More
            Working...