Recent content by follower2020

  1. F

    Copy some pdf files to another folder

    Hello we have a record for each patient each patient will have patient number my co workers prepare the documents needed , get them signed and then they scan in order to email them when they scan , they name each file this way : the patient number then some description e.g.1255 GOP...
  2. F

    Solved moving files using partial names

    Dear ebs17 Great. Thank you for your assistance. I have tested it.
  3. F

    Solved moving files using partial names

    hello everyone If i have many pdf files with names say : 999 jane 999jane 999 jane d I want to move all the files starting with 999 to a specific folder I am getting error in this part : Name "C:\Users\Modhy\Desktop\Scanner\" & Me.Casenumber & "" & "*.pdf" what is wrong with this part (...
  4. F

    Solved calculating gaps or missing periods

    Hello everyone. hope that there is a solution for this in Ms Access. Suppose I have one Patient who has been treated during a period say from 01/01/2021 to 31/01/2021 ( I register these days in my PATIENTS Table in some days during that period of time he has been admitted , other dayshe has...
  5. F

    Search for value in Two controls-Search Form

    I have tried that . its showing some cases that are not related Plus cancer cases . for example , there are many cases with diagnosiscategory1 as "Dental" ( and of course those are with blank diagnosiscategory2.
  6. F

    Search for value in Two controls-Search Form

    you are right. I have tried yours first but it jut give wrong results like some patients under rhematology. don't know why . note that diagnosiscategory2 could be blank is some cases : only diagnosiscategory1 must not be blank
  7. F

    Search for value in Two controls-Search Form

    Dear even that didnt work for me ! but when I used these 2 lines together it work perfect ONLY if all other fields in the search form are left blank ( fields like age , or Hospital name etc ): strWhere = "Patients.DiagnosisCategory1 Like '" & Me.DiagnosisCategory & "'" strWhere = strWhere &...
  8. F

    Search for value in Two controls-Search Form

    Thanks to both of you. I tried this : strWhere = "(Patients.DiagnosisCategory1 OR Patients.DiagnosisCategory2) Like '*" & Me.DiagnosisCategory & "*'" but its not giving any results ! ( it will be caner only in one of the 2 fields, the other could be Ent , ortho ,etc. )
  9. F

    Search for value in Two controls-Search Form

    Hello everyone .. I have a search form that will filter data shown in the Subform. I am dealing with Patients Data which I save in a table. For Diagnosis Category , I am having 2 fields: I use the second field for some cases like cancer in the bones ( so for example , I will enter ortho in...
Top Bottom