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 :)
@samihashimla9932
4 жыл бұрын
So you created this in a different form. How do you add this to your Home tab in the navigation form?
@posthumankta
10 жыл бұрын
What did you check on the function at 10:27 ?
@j.johnson6028
3 жыл бұрын
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?
@CristinaGCrisEscapatehoy
7 жыл бұрын
Hi! I only want to use the full name of the person that is log in the form.
@mikaastra511
10 жыл бұрын
hi what did you check when you got the error. because it does not show properly on your video.
@austin72406
10 жыл бұрын
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 : kzitem.info/news/bejne/ypultK1vr3ueYKg
@kavipadhu
6 жыл бұрын
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.
@mustafaqayssar1682
6 жыл бұрын
Hello The reason for not appearing full name in the HOME form
@luyonjostephen8746
10 жыл бұрын
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
10 жыл бұрын
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
@weme180477
7 жыл бұрын
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
@joylayaoen7332
8 жыл бұрын
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
8 жыл бұрын
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.
@246pac246
10 жыл бұрын
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!!!! :)
@brahim5051
4 жыл бұрын
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
@billmark5375
8 жыл бұрын
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
8 жыл бұрын
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
8 жыл бұрын
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
8 жыл бұрын
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 !
@nomanmasood6062
7 жыл бұрын
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
6 жыл бұрын
I think it is related whit using greeting 2 times, ao i change greeting-1greeting in function and it works
@bryanziani4457
3 жыл бұрын
@@huberthendaleko6503 What do you mean?
@huberthendaleko6503
3 жыл бұрын
Sorry bro i dont remember, but i think IT was on options
@bryanziani4457
3 жыл бұрын
@@huberthendaleko6503 Yeah I figured it out
@giegoar
8 жыл бұрын
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
8 жыл бұрын
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
8 жыл бұрын
+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
8 жыл бұрын
it should be "Navigation Form.NavigationSubform" on the BrowseTo
@zackjoseph8441
7 жыл бұрын
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
7 жыл бұрын
Hi it's very simple here is the link: www.iaccessworld.com/how-to-set-temporary-value-tempvars/
@zackjoseph8441
7 жыл бұрын
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
7 жыл бұрын
Hi Look in austin72406 videos user access levels log in form, he have tutorials how to do that.
@zackjoseph8441
7 жыл бұрын
Thanks
@rhyanndejuan9250
10 жыл бұрын
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
10 жыл бұрын
dim User as stringUser = Environ("USERNAME")one text box names welcome, put this code: Me.welcome = Me.Greeting & " " & User
@rhyanndejuan9250
10 жыл бұрын
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
10 жыл бұрын
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
10 жыл бұрын
austin72406 would you show me the code for that pls
@aminagrebi
10 жыл бұрын
I have error this line Me.greeting = Mygreeting(systime)
@austin72406
10 жыл бұрын
amin agrebi sure you have a text box name Systime and the data control source of Systime =TimeValue(Now())
@29884840
7 жыл бұрын
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
@carlosguevarra4138
8 жыл бұрын
hi austin, how to disable admin page on user login?
Пікірлер: 47