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...
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 (...
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...
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.
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
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 &...
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. )
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...