Thank you so much for teaching us. Subscribed from the very 1st lesson. Thumbs up as always. 1-Wishing you could tutor us how to send differnt greetings for 30 days then loop. 2-automatically display userid (=loginID) & username (Fullname of user) on Event - Form load using ENVIRON?. thanks a lot for your help
Hi and thank you for your enormously helpful videos! You are by far, the best I've found on TH-cam! I am no programmer but have been lucky enough to have been able to build a few databases but it has been several years. I am trying to create a database for our school aftercare program and am wondering if you can help me understand how to do something or if maybe I'm thinking of doing it completely wrong. At the end of the day multiple students will arrive all at once to the aftercare room. I would like the teacher in charge to be able to check them all in at once by going down the list and selecting each child present and then setting the time, date and StudentID in the ACHours table. Does that make sense? What is your suggestion? I have downloaded your Student Database but am unable to see the tables and relationships, etc. Thanks!
Thanks again for your response - your videos have been very helpful. This is very close to what I am looking for, except I have users logging into Access and want the form to filter to their record based off the frmLogin. How do you link the main form to the Login Form and filter the main form record to the user that logged into Access?
austin72406 I have watched that video and it was very helpful for me to set up the log in form. I need my main form to filter On Load the User's record that logged into the Login form. I need some code for my Main Form to take the user id that was used in the login form to filter to their record.
Hello Austin. First of all thank you very much for your amazing helpfull videos. Secondly it looks like it's not working. I'm getting the following error: Error 3075 Syntaxerror (operator missing) in query-expression (Uw Naam =1). When debugging the text "Me.Recordsource = Task" turns yellow. What should I do?
i am getting error in the syntax and Private Sub Form_Load() is highlighted. i have the same issue here and for the tracking user. thanks for your help
austin72406 Private Sub Form_Load() Dim User As String Dim MyLogIn As Integer Dim Task As String User = Environ("UserName") MyLogIn = DLookup("UserID", "tblUser", "UserLogin = '" & UserName & "'") Task = "Select * from TaskDue Where ( UserName = " & MyLogIn & " )" Me.RecordSource = Task End Sub Hi Mr. Austin Sorry really i dont know what's the problem i used same format same code but im still getting same error
Hi Austin, Thank you for your sharing, your videos are very good and helpful. I wonder if I can use the login ID to check the related records, instead of using the computer user name? Below is my code: Private Sub Form_Load() Dim User As String Dim MyLogin As String Dim Task As String User = Environ("UserName") MyLogin = DLookup("UserName", "User Login", "UserLogin = '" & User & "'") Task = "Select * FROM [tbl My Porfolio] WHERE ([Client ID] = " & MyLogin & ")" Me.RecordSource = Task End Sub Thank you very much. Joei
you will need to create a tempLoginName from the Login form then assign it to User like: User = Tempvars!TempLoginName More info about TempVars here: www.iaccessworld.com/how-to-set-temporary-value-tempvars/
Do you use the login passed through from the Login Form? if yes, it must be refreshed to see the login id and used it in the task function of "Select..."
austin72406 Iam sorry austin. Iam out of vb programming since 2001 so a iam asking a lot of question some times even basic. You are correct. please tell me how to refresh it. My login form and main navigation forms and it's codes are exactly like yours. Thanks.
austin72406 Private Sub Form_Load() Dim User As String Dim MyLogIn As String Dim Task As String User = Environ("UserName") MyLogIn = DLookup("userid", "tuser", "userlogin='" & User & "'") Task = "select * from TaskDue where(username = " & MyLogIn & ")" Me.RecordSource = Task End Sub
Still very useful 8 years later, just helped me get through an issue I've been stuck on for awhile.
Thank you so much for teaching us. Subscribed from the very 1st lesson. Thumbs up as always. 1-Wishing you could tutor us how to send differnt greetings for 30 days then loop. 2-automatically display userid (=loginID) & username (Fullname of user) on Event - Form load using ENVIRON?. thanks a lot for your help
Hi and thank you for your enormously helpful videos! You are by far, the best I've found on TH-cam!
I am no programmer but have been lucky enough to have been able to build a few databases but it has been several years. I am trying to create a database for our school aftercare program and am wondering if you can help me understand how to do something or if maybe I'm thinking of doing it completely wrong. At the end of the day multiple students will arrive all at once to the aftercare room. I would like the teacher in charge to be able to check them all in at once by going down the list and selecting each child present and then setting the time, date and StudentID in the ACHours table. Does that make sense? What is your suggestion? I have downloaded your Student Database but am unable to see the tables and relationships, etc. Thanks!
Thank you very much.
Thanks again for your response - your videos have been very helpful. This is very close to what I am looking for, except I have users logging into Access and want the form to filter to their record based off the frmLogin.
How do you link the main form to the Login Form and filter the main form record to the user that logged into Access?
please watch my video on Create Login Form Access part 4 link : @watch?v=dSjWHbJz120
austin72406 I have watched that video and it was very helpful for me to set up the log in form.
I need my main form to filter On Load the User's record that logged into the Login form.
I need some code for my Main Form to take the user id that was used in the login form to filter to their record.
Hello How did you display the name of the logged in user ?
Hello Austin. First of all thank you very much for your amazing helpfull videos.
Secondly it looks like it's not working. I'm getting the following error:
Error 3075
Syntaxerror (operator missing) in query-expression (Uw Naam =1).
When debugging the text "Me.Recordsource = Task" turns yellow.
What should I do?
your SLQ statement is incorrect.
How can we get the username without using environ()?
i am getting error in the syntax and Private Sub Form_Load() is highlighted.
i have the same issue here and for the tracking user.
thanks for your help
please make sure you have the login user in the tableuser same as computer login user if you user user = Environ ("Username")
i made a mistake coppying what u wrote, how can i avoid a null error if there is no duetask to the worker?
use If Statement like If Not Isnull(me.duetask) then ... process task ... End If.
thks for the help.my problem is in dlookuo and not in task. thks anyway
Hi austin, i keep getting error 94. How do I resolve this error?
Hello, the same is happening to me, how did you fix it? PLEASE!!!
Hi, austin I making a system with yours videos, but I need some help...can you do that....?
some people paid me to update their project. the cost will depends on the work.
Sir i am waiting you positive response
Hi Mr. Austin I hope you can help me in getting an error "Invalid use of Null"
Thanks in advance for your help
make sure you have a value for the one you lookup for ( Dlookup).
austin72406 Private Sub Form_Load()
Dim User As String
Dim MyLogIn As Integer
Dim Task As String
User = Environ("UserName")
MyLogIn = DLookup("UserID", "tblUser", "UserLogin = '" & UserName & "'")
Task = "Select * from TaskDue Where ( UserName = " & MyLogIn & " )"
Me.RecordSource = Task
End Sub
Hi Mr. Austin Sorry really i dont know what's the problem i used same format same code but im still getting same error
Please help me to share with me download link of this project.sir i am waiting
ok, how do I contact you?
from my contact page at www.iAccessWorld.com
Hi Austin,
Thank you for your sharing, your videos are very good and helpful.
I wonder if I can use the login ID to check the related records, instead of using the computer user name?
Below is my code:
Private Sub Form_Load()
Dim User As String
Dim MyLogin As String
Dim Task As String
User = Environ("UserName")
MyLogin = DLookup("UserName", "User Login", "UserLogin = '" & User & "'")
Task = "Select * FROM [tbl My Porfolio] WHERE ([Client ID] = " & MyLogin & ")"
Me.RecordSource = Task
End Sub
Thank you very much.
Joei
yes, normally you will use the user login from your login form. you will set the User to the user login name from your login form.
I am very junior Access worker, could you let me know how to change the code?
User = Environ("UserName")
Thank you for your kindly help.
you will need to create a tempLoginName from the Login form then assign it to User like:
User = Tempvars!TempLoginName
More info about TempVars here: www.iaccessworld.com/how-to-set-temporary-value-tempvars/
your gangster bro
Getting error #3464, "data type mismatch at criteria expression" at "me.recordsource=task"
Help please. thanks
Do you use the login passed through from the Login Form? if yes, it must be refreshed to see the login id and used it in the task function of "Select..."
austin72406 Iam sorry austin. Iam out of vb programming since 2001 so a iam asking a lot of question some times even basic.
You are correct. please tell me how to refresh it. My login form and main navigation forms and it's codes are exactly like yours.
Thanks.
can you give me all your code on the On Load Event Procedure for the form you got an error?
austin72406
Private Sub Form_Load()
Dim User As String
Dim MyLogIn As String
Dim Task As String
User = Environ("UserName")
MyLogIn = DLookup("userid", "tuser", "userlogin='" & User & "'")
Task = "select * from TaskDue where(username = " & MyLogIn & ")"
Me.RecordSource = Task
End Sub
if data type of userid is number then Dim MyLogIn As String will be Dim MyLogIn As Integer