Search results

  1. T

    Filter subform with call criteria

    it did not work, i need to filter the subform bases on 2 criteria.
  2. T

    Filter subform with call criteria

    Dear guys, Need help, 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/ Please feel free to Remove this Comment ; ;; ;;; I draw...
  3. T

    Solved Dcount with 2 criteria.

    thanks alot but how to add the second criteria [Location - Clinics Name]
  4. T

    Solved Dcount with 2 criteria.

    tried tis but still got syntax error Text17 = Nz(DCount("*", "[MRN]", "[Date_] between #" & [Dates_From] & "# _And #" & [Dates_To] & "#"), 0)
  5. T

    Solved Dcount with 2 criteria.

    Dear guys; need help, i have a form to count the number in record by 2 criteria. i tried this but not work, Me.Text186 = Nz(DCount("*", "[MRN]", "[Location - Clinics Name] ='" & Me.Combo2 & "'" & "Date_ BETWEEN DateValue('" & Me.From & "') AND DateValue('" & Me.to_ & "') ), 0) so what to do.
  6. T

    Show all record in combobox

    what to write in FieldName],
  7. T

    Show all record in combobox

    i tried on query but does not work.
  8. T

    Show all record in combobox

    Hi Guys need help i have 2 combo box, if combo 1 updated will automatically filter combo2, but wanna if combo 1 is null then show all record in combo2. i tried this code in query but not showing all record. Nz([Forms]![Master_List]![Combo46],"*") so what to do.
  9. T

    Solved Disable edit but allow filter

    work succefully. thanks i tried but did not work
  10. T

    Solved Disable edit but allow filter

    i tried but same issue
  11. T

    Solved Disable edit but allow filter

    Dear Guys I have a form that has a combox to filter the record, but on load i want to disable deletion , addition and edit. so when i did the below code it disable every every thing even filter. just wanna able to filter the form. Me.Form.AllowAdditions = False Me.Form.AllowDeletions =...
  12. T

    Solved Saving Report As PDF on desktop

    HI i wanna save a report as PDF file. but always get Error; invalid folder path, i tried Dim fileName As String, fldrPath As String, filePath As String Dim answer As Integer fileName = "Member Contact Details" 'filename for PDF file* fldrPath = "C:\Users\Default\Desktop" 'folder...
  13. T

    Solved Show all record in query

    sorry i mean to show all record in query if nothing selected in combobox, form name list [Combo2]
  14. T

    Solved Show all record in query

    [Forms][Combo2]
  15. T

    Solved Show all record in query

    this i tried [Forms]!![Combo2]
  16. T

    Solved Show all record in query

    Dear guys wanna show all record in query if no data selected in combobox. i tried this but do not know how to do it with NZ. [Forms]!![Combo2]
  17. T

    Solved count No. of record in table

    Dear Guys; I wanna count number in record in table after combo box update, i tried this but got error . Me.Text26 = Nz(DCount("*", "[MRN]", "[Location - Clinics Name] Like ""*" & Me.Combo2 & "*""), 0
  18. T

    Lookup from query

    What is "MRN" and "Combine" data for? both are separate table from different source, so i have to linked the data in order to get required information.
  19. T

    Lookup from query

    can you please guide me as i uploaded the file.
  20. T

    Solved Filtering Query between 2 date

    Dear Guys, Need help i have q query having a date range 1- Date_From 2- Date_To so wanna show the record from current date which are present between both date.
Back
Top Bottom