Recent content by Jamaluddin Jamal

Thanks. I solved it with DateSerial function.

Hello all, I am looking for a method to get No of Days (Count of Days) in a given month., like, if someone enter May 2017 in a first textbox (textbox is set to display Date as MMM YYYY format), the second textbox show the result, 31. can any one help to get this, Thanks in advance.

Post is considered SOLVED for me!!

Yes, I want to hide the Access Application windows.

I think I missed something. I want a Form to be filled Whole Screen like individual application, and the Access Windows be hide from users. Only Main Forms with all Child Forms (in Pop Up/ Model property yes).

It looks like an issue with combo box record source, check out this my solved issue about combo box record source.

Hello everyone. Is there any way to create a full screen form, like MDI. I used a method earlier in which form covered whole screen including Task Bar.

Hello everyone. I am working on the form having Tab Control for different "Categories". The tab, say Category 1, contains 2 Combo Boxes cboType and cboID. by selecting Pay Type, cboID only shows all those record (or Emp ID) whose Pay Type is selected from cboType. I used the following VBA on...

Thanks Ridders, its working... :)

@Ranman256, situation is same :banghead:, can you please check it with the database file I attached.

Already goes through this way, but the Access responded "Your query does not include the specified expression 'EmpID' as part of an aggregate function."

Already goes through this way, but the Access responded "Your query does not include the specified expression 'EmpID' as part of an aggregate function."

I have two tables, tblEmp and tblEmpPositions. tblEmp has fields like EmpID, EmpName, EmpFather and EmpDOB. tblEmpPositions has fields like PositionsID, EmpID, EmpDesign, StartDate and EndDate. Scenario is 1 Employee worked on different Positions for specified period of Time. What I want to get...