Search results

when i select id from combo box and run query not shown the record in form in query

yes problem in combo box and query EmployeeQry the query depend on combo box in form Employeefrm when i select id from combo box when run query not show the record

good day members i attach database- my problem in form first i create combo box when l select THE id FROM COMBO BOX and run query not found record second when i open form my combo box is not value i want when open form value equal the current id record in form very thanks members what is error

I'm sorry I can't explain what I want. if i enter any jobs not between this jobs"Teacher;Doctor;Nurse;Engineer;Judge" i want create conditional formatting to new job or any error when i write the above Jobs many thanks

i want to conditional formatting to column A:C based jobs from c2:c6 , i attach file to example

last request can you change the query qrypension to form frmpension that is It better many thanks nice to meet you

Wishing you peace

many thanks for you last request can you change the query qrypension to form frmpension that is It better many thanks nice to meet you

this error display and query not work because employee number 1 was born in 1/1/1910 +50 = 1/1/1960 not work in query

thanks for you and i hope on request two i want show message box tell me how many employee reach date of pension and create query this employees

any help for me i'm beginner in access pls

i want to calculate the date of pension from (birth date + 50 years) auto when i open {Employee From} and Show Message box to count Employee reach date of pension not i attach simple database to example

count student according to level In front of the teacher in sheet compare

I attache simple file and my request in data sheet count student according to level In front of the teacher in sheet compare copy all student in Special teacher in your under sheets

thanks and l like also repeat head title in other columns in page i insert jpg for problem i draw yellow circle for title

many thanks for members to help i attach student database and jpg to page from report i want insert column in page 2 in page 1 beside column in page 1

nots i set date less then or more then to anther grouptraining

error display in table also i attach image from table

i create update query to update fieldname DateOfTraining to 1/1/1999 but display error in query Group_A 30/12/1899 where error i attach simple database

thank you last question how How do I alert a user to click the id not any filed in the record or how i opening enterdata when user click any filed in record as id filed in this exmple end many thanks