Search results

I've used sum functions in footers before and never had a problem. I am entering =sum([txtQty]) in the control source of an unbound txtbox (located on a subform) to calculate the total number of items in an order. Seems simple enough but in this form I get an #Error message every time...

What causes docmd methods to not execute? For some reason the docmd method in both the frmShipSwitch and frmShipment code was being moved through without doing anything. For a bit it will work and then if I do something in the code like add a message box it will stop working again. Why would...

Sorry! Couldn't think of the right title. I have a database for a "store". The main form contains the order information and the subform contains the order details including the products and the quantities "sold." I have a "Complete Order" button that finishes up that order and clears to a new...

This is the same situation I have been working on for some time. To summarize, I have a subform called sformOrderLines that is in datasheet view. Users use this subform when entering in all the different products that a customer buys in a certain order. I want to be able to handle data entry...

I have a subform (subfrmOrderLines) which has a control (txtItemdescription) whose keyup event creates a string (strsearch) which in turn feeds into a SQL that is used as the recordsource for a second subform (subfrmProductList) also on the main form. My problem is that to show the most recent...

Using code to use content of unbound textbox control in an SQL statement to generate an adodb.recordset that will be used as the rowsource/recordset (?undecided which is preferred?) for the subform. I know that the SQL is correct because if I use the immediate window results from the...