Search results

I have several text boxes containing calculated data. Many of them will often be null or zero. How can I save space by making them go away unless there's something to show?

oh! then how to update if individual filed on Null

Hi everyone, I have a query name Qnull which suppose to put values in the filed as Zero if null the SQL is UPDATE sbicmp SET sbicmp.CGHS = 0, sbicmp.IT = 0, sbicmp.CGIES = 0, sbicmp.GST = 0, sbicmp.RENT = 0, sbicmp.MISC = 0 WHERE (((sbicmp.CGHS) Is Null)) OR (((sbicmp.IT) Is Null)) OR...

Hi Sir,,,, I have Table name TblBooking containing fileds Chqamt, GST, IT, Rent, Code_Head, FINANCIAL_YEAR, SECTION Is it possible to display code_head wise records on section of month , fINANCIAL yAER AND SECTION OF DEPARTMENT like Code Head SOMETHING Chqamt 5000 GST...

3075 is syntax error COMFY IS COMBO BOX CONTAINS YEAR I NEED TO FILTER OUT WITH THREE CRITERIA THAT'S WHY TWO--- AND

Me.TALLOT.value = DSum("allotment", "allotment", "[UNIT_CODE] = '" & [COMSC] & "' AND [CODE_HEAD] ='" & [COMSNG] & "' AND and [finyear] = " & [COMFY]))) UNIT_CODE is a text field CODE_HEAD is a text field finyear is numeric field i am geeting error 3075

Thanks a lot I got it now.

THANKS I HAVE REMOVED THE RECORD SET AND ITS FINE... PLEASE HELP ME OUT IN THE SAME LINE IF HAVE ANOTHER CONDITION LIKE MONTH CONTROLLED BYCOMBOBOX COMMNTH CAN IT BE DONE ... I MEAN CAN IT BE DONE WITH THREE CONDITION (THE FIELD IS A INTEGER LIKE 1,2 3 AS JANUARY FEBRYARY)

I am using the code below: getting error (3021) no current record" Click event: Dim sql5, Sum Dim FIN, CODE As Long Dim MAS As String FIN = Me.COMFY.value ' NUMBER CODE = Me.TXTUC.value 'NUMBER MAS = Me.CMPM.value 'TEXT Dim rs As DAO.Recordset sql5 = "SELECT * FROM [TOTAL CMP] WHERE...

category (in qry ECS) data type text finyear (in qry ECS) data type number yes both are on the same form

the text box rmain blank

thanks ....its fine but if I want to put a condition where the financial year is controlled by a combo box "COMFY" and category of expenditure as "COMCAT' is it feasible. I was trying with the code: Dim Sum Dim rst As DAO.Recordset Dim qdf As DAO.QueryDef Set dbs = CurrentDb Set qdf =...

Hi all I have a form "Linked DV" where i want to display the Total expenditure on a text box TXTEXP from the table "ECS" having a field "Chqamt" after clicking a command button CMDEXP. is it possible to do using record set.

My login form becomes inactive for correct login ID and password. for entering incorrect ID and password it shows error message but while entering correct password and Id command button does not work. I am not understanding. it was working fine.

Thank you very Much... Now I got it This forum is wonderful... Have a safe day

Me.TXTUC.value = DLookup([Unit Code], "UNIT", "[unitid] = '" & CMP001 & "'") I am using the above codes to get the [Unit Code] where unitid is a string character "CMP001" but flases error

Is there any method to fire a Append query that will append duplicates

Thnaks Shan ...with DSum its working fine

thanks.... the sum get displayed sum time but late display... i.e update does not takes place immediately.

No there is no null...