Search results

  1. C

    Dlookup error message??

    :banghead:Hello to every body; I have a question regrad to Dlookup() functio; I Have this =DlookUp("[Esti-Time]",“K-Sumary-Time-V2", "[AssemID] = '" & AssemID & "'"). but i got this message You may have an Operand without an operator. thenk you for you help Calucho..:confused:
  2. C

    #error in the field of my Report

    Hi I try to do these formula but I never got the rigth value: just the #error in the field that I wnat to put the value. I use CDbl function and Val function but nithing. =IIf([Flag]=1, CInt(Count([code])) /DLookUp("[1-Accept] )+ CInt(Count([code]))", "Value Query", "cdbl([E-Date]) =...
  3. C

    Apply Color, Underline font in a row with some Condition??

    Hi, I would like to Apply a font color underline font to the Row of field with an If condition. How I can build the IIF statement that change the font in my reports. IIF(Flag]= "G",??????????). or there are another solution to do this please can you advice me how to do this. Thank you Calucho:mad:
  4. C

    Whst is wrong with this DLookUP function???

    hi; I create a report and I try to use the DlookUp function; I have a table (Values_T) [ID], [Accepted], [Reject], [VL100], [Vl600], [E-Date] in my reports I have field txtCalc I try to brinf the value of [VL100] to my report and make some calculations, and it is the function...
  5. C

    Counting time and show the subtoal in the Form??

    hi, I have a form to enter the hours of work for employee; I want to know how i can add these values each time that i enter the information in the form and the same time show me in the form the total of hours entered. These means have a counter of hours and show the subtotal on the form. Thank...
  6. C

    What is wrong with my IIF Statement??

    Hi, I have this problem with the iif statement =IIF([Flag])=6,"M6000","M1000"):eek: the problems is on my table I have flag 1 and 6; but when i run a report in some Range of date it recognize the flag =6 and flag=1; but in some ranges of date does not recognize the flag 6; just recognize the...
  7. C

    Start in the first position the cursor!

    Hi; I have a form for Data Entry in access 2010 I want that the cursor come back at the first position of the field on my form whe I finish to enter the information. theree is a option for these?? Thank you for you help. Carlos
  8. C

    Question How Omit Zeros From The Average Function Formula

    Hello; Some body can tell me how Omit the zeros from the average function formula so I can get the accurate average of my values. Thank you for you help Carlos
Back
Top Bottom