User Profile

Collapse

Profile Sidebar

Collapse
Tim Kuzniar
Tim Kuzniar
Last Activity: Dec 10 '13, 10:11 PM
Joined: Feb 7 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Tim Kuzniar
    replied to How to handle unusual input for an Access parameter query?
    in Visual Basic
    Thanks for the idea, Rabbit.
    I tried it, but I still get a "Type Conversion" error.

    I'm guessing that the act of entering a negative or positive sign in front of the number in the parameter query dialog is causing the problem -- though I'm still not sure what it might be.

    Can Access not handle the input of math symbols in a parameter dialog..?

    >>TimK
    See more | Go to post

      Leave a comment:

    • Tim Kuzniar
      started a topic How to handle unusual input for an Access parameter query?
      in Visual Basic

      How to handle unusual input for an Access parameter query?

      In a SQL statement of a query there is a line that reads:

      [SomeNumberField] + 1

      I have turned it into a parameter query by rewriting it as:

      [SomeNumberField] + [Enter number to add:]

      which, of course, allows me to pick a number to add on the fly when I run the query.

      Now, what I'd like to do is to also pick the math operator on the fly as well -- say to input either a "+"...
      See more | Go to post
      No activity results to display
      Show More
      Working...