Recent content by smtazulislam

  1. smtazulislam

    Help a query or VBA

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

    Help a query or VBA

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

    Help a query or VBA

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

    Help a query or VBA

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

    Help a query or VBA

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

    Solved Update two table from one Form

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

    Solved Update two table from one Form

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

    Solved Update two table from one Form

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

    Solved Update two table from one Form

    Please do it I need this one.
  10. smtazulislam

    Solved Update two table from one Form

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

    Solved Update two table from one Form

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

    Solved Update two table from one Form

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

    Solved Update two table from one Form

    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 &...
  14. smtazulislam

    Solved Update two table from one Form

    Please check...
  15. smtazulislam

    Solved Update two table from one Form

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