Recent content by Ihussein

  1. I

    Nest iif multiple condition to be converted to Switch or Select Case

    All right, thank you so much, now it is very clear. Regards
  2. I

    Nest iif multiple condition to be converted to Switch or Select Case

    Hello, I'm using the following code and it's working, by any chance is it possible to have the same very code working using Switch or Select Case might be? using VBA function will be the best option. Thanks CategoryNat: IIf([NoBeneSign]=True And...
  3. I

    Navigation to DS on subform of navigation form

    First of all thank you so much for the code now it's working. yes in my tblRed is shows (ES, NS, WS) as it's more user friendly, but the actual data are numbers. I following this approach as the database size/ speed really matters for me. hope it clarifies, once again thanks for the support and...
  4. I

    Navigation to DS on subform of navigation form

    good afternoon, While I'm trying to reference to a control on from of navigation sub form is show an error message that "Microsoft Access can n't find field referred to in your expression". Once you open the attached db open frmMain then selected Duplicated Red Report from the list on the right...
  5. I

    Duplicated Records

    where clause has solve the issue. Thanks
  6. I

    Duplicated Records

    Good afternoon, Please see attached db I'm trying to check for duplicated record of tblRed based on selected loc name, but apparently it is not working as I want to be, as it is returning all the records of the selected loc name as duplicated records, it seems that it is making the comparison...
  7. I

    Controls of main navigation form are not responding

    I did notice that, it's working now. Thanks
  8. I

    Controls of main navigation form are not responding

    Hello, can you please take a look at the attached db, I have coded my control and are fully function very well in "frmStatesHome", later on I created a navigation form "frmHome" I dragged "frmStatesHome" to "frmHome", then cbo & txt that are suppose to filter the subform are not function. Thanks
  9. I

    Refresh subform in maiin Navigationform

    Hello please see attached db, I'm trying to refresh sub form of navigation form after it adds an new record. but I'm getting error message. Regards
  10. I

    UnMatch Query Multiple Records

    All right I will give it a try. Thanks for the prompt respond.
  11. I

    UnMatch Query Multiple Records

    Hello There, I have two table tblRed & tblDistReg, please see attached db. I'm trying to write a query that return all the unmatch record in tblRed where the DateOfDist of the record in tblDistReg is null. in my attached db the qryUnmatch should return the records as an unmatched: RCNb...
  12. I

    Syntax Error Query - ('Single' "Double" Quotes)

    Mistakenly I was writing my code in wrong way. I suppose to lookup MonthOfDist from another table, then along with lngLocation execute my delete query. I have re-wrote my code and now it's working. Please accept my a apology, I'm really sorry for the inconvenience made and thanks to...
  13. I

    Syntax Error Query - ('Single' "Double" Quotes)

    Still asking to Enter Parameter Value of MonthOfDist.
  14. I

    Syntax Error Query - ('Single' "Double" Quotes)

    I have tried the above code but it is asking to Enter Parameter Value of MonthOfDist. I might need to check the rowsource of cboMonthOfDist? Thanks
  15. I

    Syntax Error Query - ('Single' "Double" Quotes)

    Forms!frmDistRegisterHomeAdd!cboLocationName Integer Forms!frmDistRegisterHomeAdd!cboMonthOfDist Date
See more
Top Bottom