Search results

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

Hey thanks. Having selection criteria lower down in the multiple sub-queries does mean you have to amend all of them though, whereas if its in the main top query you just have to amend it once.

I have written a query to calculate how many hours we have worked for our clients. This has a number of sub-queries which sum to make different columns in the main query ie: Hours invoiced so far, Hours to be invoiced, Hours remaining from their allocation, etc. I am refreshing the queries due...

mmm.. be nice to have an answer/suggestion to this one. :cool:

Neil, you're a genius. Thank you. Why didn't I think of that? - putting Contact on tblClientRegulation.. Seems so obvious now - lol :D

I have 3 tables: tblClient (our Company customers) tblContact (people who work at the Companies) tblClientRegulation (1 or more types of Regulation that the Company is obliged, by law, to comply with) Relationships: tblClient - tblContact: 1 to many tblClient - tblClientRegulation: 1 to many...