Recent content by CrystalSurfer

The CInt([Forms]![frmInvoiceRun01].[cboMonth]) (and Val) gives me the 'too complex to evaluate' error. Although it runs perfectly well as a standalone query.(?) Even stripping down the selection criteria to just (Month([A].[DateComplete])<=([Forms]![frmInvoiceRun01].[cboMonth])) doesnt get it...

Point taken Mailman. I'll always try to make things more complicated if given half a chance! :D OK, I've done as you suggested and simplified the criteria as follows: WHERE ( ((C.YearCon) Like fcboSearch([Forms]![frmInvoiceRun01].[cboYear])) AND ((IsNull([A].[DateInvoiced]))<>False)...

The combo is a simple ID, MonthName query over tblMonth with the bound column as ID which is doubling up as the month number 1 to 12. Set as an long int, autonumber. So no problem there I think(!) I am beginning to suspect its my complex IIF statement so will try pulling out it out into...

Oh dear. I spoke too soon. I copied the query into the form source and got a "This expression is typed incorrectly, or it is too complex to be evaluated.." when firing it up. It could be related to the bound selection column which is a simple query and definitely a number. I tried putting the...

It must be Monday morning-itus. I've been testing the CInt() but couldnt get it working until now! :rolleyes: Thanks for your help gents. :)

Hi all, I have created a form that lists work to be invoiced. However I have a problem with the following WHERE clause in the query source: WHERE ( IIF( A.DateComplete is not null, Month(A.DateComplete), IIF(A.Fee is not null, IIF(F.DateSpecific=False, 1...

partially solved.. Hi all, I've solved my problem and am going to explain the solution to it for any future noob-let like me. The problem was how to select all records from 2 unrelated tables and generate a running count or sum for each of the combinations. The answer was to just put them...

Hi all, I have 3 tables: tblMonth, tblRegulation and tblClientRegulation. Relationships are: tblClientRegulation.Regulation = tblRegulation.ID and a fabricated relationship: tblClientRegulation.Month(DateEnquiryRevd) = tblMonth.ID There is no relationship between tblRegulation and tblMonth. I...

Chris, thats done the trick. :) Thanks for all your help! Jules

Thats interesting Chris. I didn't realise Access has its own proprietry rounding methods. And yes, I would ideally like to handle negatives properly in a rounding function although not applicable in this calc as I want the absolute value. Rich, thanks for that calc - I'll give it a whirl..

ah yes, Well done!

How about disabling the button to the second form until text is entered in "txt_Last_Name_from_combo"? That tends to be more user friendly. To do that you have to put this: Me.cmd_Open_Form.Enabled = False into the OnOpen event of your first form then re-enable it when you there is something...

Hi All, I use the following generally available function for rounding. I thought it cured the problem with 'Bankers' rounding which is Access' default method of rounding. But can someone tell me why, when using this function on the value 4.725 it returns 4.72 when it should return 4.73? I am...

Tim, that is a most excellent suggestion. Thanks for your help. CS

I have a number of sub forms managed by a tab control which is on my main Client form. I can enter a new client and complete any of the subforms as required. Most of these subforms are displaying 'child' tables to the main Client table. One of these has a 1-1 relationship with Client. (ie: an...