User Profile

Collapse

Profile Sidebar

Collapse
scott7931
scott7931
Last Activity: Dec 18 '12, 09:03 PM
Joined: Dec 18 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • scott7931
    replied to "Enter Parameter Value" with long Expression
    in Access
    I found that the error was a simple column name error in the expression. I guess I wasn't sensible enough to note that in my original evalution of the situation. Can't imagine no one else has over-looked anything so simple.
    See more | Go to post
    Last edited by NeoPa; Dec 18 '12, 04:25 PM. Reason: Removed flame.

      Leave a comment:

    • scott7931
      started a topic "Enter Parameter Value" with long Expression
      in Access

      "Enter Parameter Value" with long Expression

      I set up the following expression to identify source material. When running the query, I get a request to 'Enter Parameter Value' for the "ccd". As you can see by the spelling, this matches the name of one of the target columns. I've looked at it for a number of hours and can't spot the flaw. Any observations would be greatly appreciated.

      Code:
      Traceabilty: 
   IIf(Eval(Not IsNull([ccd]) 
         And Not IsNull([si])),
      ...
      See more | Go to post
      Last edited by NeoPa; Dec 18 '12, 04:43 PM. Reason: {Added mandatory [CODE] tags.}[Z:{Stepped the code block for easier read}]
      No activity results to display
      Show More
      Working...