Recent content by Pop_Access

  1. P

    Deactivate the DB after certain days

    I intend to create a trial version of DB, and I want to deactivate the DB automatically after certain days. Is there an idea.
  2. P

    Calculate Percentage without Empty Fields

    Thank you for your advice regarding using "&" instead of "+" I multiply by 100 to display the result before the comma, then I used ",2" to display only two fractions.
  3. P

    Calculate Percentage without Empty Fields

    Thank you for your Idea. the problem has been solved by using the following formula:- =FormatNumber(Sum(Abs([Evaluation]>=4.5))/Count(Evaluation)*100,2)+" %" Thanks for All.
  4. P

    Calculate Percentage without Empty Fields

    Great job; It was very easy😎
  5. P

    Calculate Percentage without Empty Fields

    I would like to share with you what I did, I wrote the following code in unbound textbox in the report footer:- =FormatNumber(Sum(Abs([Evaluation]>=4.5))/Count(*)*100,2)+" %" but unfortunately, I can not exclude the empty records if any in [Evaluation] field as I want.
  6. P

    Calculate Percentage without Empty Fields

    I really believe you ;)
  7. P

    Calculate Percentage without Empty Fields

    Thank you, but the number of fields is not fixed
  8. P

    Calculate Percentage without Empty Fields

    sorry; this field should be empty, but to keep the row, I wrote the text "Afgf" with white color
  9. P

    Calculate Percentage without Empty Fields

    Hi All, How I can calculate the percentage for a numeric field in report with the following conditions: 1- field is not empty (Contains value). 2- if the field value >= 4.5 For example:- Mark 10 0 Afgf 7 3 the percentage should be (2 (10 and 7 >=4.5)) / (4 (not 5)) = 50%
  10. P

    Solved Finds records using openrecordset

    Thanks for All; @Pat Hartman You will find the answer in the following post: https://www.access-programmers.co.uk/forums/threads/how-to-add-a-checkbox-on-a-continuous-form.315623/#post-1741806 at that time, the DB allow me to send ONE Email to the selected employees, now I want to send a...
  11. P

    Solved Finds records using openrecordset

    Thank you. But I need to send an Email for each of them.
  12. P

    Solved Finds records using openrecordset

    I have already used your idea before, but (Access) identify the employee Name and Email for the first ID and then iterates the same number (first ID) infinity with different course name. This is my code:- Set db = CurrentDb Set rs = db.OpenRecordset("SELECT tbl_Student.stuID...
  13. P

    Solved Finds records using openrecordset

    thank you for your comment; you are right. the IDs in a textbox NOT in a label. I edited the post
  14. P

    Solved Finds records using openrecordset

    Hi All, I have a group of employee’s ID numbers in a textbox with “,” between each ID number. I want to open a recordset to find the matching employee name and Email from (tbl_student) table. for example, in the textbox, I have (358,258,4025), I want to find the employee name and email for each...
  15. P

    Solved Display max value from two column with all columns

    Thank you for your comments, you're right, I'm learning new ideas from you all. Sorry I'm not a programming expert but it's a hobby. :)
Top Bottom