Recent content by smtazulislam

Thank you so much for reply. Yes, you are right for Europe Visa processing like that. But Middle East (Arab Country) work visa is little different, and some condition added here. First time we applying for work Visa to govt. office. After that they're review company work and projects then...

Thank you so much for reply. I want to see in the form1 when I enter Visa Numbers that show me as : * How much visa we Authurised to company and country name ? * How much visa we have still balance ?, which category is balance ? But i don't know how to display this..... Also down need to show...

Thank you so much for your time and reply. Actually, before I used it by Excel Sheet. seet attached excel screetshot. But I now really want to a database to completed this process. For that Just import first excel file that some edit. So that maybe somewhere have mistake. Please dont leave. I...

Thanks for your reply. How can I do it, Because a visa numbers have many coutries and different visacategory available. See the VisaDetails Table screenshot. VisaDetails VisaDetails VDID VisaID Country Approval City Category VisaQty 1 1301652881 India Mumbai عامل تنظيف مباني عامه 44 2...

I am working HR dept. and we have govt. approval visa for hire worker from 11 countries right now. A visa numbers have different category and defferent country. In this visa for stamp in the worker passport, we give authorise a local an agency. and Visa work processing all of the cost is credit...

Thank you so much Mr. Mike. I appreciate for your nice job. It is help me to learn this part.

Employee Table is updated. and go to first data record. Not stayed what Employee department I changed. ex: if I change departent into employeeID - 5. And when I click the btn Update Table. then its go to the employeeID - 1.

Thank you so much. I appreciated. Here have a problem, When I click to Update Table button Its bring me first record not stay same employees. can solve this issue please.

Please do it I need this one.

appreciated for your nice advice. can you talk, if I insert a button CmdUpdate table like below example. Can possible. I thing this needs a RUNSQL to change statement in table tblEmloyee. DTID EmployeeID TransactionDate NewDepartment TransferDate 1 2 01/12/2020 Maintenance 15/12/2020...

I want transaction history recored as like that: DTID EmployeeID FromDate PreviousDepartment NewDepartment ToDate 1 2 01/12/2020 Finance Maintenance 15/12/2020 2 1 05/12/2020 Finance Projects 18/12/2020 And when the employee go to NewDepartment then it is also change in the...

Yes, Mr. Mike. my manager want like that.

Its not same what the client needed. tblEmployee table I have deptID. what is the employee joining date day we given him. you delete the deptID Column . You JOIN to department table. but must be have tblEmployees table in DeptID Column. Because, tblemployee in connection deptID many table &...

Please check...

Hello Mr. Mike, Thank you so much. As your instruction I create new TABLE - DepartmentEmployees Then....