Search results

The sum([qty]) calculation actually works fine if the other calculation is deleted (I read that one miscalculating can cause all of them to so I checked). Which now leaves me at there must be a syntactical error in my =Sum(CalcExtension()) calculation detailed above. Could you take a look and...

The FULL story... I have the calculation located in the footer of the subform. There is sometimes no rows in this form so I have used Allen Browne's IIF(FormHasData([form]),calculation,0) syntax to show a zero if there aren't any rows to calculate on. Consequently I copied his public function...

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

I'm seeing what you mean. I haven't actually set the strON. By the look of it to me right now I also seem to have a comma in the string of arguments before strON which should not be there. Would I also need to put quotes around strON...or double quotes since it is a string (or put one set...

I compiled the code and compacted and repaired the database. the gotorecord method is now working but I still must have some sort of syntax error with my findrecord. Any ideas?

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

Brilliant!!!! Now... Why does Set Me![subfrmProductList].Form.Recordset = rsIL generate the error '7965': The object you entered is not a valid Recordset property. I did pretty much this exact same thing before (assigning an adodb.recordset as the recordset) but it was on the main form not...

SELECT tblProducts.ItemDescription, tblProducts.Category, tblCategories.Category FROM tblCategories INNER JOIN tblProducts ON tblCategories.CatID=tblProducts.Category WHERE tblProducts.ItemDescription like "*ho*" "ho" is what is currently in the txtFindProduct control Pasted straight into the...

I thought my "quotes" were OK since I included the Chr(34)s in the strSQL portion so they are already incorporated. Plus it logically cannot get my head around how it is possible that if the SQL I get from the debug.print/immediate window returns the correct rows why this just isn't working...

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