Recent content by Safaa

With db.OpenRecordset(sql, dbOpenSnapshot) GIVE ERROR HERE

First of all, sir, I thank you for following me and helping me. When I put this part in the code(Me.Visible = Me.HasData), the sup report disappears if there is data. I also want it to disappear if there is no data (records) and its height is 0.

I think he counts all records with the same date as one record

Private Sub Report_Open(Cancel As Integer) Dim sql As String Dim thNo As Variant thNo = Nz(DLookup("TH_no", "settings_general_tbl"), 1) ' تحقق مما إذا كانت قيمة TH_no صفر If thNo > 0 Then sql = "SELECT TOP " & thNo & _ " CBC_tbl.Tdate...

It works well, but there are two errors. If the field value is equal to 0, the program closes suddenly. Also, When I put in field number 1, two records appears

Thank you very much. I want to hide the subreport when there are no previous visits It works well, but there are two errors. If the field value is equal to 0, the program closes suddenly. Also, if there are two visits on the same day, it is counted as one.

any one can help me for do this?

I have a report with a subreport inside it. I want to limit the number of records displayed in the subreport based on the value of a field named TH_no In a table called settings_general_tbl For your information, this sub-report reflects the patient’s history I want solutions, I don't want...

Thank you very much for your attempt to help. I really tried to apply it, but I could not. Is it possible to modify the file if your time permits?

Make the code work in one or two lines and I will complete

I have one and only question: Can you do what I asked? If you cannot, then leave the opportunity to others. I did not ask for advice on my project. All I asked for is this. If you do not know, there is no shame in saying it.

It is certain that I have a data entry form, but I did not attach it to the base because it is not important. I think I have made my request clear and there is no point in asking too many questions.

When the analysis is only a blood picture, the distance between the lines can be widened or left as it is, but when there are other tests related to the same analysis, the distances can be narrowed to print them in one report. I saw it in one of the programs and I would like to do it.

When the additional spacing is simple, we will not need two pages The picture belongs to a person in an Arab forum who offered the solution for some money. I want to control the spacing between the lines. Can you do it for me for free?