Recent content by hsusmani

  1. H

    I want to get values from different tables depending on the combo box

    Thanks Paul. Its working the way I want. There is one more thing I wanted to ask. Until now, there were two combo box. One depending on other one. Now there is another text field I want to update depending on the 2nd combo box. On load of the form, If I am changing the 2nd combo box, this text...
  2. H

    I want to get values from different tables depending on the combo box

    I am kind of new to access and learning... I have got a form where I have a combo box where names of companies are listed. there is another combo box where its branches are listed. So, One table is holding the company names only. 2nd table is named after that company and have all the branches...
  3. H

    I want to get value from the text input and dlookup of that and retrieve the data

    Hi, I have set the text field with the button through dlookup. Once data is found, it says "name already exist". Until here it is fine. Now what I want to do is... get that input from the text field which is entered by the user and do dlookup of that data... and get to that record in the same...
  4. H

    Trying to add admin rights function in the login form

    Thanks Paul. I was struggling with this simple one. There is one more problem now. The last "else" code seems not working properly. Instead of returning message in status, its showing error saying "invalid use of null". Otherwise its working as I want it to work. Here is updated code On...
  5. H

    Trying to add admin rights function in the login form

    Bro i think i was not clear. Please look at my code. What i want is simple. Once user puts username and password... Username matches.. then it should look for the column adjecent to username and password... Which will then return either of the two pages depending on the right of the user.
  6. H

    Trying to add admin rights function in the login form

    Thanks pbaldy for your reply. Yes that is what i want. Can you update my code and give me an example. I am actually new to ms access. And yes i just want someone to have password
  7. H

    Trying to add admin rights function in the login form

    Hello everyone, I am looking for a solution to this problem. My user login form is working perfectly fine. Table of reference is called "TBL_user_detials" in which columns refeered to are "UserLogin" "Password" and "Rights". Presently, Once I put the username and password which matches against...
Top Bottom