Came to watch in general like I always do not needing to know exactly how to track users but I always find something that I didn't know before hand in your videos so very educational. I've searched high and low on how to turn those warnings off and thought it was impossible to do so. You are a life saver keep up the good work.
@599CD2 жыл бұрын
My lessons are always loaded with chocolatey goodness. :)
@mathmagics82122 жыл бұрын
@@599CD really helped me building my school software Working on ID Card Generation Now the problem is i have to load the image again from folder which already exit in db i m not able to fetch same pic from db
@muwangaeric21672 жыл бұрын
Thanks so much Richard, it's me Eric Muwanga from Uganda your videos are really doing wonders in my system I have developed
@599CD2 жыл бұрын
My pleasure
@shemtusiime6478Ай бұрын
Thanks very much. May you please do a video on how to display database information on the customer display pole. Thanks
@johnsonofjohn1678 Жыл бұрын
Wow! Exactly the solution I needed. And it was so easy. Thanks so much!
@MBKCZAR2 жыл бұрын
Magnificent video, 1000 percent helpfully and useful 👍
@599CD2 жыл бұрын
Glad you think so!
@premshah6200 Жыл бұрын
Very nice n important Thank you🌹❤🙏
@migirooruru248811 ай бұрын
hello Richard i am ELIUD MIGIRO from KENYA your recent online student in vba. some a few days ago i watched your video lesson on creating a log in logout time tracking system and i made one from your teaching. now, my challenge is that when i login and later on logout, login and logout time are recorded in different rows. is there a code that can put them in the same row? thank you.
@iljanov Жыл бұрын
Wonderful video, love your approach and application of Access, do you have a tutorial on making a logon/logoff form?
@599CD Жыл бұрын
599cd.com/UserLevelSecurity
@abdulhamidalhaddadi22552 ай бұрын
CAN I DO IT WITH MS EXCEL TIME SHEET?
@mikewashington41882 жыл бұрын
Good method. Thanks 🙏🏿 very much. I could use this method to track when a user deletes a record (that is if they have permission).
@599CD2 жыл бұрын
Yes, exactly
@chamaradw Жыл бұрын
Great explanation ❤
@599CD Жыл бұрын
Glad it was helpful!
@nayyerabbas3957 Жыл бұрын
Sir Thanks this video is very helpful
@599CD Жыл бұрын
Most welcome
@nayyerabbas3957 Жыл бұрын
I have a software that turns off the computer as soon as I lose it means that it is synthesized
@joseancheta3817 Жыл бұрын
Long-time viewer, first-time commenter here. Do you have a video that can help me kick users out of the database?
@599CD Жыл бұрын
Hi there. Welcome. I've got a video on this coming out soon.
@neverseenbefore1382 Жыл бұрын
Sir please can you tell me how to short data of a single field with my own choice using vba
@599CD Жыл бұрын
599cd.com/ClickToSort
@MrAimalsultani2 жыл бұрын
WOW- Well-Done!
@599CD2 жыл бұрын
Thanks
@midoallam16592 жыл бұрын
Thanks so much, Richard, How can I do the same ( I would like to append to a linked table in the Sharepoint list ) could you please tell me how?
@599CD2 жыл бұрын
599cd.com/Sharepoint
@embren11 Жыл бұрын
Thanks for the video! Is there any way to pull a users outlook email address instead of username? My users are listed by employee numbers which I can look up but it would be easier if I can pull email addresses since they have the users actual name.
@599CD Жыл бұрын
There's no EASY way to do that, no. I'm sure it's possible, though. However, if you're going to go to that length, you might as well just setup REAL security. 599cd.com/Security
@leonthompson19762 жыл бұрын
Just what I was after - thank you so much. Not sure why but some of my users' details are not being logged. Are there any reasons that you can think of for this?
@599CD2 жыл бұрын
Impossible to tell from here
@oldbrokenwrench2 жыл бұрын
No matter how I do it I cannot get Dlookup to work. I can get your example to work, but that’s not what I want to do. I love the “logon”, “logoff” table and I can get the environment thing to work to put the data in the main menu form. However the user name in the environment comes back as an employee number (ie X222222). I need either the append query or and data field on the main menu form to take that employee number match it on the employee table and bring back “last name”. Everybody doing a dlookup is always doing a combo box, no, no, no, no combo box. On the employee table the employee number is indexed with no duplicates I have been trying for over a week to get this to work. Also is there a way to cause Access to close if the user id returned from the environment is not on the table?
@599CD2 жыл бұрын
Without seeing exactly what you've got there, it's impossible for me to help you. Yes... Docmd.Quit
@userseventyeight2 жыл бұрын
Thank you.
@599CD2 жыл бұрын
You're welcome!
@fredzwalm54292 жыл бұрын
Richard. Is there a way to close the application when it is not in use for say 20 minutes? I already do a time event on the menu for something else. But if the programme (frontend) is open and not in use I want to close it down. Is there a way to do that?
@599CD2 жыл бұрын
Sure... with your timer event.
@fredzwalm54292 жыл бұрын
@@599CD I thought so. Do I have to do that on every form? Some forms are open but "sleeping" because the users is working in another form. Or is there a quick way out?
@raboops2 жыл бұрын
I have an instance where my time clock was working fine for years but now a user seems to can't sign in or out.. any suggestions?
@599CD2 жыл бұрын
Sorry, but based on the information you've given me, I really don't have enough data to tell you what's wrong. Feel free to submit your question with more details (including screen shots) in the appropriate Forum on my web site. 599cd.com/Forums
@raboops2 жыл бұрын
@@599CD ok i will
@carmelcream852 жыл бұрын
Hi again...Great tutorial, as always! Getting an error with the Current.Db code. When I click "design view" on my switchboard (main menu) form, I get "Run-Time Error 2467: The expression you entered refers to an object that is closed or doesn't exist." I don't often go into design view of my switchboard, but in this instance I need to remove a text box and can't. Additionally, this leads me to believe something else is wrong and I don't want to deploy copies with a coding error buried in it.
@599CD2 жыл бұрын
I'd really have to see what you've got to tell you. Post this in the Forum on my web site with some screen shots. 599cd.com/AF
@AustereShipping Жыл бұрын
Hi Rick, I loved your tutorial and successfully implemented it too in my database. But i have a small problem. I have more than 1 main forms. The reason is that once a user logs-in using his user id and pw, basis his securoity level he will be directed to respective main form. Now my question is: is there a way that log-in & log-out data can be save/appended in database from various forms through the same append queries. Pls help. Thanks in advance. Bharat Khatri
@599CD Жыл бұрын
I do not understand your question
@AustereShipping Жыл бұрын
@@599CD let me re-phrase the question. Can the log-in and log-out data be saved/appended in log table from different forms too. Because i have 4 main screens which open basis the user level. how to do so, as the queries you created point to only 1st form (basis criteria)
@mathmagics82122 жыл бұрын
Dear sir I have a table of students where i attched a photo of each Now i want print id cards using same pic of individual student (not all) I searched alot but cant find the solution i again to attach same pic plz guide me to use same photo
@599CD2 жыл бұрын
599cd.com/Images
@divyasrik3442 жыл бұрын
where is this dataset available?
@599CD2 жыл бұрын
What dataset?
@gregoryjeffries84754 ай бұрын
Track last keystroke time, longer than 10 minutes, chances are they've walked away.
@599CD4 ай бұрын
Indeed
@user-ss9cg1qk1i2 жыл бұрын
I am looking for after logged in how to track the info. This is tutorial is not pointed to but the title used "Login". This is why I waste my time for watching.
@599CD2 жыл бұрын
You're looking for an audit trail: 599cd.com/TrackChanges. And if my videos are a waste of time, don't watch them.