Search results

  1. Z

    Run Time Error 2001 - What am I doing wrong?

    I have a simple form with a reset, a submit query and a close button. If I click the reset button and then try to run a qery I get an error message that says 'Run Time Error '2001': you canceled the last operation'. What does this mean and how can I get rid of it?. Here is my code.... Private...
  2. Z

    Run Time Error after refreshing the form

    I have a simple form with a reset, a submit query and a close button. If I click the reset button and then try to run a qery I get an error message that says 'Run Time Error '2001': you canceled the last operation'. What does this mean and how can I get rid of it?. Here is my code.... Private...
    • zeee
    • Thread
    • Replies: 0
    • Forum: Forms
  3. Z

    'Enter Parameter Value' box. How do I switch ift off?

    I have put together a simple form with a few text boxes and combo boxes. The user will fill in the form and will click the submit query button to run their query. However, when I click on the submit query button a window pops up on the screen asking for the user to enter a parameter value for...
  4. Z

    SQL Syntax Error

    I get a Syntax error message when trying to save this query. Could someone point out what I am doing wrong? SELECT BEM_EXCEPTIONS.BEM_EXCEPTION_ID, BEM_EXCEPTIONS.BEM_EXCEPTION_DESC, BEM_EXCEPTIONS.BEM_EXCEPTION_TYPE, BEM_EXCEPTIONS.BEM_GROUP_ID, BEM_EXCEPTIONS.BEM_STATUS...
  5. Z

    SQL statement where clause

    Hi, I am very new Access. I am trying to complete the WHERE clause of my SQL statement but don't know how to read in the values from the query form fields into this part of the query. This is the sql statement I have so far. My form is called BEM_EXCPETIONS_QUERY_FORM. SELECT...
Back
Top Bottom