Search results

  1. C

    Opening forms for different users!

    Thank you so much for your reply, I think I understand it! I do have a couple of questions though - on the Login code, where does it say that if the UserAccess is this, then open this form, if it is that, open that form? And also, what exactly needs to be on the switchboard form....I'm not...
  2. C

    Opening forms for different users!

    I'm using 2010 - I can't figure out how to do it, other than duplicating the forms to give me two trails, which obviously isn't very productive!
  3. C

    Opening forms for different users!

    Hi, I don't know if anyone can help, but I have an access database with three main user groups. They're all similar, but I want to be able to hide certain information from certain groups. I'm looking for a piece of code, or macro, so that when a user clicks on something, depending who they...
  4. C

    Multiple Logins

    To be honest, I'm a total novice and the coding is going completely over my head! The code I've got is this, but I doubt its right! Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box If IsNull(txtUsername) Or txtUsername = "" Then MsgBox...
  5. C

    Multiple Logins

    For some reason it still doesn't work! I don't get an error message or anything, nothing happens when I click the button.
  6. C

    Multiple Logins

    If I'm using the CASE statement, what do I need to use to check usernames and passwords? Thanks!
  7. C

    Multiple Logins

    Thank you for your help, but I'm struggling to understand it all! I can't seem to make the existing code work, so I'm trying AusDBGuy's suggestion of splitting the table into users and departments.
  8. C

    Multiple Logins

    Hi, I'm a total novice when it comes to code, and a colleague helped me out with this! The code I'm using is: Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box If IsNull(txtUsername) Or txtUsername = "" Then MsgBox "You must enter a User...
  9. C

    Multiple Logins

    Hello, My previous query was solved brilliantly on here but unfortunately now I have another! My database currently has three logins, one for "research", one for "admin" and one for "service", and depending on which is logged in, a different form opens next. I'm now looking to expand this to...
  10. C

    Using Logins to populate tables/forms

    I think I've solved it by making the default value the username from the invisible login screen. Thank you for you help!!
  11. C

    Using Logins to populate tables/forms

    Brilliant, thank you! I THINK I've got it working, but no matter what I try, the name to select always appears in a combo box, rather than being automatically added. Is there anyway to stop this? Thanks again helping, I think I'd be here all day otherwise!
  12. C

    Using Logins to populate tables/forms

    Hi, I'm a total novice when it comes to using Access, but I'm making slow progress! I'm using 2010 and have created a database with two main functions - one is to add records and the other is to view records. There are 5 users adding records, and at the moment they all use one login, and then...
Back
Top Bottom