Search results

  1. A

    Country drop-down list

    Thanks everyone for the replies and thanks for the table Catalina! :)
  2. A

    Country drop-down list

    Hello everyone, I am back (again). I have a form (Create Guest). Employees can add guests and fill in the details. There is a label Country that Employees can fill in manually. The problem now is that this is very fault sensitive (people type: "The Netherlands", "Holland" or "Netherlands"...
  3. A

    Redirect role to specific form

    Thank you very much to everyone for their time and effort. :)
  4. A

    Redirect role to specific form

    Hi, Actually there is a user called "Management" in my case. Is that going to be a problem? It's only used to secure (simple) a switchboard for others.
  5. A

    Redirect role to specific form

    Hi, So I tried a variety of codes but none of them work. Am I in the right direction with this? MsgBox "You have successfully logged in as: " & strUser, vbOKOnly, "Login Successful" if strUser = "Management" then DoCmd.OpenForm "frmManagement", acNormal, "", "", , acNormal Else...
  6. A

    Redirect role to specific form

    Hi, I've created a log in system with a tutorial I've found on YouTube. It simply redirects users to a specific form after a successful log in. Here is the code: Public Sub Login() On Error GoTo ErrorHandler: If IsNull([cboUser]) = True Then 'Hier wordt gechecked voor de...
  7. A

    Question Looking up information and fill in form

    Just one last question: I have a form with a Listbox at the moment that automatic fills my Guests (Full name). But what work-around do you recommend when there are two names that are the same. For example: I have two guests with the name 'Michael Jackson'. The list automatically grabs the...
  8. A

    Question Looking up information and fill in form

    Sorry for the late reply. The wizard you advised worked very good. Thank you :)
  9. A

    Question Looking up information and fill in form

    Hi everyone, I am a beginner when it comes to Access and just started to play around with a small database. I have a form, "Update Employee Information" that allows me to navigate through records and change data like name, adress, etc. I would like to know how to create list (or autofill) so...
  10. A

    Autofill form

    Sorry for the bump but I would like this too. I created a form "Update Guest" with some basic guest information. I have a guest ID and would like to only fill that so that the rest of the form will be automatically updated. Thanks
Back
Top Bottom