Search results

  1. I

    Check for duplicates before running append query

    All right Thanks man, it looks similar to the code I'm looking for. Regards
  2. I

    Check for duplicates before running append query

    Thanks for your prompt reply, query wizard of duplicates will check duplicates of one field in the table.It does not give the option of comparing multiple table and fields. Regards
  3. I

    Check for duplicates before running append query

    Hello, I have qryDistReg which it filters the data from tblDistReg, then I'm appending the filtered data to tblDistRegData. As am appending the data one monthly basis, I want to check the data of tblDistRegData before running the append query/code. I'm using the following code to check for the...
  4. I

    Remove Filter from a Subform Issue

    subfrm_WO_Status_Form.Form.FilterOn = False
  5. I

    First Date of selected month

    Yes, I fully agree with you, just after reading your reply, I got the missing point and I managed to resolve it. it's about the If statement that I'm using. I have removed it, and as I'm calling the function in the after update event this will ensure that dtmDate value will never equal Null or...
  6. I

    First Date of selected month

    Hello, I have the following function to return the first date of the selected month, which it's getting the value of the selected month from txtDateOfPlan. apparently it's returning the first date of the current monthly what ever the selection is. Your kind support please Regards Function...
  7. I

    Filter subform with cobmo box columns, based on textbox value

    Thanks arnelgp it works like nothing, I was just confused with Dlookup Apology for the inconvenience made Regards
  8. I

    Filter subform with cobmo box columns, based on textbox value

    Still not filtering by DistrictName By the way the If (Condition) has Syntax error not same as per the defined variable. I have corrected it but still not achieving the required result. Once a gain thanks for the initiative
  9. I

    Filter subform with cobmo box columns, based on textbox value

    Thanks arnelgp for your prompt reply, but the code you have posted is giving the same result the code that I my code above. Here are more details and clarifications on my current case. Districts Table: District DistrictName 1 Ankwa...
  10. I

    Filter subform with cobmo box columns, based on textbox value

    Hello, I’m using the following code to filter subform in main form, my subform source object is based on query, and there are some columns of the subform has relationship with another table, as you see in the below code it’s related to district table, and I’m using lookup to display district...
  11. I

    Database Designing - ER

    Thanks for the initiate, I have 5 areas keeping their details under tblArea, I’m delivering some houses stuffs to these areas one time on monthly basis, I’m keeping the information of the houses that are receiving these stuffs in tblHH, may contacted vendor those whom are providing/delivering...
  12. I

    Database Designing - ER

    Hello, Please your advice on the attached relationship,most of my transaction depends on AreaID, it's good bad? what is the way forward and what is best practice that I can follow? Regards
  13. I

    Update Table column with dates based on From - To Value plus filtered location

    Thanks for the initiative. I'm attaching sample database this so far what I manage to do, the cmdUpdate is to update both ReceivedDate and MothOfIssuance columns under tblMontlhlyData, it needs some queries which I fail to do it. hope I'm not make confusion or mixing up the thinks. Regards
  14. I

    Update Table column with dates based on From - To Value plus filtered location

    Dears, The idea is that I'm trying to update all the records of the table based on From - To numbers, CmdUpdate on Click Event to update the table, please note that I need to filter for certain location before updating, and previous month data to be kept so where in another table for future...
  15. I

    CheckBox for Subform that allow user to select record

    Easy way is to go ahead with yes/no field. Thanks
  16. I

    Check for Unmatched record

    I tried to attached the image but I'm getting error message I have uploaded the picture to my drop box. Regards https:/www.dropbox.com/s/7v08l04jji11h32/Table%28A%29%26%28B%29.JPG?dl=0
  17. I

    Check for Unmatched record

  18. I

    Check for Unmatched record

    I tried but it's does n't work, I'm attached the image of the two tables, hope it's self explanatory. Regards
  19. I

    Adanced Login Attendance

    Hello, I'm looking for advanced login attendance to my database, that records user login date/time, appreciate if a can get a data base sample. regards
  20. I

    CheckBox for Subform that allow user to select record

    Hello, The idea is that I want to add a check box to my datasheet which it's placed in a sub form, to allow user select only one or multiple records which it's help me a lot for validation, submission, deletion,& approving of the records. Regards
Back
Top Bottom