Search results

  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. :)
  16. P

    Solved Display max value from two column with all columns

    Sorry; I didn't get your point.
  17. P

    Solved Display max value from two column with all columns

    As I mentioned above, I want to reach the records with the highest value in col1 First, then the highest value in col2. So, the highest value in clo1 was (11-Oct-21). and we have 4 records with this value, now the highest value in clo2 was (2) for 2 records for Rick and Vera. that's what I...
  18. P

    Solved Display max value from two column with all columns

    Great Job. Thank you Very Much
  19. P

    Solved Display max value from two column with all columns

    I have a table (tbl1) with the following columns:- col1 col2 col3 7-Aug-21 1 Pete 7-Aug-21 2 John 15-Sep-21 1 Don 15-Sep-21 1 Elsa 11-Oct-21 2 Rick 11-Oct-21 1 Betty 11-Oct-21 2 Vera 11-Oct-21 1 Ronald With a query or VBA code, I want to reach the...
  20. P

    Solved Search with two primary keys

    Thanks for all, the problem was that i mentioned the text name (in the form) instead of the field in the table between [ ], so the correct code as below with minimal changes:- DoCmd.SearchForRecord acDataForm, "frm_bed", acFirst, "[Shiftdat] = #" & Me!cmbSearchList.Column(0) & "#" & " and...
Top Bottom