Welcome User like saying "Good Morning" to User when the user open program.
Пікірлер: 47
@emma59908 жыл бұрын
hello,I typed in Me.FullName = DLookup("UserName", "tblUser", "[UserLogin] = '" & Me.User & "'") but it says that there's a mistake with [UserLogin] I don't know how to correct it.I would be very grateful if you could help me :)
@posthumankta10 жыл бұрын
What did you check on the function at 10:27 ?
@samihashimla99324 жыл бұрын
So you created this in a different form. How do you add this to your Home tab in the navigation form?
@j.johnson60283 жыл бұрын
Hello in your Me.Fullname the Name is not shoing up in the text box it says there is a parentheses missing how can I fix it?
@mikaastra51110 жыл бұрын
hi what did you check when you got the error. because it does not show properly on your video.
@austin7240610 жыл бұрын
anything can cause the error. you can use Error Handling Code added to you function likePublic Function functionname()On Error GoTo Errhandler:...... (your code here)......Exit Errhandler:Exit function Errhandler: Msgbox Err.discription, vbexclamation resume Exit_Errhandler:end functionwatch my video on Error Handling in VBA at : kzbin.info/www/bejne/n5bSf6xvq66gY9U
@kavipadhu6 жыл бұрын
Hi, the video shows the window login ID. However, I want to show the login ID to the access on the form. Please advise how.
@CristinaGCrisEscapatehoy7 жыл бұрын
Hi! I only want to use the full name of the person that is log in the form.
@mustafaqayssar16826 жыл бұрын
Hello The reason for not appearing full name in the HOME form
@246pac24610 жыл бұрын
i have tried over and over and i keep on getting an error in the compiler that say "compile error: syntax error but when it loads the error it highlights the first line yellow Private Sub Form_Load() why is it doing this? and how can i fix it? thats for help!!!! :)
@weme1804777 жыл бұрын
Hi, i tried everything but i still got error in: Function myGreeting(mytime As Variant) Don't know what to do the last part... please help
@luyonjostephen874610 жыл бұрын
I noticed that you had a time field in the form header that was moving as the seconds went by. How did you do that?
@austin7240610 жыл бұрын
please watch my video on: How to create a live clock or real time on form link : How to create a live clock or real time on form: MS Access 2010
@joylayaoen73327 жыл бұрын
Hi. Appreciate your kindness in sharing your great videos. Can you tell me please on how I can make the same greetings in a message box after successful login by the user? Thank you.
@austin724067 жыл бұрын
I use a computer user login for Greeting in this video. If you use a login form, you can replace the computer user login with the the user login from the login form. you can save the username on login form as a Temp Var then call it on the greeting function.
@brahim50514 жыл бұрын
hello how can i add the username in my form after passing by switchboard or Menu general who appair after putting the correct usermane and password . sorry for my poor english thank you
@giegoar8 жыл бұрын
Hi, the name doesn't show up in the home page when I open the navigation form unless I click another tab then come back to home. Can you tell me how to immediately show the name as the navigation pane opens (I open it using the login form). Thanks a lot!!
@austin724068 жыл бұрын
you need to refresh the Navigation form. you can use BrowseTo like: DoCmd.BrowseTo acBrowseToForm, "frmFirstPage", "Navigation Form.NavigationSubForm", , , acFormEdit replace "frmFirstPage" with form name on your first tab.
@giegoar8 жыл бұрын
+austin72406 it is not working, I am doing something wrong :/ Here is the last of the code in click event for login. From name is Home and the tab too. Thanks a lot for your help!!! 'open different form according to userlevel If UserLevel = 1 Then 'admin DoCmd.OpenForm "Navigation Form" Forms![Navigation Form]![txtLogin] = TempLoginID Forms![Navigation Form]![txtUser] = UserName DoCmd.BrowseTo acBrowseToForm, "Home", "Navigation Form.Home", , , acFormEdit Else DoCmd.OpenForm "Navigation Form" Forms![Navigation Form]![txtLogin] = TempLoginID Forms![Navigation Form]!NavigationButton15.Visible = False Forms![Navigation Form]![txtUser] = UserName DoCmd.BrowseTo acBrowseToForm, "Home", "Navigation Form.Home", , , acFormEdit End If
@austin724068 жыл бұрын
it should be "Navigation Form.NavigationSubform" on the BrowseTo
@zackjoseph84417 жыл бұрын
I need to know how to show user log in of person on the form, you showed how to show the person who is logged into the computer but i want to show who is logged into the database file.
@298848407 жыл бұрын
Hi it's very simple here is the link: www.iaccessworld.com/how-to-set-temporary-value-tempvars/
@zackjoseph84417 жыл бұрын
Thanks very much for this, the next problem i have is getting a specific button on a navigation form to automatically open once a user has logged into the database. i have created various zone for users to log into. Each zone has a corresponding subform which i want to automatically open once the appropriate zone has been selected on the login screen.
@298848407 жыл бұрын
Hi Look in austin72406 videos user access levels log in form, he have tutorials how to do that.
@zackjoseph84417 жыл бұрын
Thanks
@nomanmasood60627 жыл бұрын
hey austin. I am getting Run time error 13 Type Mismatch like you did. I dont know how you fixed it. Can you please elaborate? I have tried everything.
@huberthendaleko65036 жыл бұрын
I think it is related whit using greeting 2 times, ao i change greeting-1greeting in function and it works
@bryanziani44573 жыл бұрын
@@huberthendaleko6503 What do you mean?
@huberthendaleko65033 жыл бұрын
Sorry bro i dont remember, but i think IT was on options
@bryanziani44573 жыл бұрын
@@huberthendaleko6503 Yeah I figured it out
@rhyanndejuan925010 жыл бұрын
i would like to ask what if you use only the LoginID what would be the command... sorry for being a newbie, in vba
@austin7240610 жыл бұрын
dim User as stringUser = Environ("USERNAME")one text box names welcome, put this code: Me.welcome = Me.Greeting & " " & User
@rhyanndejuan925010 жыл бұрын
austin72406 Got it, and works one more question, i would like to use the userid and user names only since we had a multiple users, and i noticed that the environ pertains to the system user in windows, is there any command that we use only the user in the table not the system user? this is your code that i use, thanks in advance... Private Sub Form_Load() Me.encoderID = Environ("username") Me.txtEncoded = DLookup("UserName", "tblUser", "[UserLogin] = '" & Me.encoderID & "'") Me.txtdesig = DLookup("Designation", "tblUser", "[UserLogin] = '" & Me.encoderID & "'") End Sub
@austin7240610 жыл бұрын
if you don't use the system user, on main form, you can get user login passed through from Log in form. set a user text box on main form = user on user table that matches the userid from log in form.
@hassanmahfouz90910 жыл бұрын
austin72406 would you show me the code for that pls
@aminagrebi10 жыл бұрын
I have error this line Me.greeting = Mygreeting(systime)
@austin7240610 жыл бұрын
amin agrebi sure you have a text box name Systime and the data control source of Systime =TimeValue(Now())
@carlosguevarra41388 жыл бұрын
hi austin, how to disable admin page on user login?
@austin724068 жыл бұрын
set user level and use it on form loaded.
@albertapohquainooo97396 жыл бұрын
hi it is not working for me
@arrakhilreddy26486 жыл бұрын
can you do a small project for me i will pay u
@298848407 жыл бұрын
For everyone who wants to display user from database user list only follow this link: www.iaccessworld.com/how-to-set-temporary-value-tempvars/ In Login Form: Dim TempLoginID As TempVar TempVars!TempLoginID = Me.txtUsername.Value And in form where you want the name to be seen: Private Sub Form_Load() Me.txtLoggedIn = TempVars!TempLoginID ' txtLoggedIn is the cell where your user name will be displayed
@billmark53758 жыл бұрын
Hi, the video shows the window login ID. However, I want to show the login ID to the access on the form. Please advise how. I tried to use me.user = txtuserlogin instead of me.user = Environ("username"), but it fails.
@austin724068 жыл бұрын
if you use the computer user login id then you can use me.user = Environ("username") on the On Load Event of form. by name your text box as user
@billmark53758 жыл бұрын
I don't want the computer user login id but just the id to the access program. Some users may go to other team members' computer (already log in by other members) to access the program. Please advise.
@alaeddinhere8 жыл бұрын
Hi Bill, the way to do that is by passing the user login when opening the home page (or whatever). This is an example of opening a new form from login page and passing the login id: DoCmd.OpenForm "frmHomepage", OpenArgs:=username where "username" is your login id. And to retrieve that in the new opened form: TextField = OpenArgs //I hope it is all clear !