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.
@@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
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.
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?
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.
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
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?
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 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)
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.
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?
@@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?
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
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
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.