Recent content by IanC

I hate to state the obvious, but your initial example has mismatched brackets. You have 4 opening brackets, but only 2 closing brackets. You close the "IsNull" function, and then the multiplication, but not the SUM nor the ABS. =Abs(Sum([Contract Price]*(IsNull([Date Closed]))

I hate to state the obvious, but your initial example has mismatched brackets. You have 4 opening brackets, but only 2 closing brackets. You close the "IsNull" function, and then the multiplication, but not the SUM nor the ABS. =Abs(Sum([Contract Price]*(IsNull([Date Closed]))

If I understand you correctly, I suspect that you are quite close. You don't need to use a module for what you are doing. I assume that the textbox is unbounded (not tied to any field in an underlying table). Set the "control source" of the textbox on the form (or simply type into the...

Access has a built in keyboard combination shortcut for doing this. Just press [CTRL]+['] (Control Apostrophie). Hopefully that does the trick for you! Ian

Perhaps I didn't state my question properly. The record on the main form is chosen using a dropdown combo-box listing all available records. I DO NOT WANT TO CHANGE THE SORT ORDER on the two sub-tables. I know that sorting differently is the easiest way to achive this, but I want to maintain...

Thanks Neil. Turns out that I forgot to enclose the "WHERE" clause in quotation marks. Once that was done, it works like a charm.

I'd like to produce a report with lines on it for the person to add their comments. The information above this area is variable in length depending on how many sub-sections are printed. Is there a way that I can repeat the lines down to the bottom of the page? I assume that there I must...

On a form, I've added a button to print just the currently displayed record. The OnClick event of that button goes to a procedure that calls a report with the "DoCmd.OpenReport". The "WHERE" clause set to only print the current record number. Unfortunately the report insists on printing all...

My database has three tables linked in sort of a CUSTOMER > ORDERS > ITEMS ORDERED fashion. (The data is different but the linking concept is the same). My main data entry/display form is similarly linked in a MAIN FORM > SUBFORM > SUB-SUBFORM display. When a "customer" is chosen, I would like...