Still very useful 8 years later, just helped me get through an issue I've been stuck on for awhile.
@Jojosmith342
Жыл бұрын
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
@KeffelewAssefa
Жыл бұрын
Thank you very much.
@marilouvardeman4157
6 жыл бұрын
Hi and thank you for your enormously helpful videos! You are by far, the best I've found on KZitem! 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!
@cwc5023
10 жыл бұрын
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
10 жыл бұрын
please watch my video on Create Login Form Access part 4 link : @watch?v=dSjWHbJz120
@cwc5023
10 жыл бұрын
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.
@sultansuliz
6 жыл бұрын
Hello How did you display the name of the logged in user ?
@lieuwesmit
9 жыл бұрын
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?
@austin72406
9 жыл бұрын
your SLQ statement is incorrect.
@farwaumair1623
Жыл бұрын
Sir i am waiting you positive response
@syanl2804
7 жыл бұрын
Hi austin, i keep getting error 94. How do I resolve this error?
@beisbol-baseball5433
7 жыл бұрын
Hello, the same is happening to me, how did you fix it? PLEASE!!!
@spooky_zen
8 жыл бұрын
your gangster bro
@zamorandhar
4 жыл бұрын
How can we get the username without using environ()?
@tasihvnehol5254
9 жыл бұрын
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
9 жыл бұрын
please make sure you have the login user in the tableuser same as computer login user if you user user = Environ ("Username")
@tasihvnehol5254
9 жыл бұрын
i made a mistake coppying what u wrote, how can i avoid a null error if there is no duetask to the worker?
@austin72406
9 жыл бұрын
use If Statement like If Not Isnull(me.duetask) then ... process task ... End If.
@tasihvnehol5254
9 жыл бұрын
thks for the help.my problem is in dlookuo and not in task. thks anyway
@miguelazize4679
8 жыл бұрын
Hi, austin I making a system with yours videos, but I need some help...can you do that....?
@austin72406
8 жыл бұрын
some people paid me to update their project. the cost will depends on the work.
@jhessellynsandiego9557
9 жыл бұрын
Hi Mr. Austin I hope you can help me in getting an error "Invalid use of Null" Thanks in advance for your help
@austin72406
9 жыл бұрын
make sure you have a value for the one you lookup for ( Dlookup).
@jhessellynsandiego9557
9 жыл бұрын
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
@farwaumair1623
Жыл бұрын
Please help me to share with me download link of this project.sir i am waiting
@miguelazize4679
8 жыл бұрын
ok, how do I contact you?
@austin72406
8 жыл бұрын
from my contact page at www.iAccessWorld.com
@emesen99
10 жыл бұрын
Getting error #3464, "data type mismatch at criteria expression" at "me.recordsource=task" Help please. thanks
@austin72406
10 жыл бұрын
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..."
@emesen99
10 жыл бұрын
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
10 жыл бұрын
can you give me all your code on the On Load Event Procedure for the form you got an error?
@emesen99
10 жыл бұрын
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
@austin72406
10 жыл бұрын
if data type of userid is number then Dim MyLogIn As String will be Dim MyLogIn As Integer
@joeycheng6308
7 жыл бұрын
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
@austin72406
7 жыл бұрын
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.
@joeycheng6308
7 жыл бұрын
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.
@austin72406
7 жыл бұрын
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/
Пікірлер: 45