Search results

I also stroke some errors like this. But 1/9/1434 should not be 10/7/2013, it should be 9/7/2013 and appears 8/7/2013. But 1/11/1434 should be 7/9/2013 but result appears 5/9/2013. I tested 1/3/1434 should be 13/1/2013 but appears 12/1/2013 and hijri months 5 , 7 , 8 , 9, and 12 also one day...

Thank you pr2-eugin, I got it what I was looking for. It works fine. But one thing... I found it that it works in a definite query. If I use it in qryBonatti, it works in that query. But for another query, need I create another module? or how can I use it in all queries? Could you please write...

Many thanks to Mr. Plog....

Great! You understand it. Now every time if I print the report, I use to export to excel sheet and reset the SN to continuous number so that my boss can read how many IDs and which number etc. Because my boss wants the continuous numbering in the report. Exporting to excel sheet is so much time...

jseverado, I learned PK and FK from this link. It is better to read it will help you more. http://rogersaccessblog.blogspot.com/2008/12/what-is-primary-key.html Best of Luck

Oh Plog, There may be some misunderstandings. I want to upload a screen capture here. please analyse it. The SN field from table can be hidden. But I want a field with continuous numbers starting from 1. for ex: 1, 2, 3, 4, ..... and not like 4, 7, 45, 153, ..... When we bring autonumber from...

Thanks a lot Plog, for a quick response. The questions you asked arise me too. I know to put autonumber in table. But I don't know how to do it in qurey. I want to filter the names of employees who got the specific ID cards, where empName is from tblemployeedetails, plant from tblplant and...

Dear All, I don't know how to express this problem. I am not expert in vba. just learning a bit. I got some code like this: Public wANum As Long Function GetAutoNumber(EmpNAME) As Long wANum = wANum + 1 GetAutoNumber = (wANum) End Function I created a module from this code. It seems like...

Thanks a lot. But why do you not write this code in International language? I mean it is so difficult to understand what is there!. And I tried your code but not successful. Sorry. and Thank you again.

Dear rod, Thanks for a quick response. But if they forgot their password, how do they reset password? I mean I want to give the right to change their password themselves. hope to your response. Tamangspace

Hello guys, I created a login form using the below code. I got the code in this FORUM. thanks for you all. It works perfectly. I don't know how to create codes in vb. I started to read through this forum and learning a bit. Now I want to create another login form. It would work...

Hello World, I have a table which includes field "ExpireDate" based on Gregorian Calender and another field "ExpireDate_Hijri" based Hijri on Calender and a form based on that table. I am using an app "AlHijri" which converts Gregorian to Hijri. Now I am feeling so boring to convert dates as...

Dear G37Sam, Thank you so much for your help. But I want the form open other details of the employees like his date of birth, passport, Id card numbers and expiry dates etc. Sorry because I am a beginner only and learning ms access from Internet. 4 different companies work at a same place and I...

Hi all, I don't know how to express my problems as it might be a simple issue. because i am new to ms access. I have created tables as: tblCompanySelector, tblEmployeeDetails, tblSafetyDetails, and tblIDCards. Relationship is as tblCompanySelector to tblEmployeeDetails, tblEmployeeDetails to...

Dear Jdraw, Thanks for your help. I explored some of your links and read and practiced. It was so helpful to understand ms access for me. Even now I'm opening your links. Thank you so much. Santa Yanbu, Saudi Arabia.

Hi all, I am working in Faisal S. Al-Naimi Est. Yanbu, Saudi Arabia. This Company has own employees and hired employees from another 5 companies too. The employees has many ID Cards like Aramco ID, Yansab ID, Yanpet ID, Marafiq ID and many other site IDs. All ID cards have expiry and must renew...

Hi all, I am working in Faisal S. Al-Naimi Est. Yanbu, Saudi Arabia. This Company has own employees and hired employees from another 5 companies too. The employees has many ID Cards like Aramco ID, Yansab ID, Yanpet ID, Marafiq ID and many other site IDs. All ID cards have expiry and must renew...