Function Greeting User on Open : MS Access 2010

Welcome User like saying "Good Morning" to User when the user open program.

[@emma5990]

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 :)

[@posthumankta]

What did you check on the function at 10:27 ?

[@samihashimla9932]

So you created this in a different form. How do you add this to your Home tab in the navigation form?

[@j.johnson6028]

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?

[@mikaastra511]

hi what did you check when you got the error. because it does not show properly on your video.

[@austin72406]

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

[@kavipadhu]

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.

[@CristinaGCrisEscapatehoy]

Hi! I only want to use the full name of the person that is log in the form.

[@mustafaqayssar1682]

Hello The reason for not appearing full name in the HOME form

[@246pac246]

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!!!! :)

[@weme180477]

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

[@luyonjostephen8746]

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?

[@austin72406]

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

[@joylayaoen7332]

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.

[@austin72406]

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.

[@brahim5051]

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

[@giegoar]

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

[@austin72406]

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.

[@giegoar]

+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

[@austin72406]

it should be "Navigation Form.NavigationSubform" on the BrowseTo

[@zackjoseph8441]

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.

[@29884840]

Hi it's very simple here is the link: www.iaccessworld.com/how-to-set-temporary-value-tempvars/

[@zackjoseph8441]

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.

[@29884840]

Hi Look in austin72406 videos user access levels log in form, he have tutorials how to do that.

[@zackjoseph8441]

Thanks

[@nomanmasood6062]

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.

[@huberthendaleko6503]

I think it is related whit using greeting 2 times, ao i change greeting-1greeting in function and it works

[@bryanziani4457]

@@huberthendaleko6503 What do you mean?

[@huberthendaleko6503]

Sorry bro i dont remember, but i think IT was on options

[@bryanziani4457]

@@huberthendaleko6503 Yeah I figured it out

[@rhyanndejuan9250]

i would like to ask what if you use only the LoginID what would be the command... sorry for being a newbie, in vba

[@austin72406]

dim User as stringUser = Environ("USERNAME")one text box names welcome, put this code: Me.welcome = Me.Greeting & " " & User

[@rhyanndejuan9250]

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

[@austin72406]

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.

[@hassanmahfouz909]

austin72406 would you show me the code for that pls

[@aminagrebi]

I have error this line Me.greeting = Mygreeting(systime)

[@austin72406]

amin agrebi sure you have a text box name Systime and the data control source of Systime =TimeValue(Now())

[@carlosguevarra4138]

hi austin, how to disable admin page on user login?

[@austin72406]

set user level and use it on form loaded.

[@albertapohquainooo9739]

hi it is not working for me

[@arrakhilreddy2648]

can you do a small project for me i will pay u

[@29884840]

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

[@billmark5375]

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.

[@austin72406]

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

[@billmark5375]

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.

[@alaeddinhere]

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 !