Search results

  1. T

    Solved Date between

  2. T

    Solved Date between

    when i use the code without date , work great but when i add date criteria get above error .
  3. T

    Solved Date between

    i tried this but got error : =DSum("[Link Value]","[MRN]","[Item Code]='" & [Item Code] & "' AND [Location - Clinics Code] =" & [Location_Code] And Year([Date_])=2022) this appear in the field "#Name?"
  4. T

    Solved Date between

    .. .. .. .. .. . .. .. .. .. .. . . .. . .. .. ... . .. .. .. .. .. .. . . .. . .. .. ... . .. .. .. .. .. .. .. .. .. .. . . .. . .. .. ... . .. .. .. .. .. .. .. .. .. .. .. .. .. . . .. . .. .. ... . .. .. .. .. .. .. .. .. .. .. . . .. . .. .. ... ...
  5. T

    UNdo if date is null

    yes its bound to record in data. but i tried before update , the same problem , if i type any number and date field in null it will be added to record.
  6. T

    Solved Add end of the month date after date Update

    Dears; i have a form whrere use add the 1st date of the month in "Date_From" , then i want "Date_To" to get last date of the month automatically, can you guide me. thanks
  7. T

    UNdo if date is null

    Dear Guys; i need a help. i have a form to filter to fill , if user did not select date first and he add any value them , i want msgbox to show text message and cancel the data entered; i tried this but not working. Private Sub TOTAL_PHYSICAL_COUNT_AfterUpdate() If IsNull(Date_From) Then...
  8. T

    Filter form with 4 criteria.

    the code work well, but there is issue that i need exact match. for example if i search for "med12" then it will show all items with "med1" and i do not want this. so how to modify the code to get exact match.
  9. T

    Dsum multiple criteria

    =DSum("[Quantity]","[MRN_Report]","[Item Code] ='" & [New Code] & "'AND [Location (Clinic) Code] ='" & [Location code] & "'") i removed the Date and tried this but still got "Error"
  10. T

    Filter form with 4 criteria.

    I need to filter the form based on code entered into the text. as i have different 4 number for the items. so no result with first field then will search 2nd and so on for the 4 field. is there a way to do it please guide me
  11. T

    Dsum multiple criteria

    tried this got " Error"
  12. T

    Dsum multiple criteria

    i tried this for second criteria : not correct =DSum("[Quantity]","[MRN_Report]","[Item Code] ='" & [New Code] & "' & and "[Location (Clinic) Code] ='" & [Location code] &"'" )
  13. T

    Dsum multiple criteria

    tanks alot, but i need to add 2 more criteria, how to ammend this code for [ Location (Clinic) Code ] match with "Location code" and between {date from and to} .
  14. T

    Filter form with 4 criteria.

    no Error message , just show me blank record.
  15. T

    Filter form with 4 criteria.

    Code Tags Added by UG Please use Code Tags when posting VBA Code Please read this for further information:- https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/ @theinviter ---- Please feel free to Remove this Comment ; ;; ;;; This is not the...
  16. T

    Dsum multiple criteria

    Dear guys, Need help please with attached file , i have tried Dsum but did not get any value. jus getting " #Name?" I need the form "Data_list" where Field " Price1" Dlookup the ([Buy Rate], from Table " Rate_report" where "item code" match with " New Code" Text153 = DSum([Quantity],"...
  17. T

    transfer Data in filtered query to excel

    got compile error in this line : strWhereAdd = Trim(RemoveFormReference(Frm.Filter))
  18. T

    transfer Data in filtered query to excel

    Dear Guys; Need help, I have a data in my filtered form tat extracted form query, and need help on how to convert it to excel sheet in desktop by click on a button with VBa code. thanks
  19. T

    Filter subform with call criteria

    work successfully, issue was with [Account Name].
  20. T

    Filter subform with call criteria

    not working , it filter the form but show blank record.
Back
Top Bottom