How to Create Login Form with Security Type in Access Database

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 พ.ย. 2024

ความคิดเห็น • 55

  • @jerzykepinski
    @jerzykepinski ปีที่แล้ว +2

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

  • @Danyboy50_
    @Danyboy50_ ปีที่แล้ว +5

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

  • @mrshahi5981
    @mrshahi5981 2 ปีที่แล้ว +6

    How did you connect tbluser and UserType table ?

    • @kokolebest95
      @kokolebest95 ปีที่แล้ว

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

  • @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

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

  • @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

  • @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

  • @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 😇😇

  • @AnandsKitchen1
    @AnandsKitchen1 ปีที่แล้ว

    Why does dlookup doesn't work in my pc?

  • @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

  • @maccleanseneh6656
    @maccleanseneh6656 5 หลายเดือนก่อน

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

  • @amogyamfikingsley5716
    @amogyamfikingsley5716 2 ปีที่แล้ว +1

    moving too fast. We are here to learn bro

  • @Ytec_Offical
    @Ytec_Offical 3 ปีที่แล้ว

    @Spanish Killer thank that helps

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

  • @homesafe8632
    @homesafe8632 4 ปีที่แล้ว

    Can we pass username to the report.

    • @austin72406
      @austin72406  4 ปีที่แล้ว +1

      Yes, do same thing like on form

    • @homesafe8632
      @homesafe8632 4 ปีที่แล้ว

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

  • @KeffelewAssefa
    @KeffelewAssefa 2 ปีที่แล้ว

    Thank you

  • @magadeersadiq
    @magadeersadiq 4 ปีที่แล้ว

    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  4 ปีที่แล้ว

      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

  • @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

  • @arminm5974
    @arminm5974 2 ปีที่แล้ว

    Thanks alot

  • @NguyenTam-zl2tk
    @NguyenTam-zl2tk 2 ปีที่แล้ว

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

  • @denissavast
    @denissavast 3 ปีที่แล้ว

    Молодец !

  • @AdamArzemy
    @AdamArzemy ปีที่แล้ว

    Too fast, cant even follow thing

  • @502police
    @502police 10 หลายเดือนก่อน

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

  • @lexjacobatendido4667
    @lexjacobatendido4667 2 ปีที่แล้ว

    16:47

  • @AtaliSimon
    @AtaliSimon 3 หลายเดือนก่อน

    Your video isn't clear

  • @bogarttheweeb789
    @bogarttheweeb789 6 หลายเดือนก่อน

    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

  • @jersonaranasperez9503
    @jersonaranasperez9503 6 หลายเดือนก่อน

    AHHHHHHHHHHHHHH

  • @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 3 ปีที่แล้ว

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

  • @blackreaperkaneki4819
    @blackreaperkaneki4819 3 ปีที่แล้ว

    What a terrible tutorial *sighing