Search results

I really believe you ;)

Thank you, but the number of fields is not fixed

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

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%

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...

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

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...

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

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...

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

Sorry; I didn't get your point.

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...

Great Job. Thank you Very Much

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...

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...

I have table (tbl_Date) contains two primary keys (Date & shiftID), I designed a search function and the results will be display in combo box, but if i selected one of them the form will not go to the selected record. the error in the following code:- Private Sub cmbSearchList_AfterUpdate()...

Really I want to thank all of you, The following code is written in the query in field "Field":- IIf([Forms]![FrmRepEmp]![Txtdatfrm] Is Null Or [Forms]![FrmRepEmp]![TxtdatTo] Is Null,True,IIf([master]![Date_of_Emplo] Is Null,Null,IIf([Master]![Date_of_Emplo] Between...

Thank you, but I have one date field (employment date) only.

Hi All, I want to create a query to display the records based on the date range that entered on a form, this form contained two parameters 1- Employee location , 2- date of employment (from date .... To date....) I need to display the employees records who were employed within the date range...

Thank you, it's working fine.