Search results

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...

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...

Stupid question...it is the form field that you are talking about...anyway, I have checked the field name against teh query and they are identical. Here is my query... SELECT * FROM BEM_EXCEPTIONS WHERE (((BEM_EXCEPTIONS.BEM_EXCPETION_DESC)=Forms!frmBemExceptions!bemDescription Or...

Is this the database column name or the actual form field that you are talking about?

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...

Thanks for the help.

Yes I can save the SQL if I take the WHERE clause out. I guess I am struggling with the syntax more than anything. If I had to do this through a web page then the sql statement would look something like this in Java... String param1= parameter.getValue(fieldValue); Select * from table_name...

I am trying to capture the values the users type into text fields, or select from a combo box.

The values come from text fields and combo boxes within the form.

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...

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...