You are a master, doctor and magician of ms access. Your one video give us lot of knowledge ,operations and cover different aspects of access. You are giving lecturers without fee its show your dedication and devotion to us.. God bless you.
hi Steve. Just found this video.... FANTASTIC! I. New to learning Access and your explanation of these functions is great and gives me insight to what’s possible with my databases. Thank you Sir
Brilliant work sir. I think your video lectures are one of the easiest and best ways for someone to learn Access 2013. I was familiar with Access 1995 version, (yes the one with Access Basic) and i wanna to familiarize myself with Access 2013. Thanks again for the great material you provide.
Again an awesome video, i really enjoy watching and learning from your videos. i'm thinking about watching all your videos from 1 til i think 79, and creating a database with everything that your videos go through.
Well thank you! I do advise people to watch all of the beginner series so they can get the most benefit from Access and all of my videos on Access. Some topics can cover some pretty advanced concepts but if you don't yet understand all of the basics you can have a problem.
Hi Steve, Wonderful video. I have an ask over here. How to shut down a custom Access application remotely with Timer on the form which will pop up to the user. You may have to perform maintenance tasks on a Microsoft Access database, such as compacting or repairing, making backup copies, or making design modifications. Many of these operations require that all users exit the database. However, there is no built-in way to force users to quit Microsoft Access. Your input is highly appreciated.
Hi, this is nearly exactly what I need. Were I to connect my Access DB to say "SQL Server Express", I could use Stored Procedures to have 1 particular Update SQL Statement run at a specified time and run through and Change/Add/Delete Dates, Check/Uncheck Fields etc. for all records in a particular table, right, or what that be done via a different mechanism than Stored Procedures? I do like the creating commands at will option to as I may want, or have a need to, run that statement at some point throughout the day. Thanks for the great video.
Thanks for the video and the assistance, this was a huge help with my project. I have it working for my system but I do have an issue I am not sure how to handle. I have about 45 PC's in the company that utilize this program. Getting everyone out is a huge challenge if I need to work on the back end. I am looking to be able to set a time say 15 minutes in the future with the command docmd.save, docmd.quit. This works great for the frontend I am using, and it works great if the time is already set for someone that logs in, however any frontend that is already logged in, just ignores the alarm even though that alarm shows up in its listbox. I had to add me.lst.requery in order for the list box to update, it just doesn't seem to work. also when deleting a line, that throws a line deleted error on the other front ends. I tried encasing the delete function in the docmd.setwarning false/true. but that had no effect. its actually balking out in the code itself because its messing with the loop. I may be having issues, but believe me, this is a far cry from where I was this morning :)
in my boss's dept. his employees fight for who will run the import data procedure after 4pm. Looks like now I have a solution! thank you so much Steve!
Thanks! This is a small part of an idea I came up with to e-mail results of a query - I'd like to set it up to where there was no attachment if the query results were 0 - but this gives me a starting point
Thank you Steve I've watched all your basic and advanced tutorials and however i have a button called BackUp on the admin form which i want get a backup after each day of work. any backup button tutorials on writing a code to manually backup the database?
Another great video to learn from!! thanks again Steve. One question please. Does the form need to remain open in order for the command to execute? I have users, which often times, I keep reminding them to exit the database after they're done with tasks and not just leave it open and idling on their desktop. Is there a way for a system to execute command to close database (front end) if a user is not active.
Sure. Just keep the number of times the timer code has been triggered in a public variable, and the number of times you want it run in another variable. Then compare the two and if it equals or exceeds the number close the timer.
Thanks for this video Mr. Steve, I have learned even more. But I am stuck in my database, confronted with a challenge. I have a database that keeps track of records, where a user is expected to commence or initiate a process and complete the process before beginning another one. This process is done on a continuous form. Example, I have about 5 fields in a continuous form, and if the Name field is Michael, and as he moves to the next field, where a drop down is, to select status as either COMPLETED or NOT COMPLETED, I want to code the form, such that if Michael Status in the status field is not selected as Completed, then he should not be able to initiate another process on d same form, I will appreciate a code that can tie the Name & Status field together, if the Name field is selected for any, he has to Continue and select COMPLETED under STATUS field before the same name can proceed to initiating another process..... Thanks
hi. i think im looking up wrong videos but not sure the terminology for a production timing etc in access. i have a task takes say 5 mins to produce 1 item. i start at 11.00am at 11.02am i pause job. at 11.42am resume job at 11.47am job ends. total time taken 0.07 mins vers 5min stand therefore 2min over target. how do i put that in a database?
Question, since the recordset is only loaded when the form opens this will not work to use as an "scheduled task" type option will it? (I'm trying to come up with a cronjob type scenario)
Hi there thank you for the tutorial I was able to setup my functions to run at the specified time. My question is, I have a function that I have to run every 2 minutes. I tried creating one for 12:00:00 AM then copying it into Excel and counting by twos and using autofill. I then pasted it back directly into the table. The records pasted fine, but they do not seem to be executing properly. If I for example. delete the one I pasted for 3:10:00 PM then re-add it from the form it works, but wont work otherwise. I find it'll be really tedious to manually enter each and every one. I'm guessing it's a formatting issue between Excel and Access. Do you have any other suggestions?
Hi sir Greetings, I am Using access 2007, i am struck with a query. Kindly Help. ( I am using rfid reader to punch an attendance, after a attendance is punched i want a timer based popup message that Mr. xyz your attendance is punched. After few seconds the popup should disappear and we can set focus to punching attendance again" I want to include timer based popup. Hoping for your valuable revert. Thanks In Advance.
Hello, Can you please explain why the time/clock disappeared after I closed the file? The clock display nicely but after I saved it and close everything and reopen the file. it disappeared and can not the clock appear again. Thanks
Hey, it seems I am incapable of making it past the first part of your video.. When I try to open the form with the OnTimer event coded as per instructed I get an 'Object required' error highlighting currentTime. Even though I have it declared and set in the very same procedure..
There isn't any special library other than the VBA library, and Access libraries that you have by default. It sounds like you may need to do a compact and repair.
Hey, thanks for the reply! Just did that and now it'll recognise the CurrentTime variable. However, VB is now telling me that the method or data member (.Caption) is not not found
Programming Hey, thanks for the reply! Just did that and now it'll recognise the CurrentTime variable. However, VB is now telling me that the method or data member (.Caption) is not not found
You are a master, doctor and magician of ms access.
Your one video give us lot of knowledge ,operations and cover different aspects of access.
You are giving lecturers without fee its show your dedication and devotion to us.. God bless you.
hi Steve. Just found this video.... FANTASTIC! I. New to learning Access and your explanation of these functions is great and gives me insight to what’s possible with my databases. Thank you Sir
Steve you are an outstanding instructor!
Brilliant work sir. I think your video lectures are one of the easiest and best ways for someone to learn Access 2013. I was familiar with Access 1995 version, (yes the one with Access Basic) and i wanna to familiarize myself with Access 2013. Thanks again for the great material you provide.
Fantastic! I'm glad you are enjoying the videos.
Thank you so much for putting all those tutorials together in a very decent way.
You are welcome!
frankly, you have made my career easier and than before,thank you so much
Thank you so much Steve. I watched your Access basic and advance tutorial. They are very useful to me.
Thank you ever so much for the fabulous instructional video Steve! Very much appreciated. It's been a most useful tool for me.
Thank you Steve. it's a wonderful exemple on how to use a timer in access
Thank you so much for the video. I can now automate lots of stuff in my databases. I really appreciate it. Thank you.
Happy to help!
Again an awesome video, i really enjoy watching and learning from your videos. i'm thinking about watching all your videos from 1 til i think 79, and creating a database with everything that your videos go through.
Well thank you! I do advise people to watch all of the beginner series so they can get the most benefit from Access and all of my videos on Access. Some topics can cover some pretty advanced concepts but if you don't yet understand all of the basics you can have a problem.
As always you are a life saver for my coding!
Hi Steve, Wonderful video.
I have an ask over here. How to shut down a custom Access application remotely with Timer on the form which will pop up to the user.
You may have to perform maintenance tasks on a Microsoft Access database, such as compacting or repairing, making backup copies, or making design modifications. Many of these operations require that all users exit the database. However, there is no built-in way to force users to quit Microsoft Access. Your input is highly appreciated.
Hi, this is nearly exactly what I need.
Were I to connect my Access DB to say "SQL Server Express", I could use Stored Procedures to have 1 particular Update SQL Statement run at a specified time and run through and Change/Add/Delete Dates, Check/Uncheck Fields etc. for all records in a particular table, right, or what that be done via a different mechanism than Stored Procedures?
I do like the creating commands at will option to as I may want, or have a need to, run that statement at some point throughout the day.
Thanks for the great video.
It is really great job thanks a lot for your efforts
Thanks for the video and the assistance, this was a huge help with my project. I have it working for my system but I do have an issue I am not sure how to handle. I have about 45 PC's in the company that utilize this program. Getting everyone out is a huge challenge if I need to work on the back end. I am looking to be able to set a time say 15 minutes in the future with the command docmd.save, docmd.quit. This works great for the frontend I am using, and it works great if the time is already set for someone that logs in, however any frontend that is already logged in, just ignores the alarm even though that alarm shows up in its listbox. I had to add me.lst.requery in order for the list box to update, it just doesn't seem to work. also when deleting a line, that throws a line deleted error on the other front ends. I tried encasing the delete function in the docmd.setwarning false/true. but that had no effect. its actually balking out in the code itself because its messing with the loop. I may be having issues, but believe me, this is a far cry from where I was this morning :)
in my boss's dept. his employees fight for who will run the import data procedure after 4pm. Looks like now I have a solution! thank you so much Steve!
You're welcome!
Thank you, Steve. It was very informative and well done.
Thanks! This is a small part of an idea I came up with to e-mail results of a query - I'd like to set it up to where there was no attachment if the query results were 0 - but this gives me a starting point
Thank you. This was easy and extremely helpful.
thank you its very useful
Thank you Steve I've watched all your basic and advanced tutorials and however i have a button called BackUp on the admin form which i want get a backup after each day of work. any backup button tutorials on writing a code to manually backup the database?
Another great video to learn from!! thanks again Steve. One question please. Does the form need to remain open in order for the command to execute? I have users, which often times, I keep reminding them to exit the database after they're done with tasks and not just leave it open and idling on their desktop. Is there a way for a system to execute command to close database (front end) if a user is not active.
The form does have to remain open, but you can make in a minimized window.
Awesome, awesome, awesome! Thanks so much for all you do!!
You're welcome!
Brilliant work. I just want to ask, can I set how many times a command will be looped?
Sure. Just keep the number of times the timer code has been triggered in a public variable, and the number of times you want it run in another variable. Then compare the two and if it equals or exceeds the number close the timer.
Programming Thanks a lot!
Very Exilant video Guide
Hi Steve! Congratulations and thank you for your classes. Steve how can I run a command to do check boxes checked when a timer event finishes?
Checkbox.value = true
That will set a checkbox value to checked.
I really enjoyed it, Thanks indeed
Thank you.
Great video, thank you for sharing!
Thanks for this video Mr. Steve, I have learned even more. But I am stuck in my database, confronted with a challenge.
I have a database that keeps track of records, where a user is expected to commence or initiate a process and complete the process before beginning another one. This process is done on a continuous form.
Example, I have about 5 fields in a continuous form, and if the Name field is Michael, and as he moves to the next field, where a drop down is, to select status as either COMPLETED or NOT COMPLETED, I want to code the form, such that if Michael Status in the status field is not selected as Completed, then he should not be able to initiate another process on d same form, I will appreciate a code that can tie the Name & Status field together, if the Name field is selected for any, he has to Continue and select COMPLETED under STATUS field before the same name can proceed to initiating another process.....
Thanks
hi. i think im looking up wrong videos but not sure the terminology for a production timing etc in access.
i have a task takes say 5 mins to produce 1 item. i start at 11.00am at 11.02am i pause job. at 11.42am resume job at 11.47am job ends. total time taken 0.07 mins vers 5min stand therefore 2min over target. how do i put that in a database?
Hi. Good day... Sir can you make sample video ofqueuing system in ms access? Thank you...
Question, since the recordset is only loaded when the form opens this will not work to use as an "scheduled task" type option will it? (I'm trying to come up with a cronjob type scenario)
Sir can u help me how to store items from listbox to database table in 1 row 1 feild ?
Thank you Steve
You're welcome!
Hi there thank you for the tutorial I was able to setup my functions to run at the specified time. My question is, I have a function that I have to run every 2 minutes. I tried creating one for 12:00:00 AM then copying it into Excel and counting by twos and using autofill. I then pasted it back directly into the table. The records pasted fine, but they do not seem to be executing properly. If I for example. delete the one I pasted for 3:10:00 PM then re-add it from the form it works, but wont work otherwise. I find it'll be really tedious to manually enter each and every one. I'm guessing it's a formatting issue between Excel and Access. Do you have any other suggestions?
I have the same problems , we will have add them one by one at least is one off .
Awesome video
Great Job!
Thank you!
Great Job
Hi steve,
if we to generate an email based on duedate from our records, how can we use a timer in this case.
thank's a lot steve.
You should watch my video on using timers to automate tasks. It's in my How To playlist.
Very good
Hi sir Greetings,
I am Using access 2007, i am struck with a query. Kindly Help. ( I am using rfid reader to punch an attendance, after a attendance is punched i want a timer based popup message that Mr. xyz your attendance is punched. After few seconds the popup should disappear and we can set focus to punching attendance again" I want to include timer based popup. Hoping for your valuable revert. Thanks In Advance.
Work Files link is not working. Any other link you may have?
Hello, Can you please explain why the time/clock disappeared after I closed the file? The clock display nicely but after I saved it and close everything and reopen the file. it disappeared and can not the clock appear again. Thanks
There is any possibility to add reminder for my documents expiry date with specific catagory before 15 days?
Sure.
Hey, it seems I am incapable of making it past the first part of your video.. When I try to open the form with the OnTimer event coded as per instructed I get an 'Object required' error highlighting currentTime. Even though I have it declared and set in the very same procedure..
Also the .caption property isn't coming up in intellisense, I'm guessing that I'm missing a reference library, which one does this require?
There isn't any special library other than the VBA library, and Access libraries that you have by default. It sounds like you may need to do a compact and repair.
Hey, thanks for the reply!
Just did that and now it'll recognise the CurrentTime variable. However, VB is now telling me that the method or data member (.Caption) is not not found
Programming Hey, thanks for the reply!
Just did that and now it'll recognise the CurrentTime variable. However, VB is now telling me that the method or data member (.Caption) is not not found
Sebastien Oguey Then you may be using a textbox instead of a label. If you are using a textbox then you want to use .value instead.
This only work if the form is open. But if it close then it won't trigger... How do I make that right?
The link is no longer available :(
hi i need the work please .thank you
Welcome How is the collection of clocks in Accesse
I"m afraid I don't understand your question.
Raise an event.
Very useful and , thanks for your effort