How to Create Login Form with Security Type in Access Database

Поделиться
HTML-код
  • Опубликовано: 17 окт 2024

Комментарии • 55

  • @Danyboy50_
    @Danyboy50_ Год назад +5

    How do you connect the UserType table with the User table, you skipped that part

  • @jerzykepinski
    @jerzykepinski Год назад +2

    Man just discovered your channel...this password tutorial is very good!

  • @mrshahi5981
    @mrshahi5981 2 года назад +6

    How did you connect tbluser and UserType table ?

    • @kokolebest95
      @kokolebest95 11 месяцев назад

      Same... He just cut that part it's frustrating

  • @roseannagrimaldi498
    @roseannagrimaldi498 2 года назад +1

    Hello. I want to have a log in screen that triggers a Form based on a query so that the user can only see the records "assigned" to them. is that doable?

    • @joelmorabang4764
      @joelmorabang4764 Год назад

      Did you solve this one already ? Would like to know as well

  • @Eric-qm4vm
    @Eric-qm4vm 2 года назад +1

    Great video! Thanks for sharing. Is there a way to add “forget password” link at bottom of user form? If not, how can user reset lost password? Thanks

  • @rhodnill5906
    @rhodnill5906 3 года назад

    Is it going to work in MS Access 2016? (The Code) the ms access version seems old in the video. please reply Thank you 😇😇

  • @DeltaHotel85
    @DeltaHotel85 3 года назад +1

    Hello, I have a problem with the command ...
    User = DLookup ("NameLang", "tblUser", "Personalnummer =" & TempVars! TempUserID)
    ... I always get a runtime error data conflict in criteria expression. My question is what am I doing wrong. The field data type is short text, with NameLong and with the Personalnummer.

    • @iljanov
      @iljanov Год назад

      Is the "Personalnummer" maybe misspelled "PersonalNumber"? or does that field have an ID?

  • @lauraalexe-f4m
    @lauraalexe-f4m Год назад

    I tried to follow the steps. the first time It works but after I shut down and I want to reuse nothing happens

  • @Figgyinchains
    @Figgyinchains 3 года назад +2

    20:06 when you entered the password you landed on the User Form with TTT's information pulled, not Jsmith. I've tried using this code and one hiccup i'm running into is that no matter which Username I use, as long as the password entered is featured at all on the user table, it will let the staff logging in to gain access to the main menu. Please advise.

  • @jamespeverley3382
    @jamespeverley3382 2 года назад

    I have something very similar to this in my database, but i would like to remove the password so people just type in a username to login, how would this be done??

    • @uuzgan
      @uuzgan 2 года назад

      hello
      add 'a tickbox label: 'Remember me' to the form
      add a field 'computername' to the user table
      find a code to get activeuser's computername from inyernet
      on_click event of OK button (after password check) add comp nane to created field
      on_load event of the login form, if comp name field iş not empty and equal to the active user comp name, log in automatically

  • @AnandsKitchen1
    @AnandsKitchen1 Год назад

    Why does dlookup doesn't work in my pc?

  • @AlexHoo-hj7ji
    @AlexHoo-hj7ji Год назад

    I keep having this error
    User = DLookup("[Full Name]", "UserID = " & TempVars!tempUserID)

    • @iljanov
      @iljanov Год назад

      You're missing the table where the UserID is stored... I think it should look like:
      //User = DLookup ("[Full Name]", "UserT", "UserID = " & TempVars!UserID)
      I use T in the back of my table fields to make it easier to recognize.

  • @ing7220
    @ing7220 2 года назад

    hello sir what is the user login form expiry set i try the code same of error showing pls any solution sir

  • @magadeersadiq
    @magadeersadiq 3 года назад

    I have problem in my cod
    This message
    The expression on click you entered as the event property setting produced the following error: member already exists in an object module from which this object module derives

    • @austin72406
      @austin72406  3 года назад

      You have a duplicate name of your sub procedure and module name.

    • @AnandsKitchen1
      @AnandsKitchen1 Год назад

      i have checked.. no duplicate.. it shows "Run time error 13"@@austin72406

  • @maccleanseneh6656
    @maccleanseneh6656 3 месяца назад

    Please in fact I need the whole code to see where am lacking

  • @homesafe8632
    @homesafe8632 3 года назад

    Can we pass username to the report.

    • @austin72406
      @austin72406  3 года назад +1

      Yes, do same thing like on form

    • @homesafe8632
      @homesafe8632 3 года назад

      @@austin72406 may I get your email or social network contact?

  • @amogyamfikingsley5716
    @amogyamfikingsley5716 2 года назад +1

    moving too fast. We are here to learn bro

  • @NguyenTam-zl2tk
    @NguyenTam-zl2tk 2 года назад

    If someone removes the inputmark and every password is visible. No security at all😁

  • @KeffelewAssefa
    @KeffelewAssefa 2 года назад

    Thank you

  • @arminm5974
    @arminm5974 2 года назад

    Thanks alot

  • @AdamArzemy
    @AdamArzemy Год назад

    Too fast, cant even follow thing

  • @502police
    @502police 9 месяцев назад

    Good, but you cut a lot of the work here, so...

  • @Ytec_Offical
    @Ytec_Offical 3 года назад

    @Spanish Killer thank that helps

  • @AtaliSimon
    @AtaliSimon Месяц назад

    Your video isn't clear

  • @bogarttheweeb789
    @bogarttheweeb789 5 месяцев назад

    how the fuck your usertypeid work?
    i declared it intigers in tbluser but IT DOESNT FCKNG WORK MEN
    TOOK ME 3HRS TO DEBUGGING STILL DOESNT FCKING WORK

  • @denissavast
    @denissavast 3 года назад

    Молодец !

  • @crii7498
    @crii7498 3 года назад +1

    THIS VIDEO IS CORRUPTED AND MANY CUTS

    • @austin72406
      @austin72406  3 года назад

      It’s long and I have a lot of pause. So I have to cut it short. Sorry if it’s not smooth

    • @kristiqnnenov7787
      @kristiqnnenov7787 2 года назад

      @@austin72406 Dude you cut from nothing to navigation form what!?

  • @lexjacobatendido4667
    @lexjacobatendido4667 2 года назад

    16:47

  • @jersonaranasperez9503
    @jersonaranasperez9503 5 месяцев назад

    AHHHHHHHHHHHHHH

  • @blackreaperkaneki4819
    @blackreaperkaneki4819 2 года назад

    What a terrible tutorial *sighing