Search results

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...

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!

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...

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...

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

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

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.

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...

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...

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

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!

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...