I have a form with a subform made from a query. I this form I have a text box with the below code as its control source. The variable in this function is an expression from the sub-form query. However whenever there is no data produced from this query I receive a runtime error #2427 ‘you have...
I have a form that has 4 sub-forms within it. Each of the 4 sub-forms is based on a query. I also have a box in the main form that adds up the values from the 4 sub-form’s. My problem is that whenever there is No data generated from one of the sub-form’s I get a #ERROR that shows up in the...
I am not that experienced with SQL, and was hoping someone could answer my question. I have 2 tables. one of the tables houses part information, fields include PART_NAME, QUANTITY, WORK_ORDER_NUMBER, DOLLAR_AMOUNT. The other houses labor informaion, fields include LABOR_ACTION...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.